Weekly Roundup for December 21, 2020

MK_logo_horizontal_rgb.png

The December 2020 update for Power BI is out!

 

Microsoft is releasing an invoice-processing feature in AI Builder. Can’t wait to try this!

 

I thought this was a great, quick tip by Soheil Bakhshi: adding SQL Server Profiler as an external tool in Power BI Desktop.

 

Many people, including myself, have been waiting for this update to Power BI: Small Multiples.

 

This has been referred to as the biggest update to Power BI since it was first released. Marco Russo called it the Holy Grail of BI. I don’t know if I would go quite that far, but this is definitely one of the biggest enhancements I’ve seen. You can now combine different types of data sources, like a Power BI dataset, an Excel file, and a table in SQL Server, and then layer your own metadata on top.

 

There is now a Dataflows connector within Power Automate. This means that you can programmatically run refreshes of your dataflows, for example, when an upstream data flow completes. You could have the successful completion of a dataflow trigger the refresh of a Power BI dataset. You could also have a dataflow refresh-failure trigger email notifications or the creation of a support card.