Power BI Weekly Issue 116: 29th June 2021
It's monthly-Power BI-feature-time, and what an update! The Paginated Report visual is now here, finally bridging the gap between standard Power BI reports, Direct Query over Dataflows is now GA, and there have been changes to dataset discoverability such that those without permissions can view the dataset name and description and can subsequently request access to the dataset should they wish. We were also told about that The Power BI report action bar is now available in the Power BI SharePoint Online webpart, and that there are now long-term usage and performance insights (Public Preview) with Log Analytics integration for Premium workspaces.
Elsewhere this week, Darren Gosbell has announced that DAX Studio 2.16 has been released, containing numerous feature enhancements and bug fixes. Imke Feldmann has announced that Power BI Cleaner Gen2 is here, fixing bugs, improving performance and overcomes some earlier limitations. Finally, Chandeep Chhabra has written about Bottom N Analysis in Power BI, with some clever use of FILTER and RANKX.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Adam Saxton (@GuyInACube) discusses Natives Queries or ODBC with Incremental Refresh in Power BI
- Imke Feldmann (@TheBIccountant) highlights that Power BI Cleaner Gen2 is here
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes Power BI File Clean up In a Few Steps and writes about Trim Vs Clean in Power BI and Power Query
- On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes Exponential Moving Average in Power Query (EMA)
- Jon Acampora (@excelcampus) explains How to Reorder Multiple Columns in Power Query with Drag & Drop
- Melissa de Korte (@_EnterpriseDNA) describes How To Extract Record Field Values From Lists
- Also on the Power BI community blog, Shanthakumar writes about a Date Transformation Issue in Power BI Service
- On the Access Analytic blog, Jeff Robson describes how to Unpivot using Column Numbers rather than Names
- Allison Kennedy blogs about Text Analytics in Power BI
- Chandeep Chhabra (@chandeep2786) writes about Dynamic Unpivoting in Power Query
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Replace text with another column value in Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Darren Gosbell (@darrengosbell) highlights the DAX Studio 2.16 Release
- On the SQLBI blog, Marco Russo (@marcorus) talks about the New preview features in DAX Studio 2.16 – Unplugged #25
- Reid Havens (@HavensBI) talks All about DAX.do (with Marco Russo)
- Antriksh Sharma talks through the DAX Studio 2.16 Bugs Fixes and Improvements and on the Power BI community blog, writes about a Circular Dependency between Calculated Columns in a Table in DAX
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) explains How to return 0 instead of BLANK in DAX, talks about ADDCOLUMNS – DAX Guide and describes DISTINCT, VALUES – DAX Guide
- On the Enterprise DNA blog, Nick Mone describes Filter In Power BI: DAX Queries Context Transition, DAX Calculation – Filter Context Transitions and Power BI Filters: Invoking Context Transitions
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) lists the Top features in Tabular Editor 3 to boost your Power BI development
- Matthew Peterson (@mattpetersonbi) writes about Power BI: Time Intelligence Rolling Measures
- Chandeep Chhabra (@chandeep2786) covers Bottom N Analysis in Power BI
- On the Purple Frog Systems blog, Nick Edwards explains How to export more than 30,000 rows of data from Power BI Desktop.
- Dhruvin Shah (@DhruvinShah16) talks about the ALLSELECTED DAX Expression in Power BI
- Sam McKay (@_EnterpriseDNA) describes How To Create Custom Dimensions And Groups To Your Filtering Tables Fast In Power BI
- Brian Julius lists the Top 5 Tips & Tricks For Debugging Virtual Tables In Power BI
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #211: Add leading zeros to a column using DAX
- On the Power BI Community blog, Denis Selimovic (@DenSelimovic) answers Why is it sometimes not possible to select the exact number in the what-if parameter?
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Philipp Lenz (@lenz_philipp) writes about the Paginated Report Visual and exporting data for printouts.
- Reid Havens (@HavensBI) walks through Creating a Custom KPI Card Using Charticulator (w/ Daniel Marsh-Patrick)
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) discusses Power BI Bookmarks Tips, Tricks, and Best Practices
- On the Burningsuit blog, Alan Harman-Box describes Getting formatted text into your Power BI reports
- Also on the Burningsuit blog, Alison Box writes Charticulator in Power BI #5 and part #6
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) describes how to Design a custom chart inside Power BI desktop with Charticulator Custom Visual and explains How to embed Bot framework inside Power BI service dashboard
- Also on the RADACAD YouTube channel, Reza Rad (@Rad_Reza) covers Scope of Filter in Power BI Report and discusses Power BI Theme Customize Colors Fonts and Visual Appearance for Multiple Objects
- On the Enterprise DNA blog, Mudassir Ali shares a few blogs: Power BI Scatter Chart: Conditional Formatting, Power BI Donut Chart: Custom Visualization Tutorial and Power BI Heat Map: A Custom Visualization Tutorial
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Bhavik Merchant (@BhavikMerchant) announces long-term usage and performance insights (Public Preview)
- Chris Webb (@cwebb_bi) describes Increasing Refresh Parallelism -And Performance – In Power BI Premium
- Gilbert Quevauvilliers (@GilbertQue) writes about Incremental Refreshing – Part 4 – Migrating AAS to PPU
- Philipp Lenz (@lenz_philipp) describes how to Process SQL Analysis Services Cubes via the Azure Data Factory
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) writes the Power BI June 2021 Feature Summary
- Also on the Power BI blog, Patrick Baumgartner (@patbaum) highlights that The Power BI report action bar is now available in the Power BI SharePoint Online webpart
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 196 - June News Round-up
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.