Weekly Roundup for January 11, 2021

MK_logo_horizontal_rgb.png

Chris Webb has a link to an interesting GitHub project where you query Power BI Premium (and Azure Analysis Services) via HTTP.

 

In November, Databricks introduced SQL Analytics. BlueGranite gives a quick overview of this and why it will be really important.

 

If you ever wanted to show, in a table, the top N items and a final row for “Others”, Alberto Ferrari shows you how to accomplish this in Power BI with some clever DAX.

 

Reza Rad has a terrific article explaining the different types of Power BI users, from central model developers to end-users.

 

Marc Lelijveld has a set of PowerShell scripts to export dataset- and dataflow- refresh metrics that you can then visualize for better management. This is great for Power BI admins.