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

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

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

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

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

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