Weekly Roundup for September 21, 2020

MK_logo_horizontal_rgb.png

You can now use Power Automate to export Power BI reports and paginated reports in the Power BI Service.

 

The Power BI Service is getting a UI refresh. I guess I better get familiar with the new design.

Microsoft and Databricks: Top 5 Modern Data Platform Features — Part 1

Megan Quinn with BlueGranite has a really interesting article out about two major updates to Databricks: Spark 3.0 and Delta Engine. I’m looking forward to Part 2, in which she will cover enhancements from Microsoft.

 

I can’t tell you how many times I’ve had to create a Date Table without access to one in a database, recreating it in PowerQuery. What happens when your fact tables have dates with different minimums and maximums? How do you handle that? Soheil Bakhshi has a PQ command that can help with that.

 

Best practices for enterprise-grade Power Automate and PowerApps solutions necessitate having different environments for each solution and even, at times, different environments for Development, QA, UAT, Prod, etc. Moving changes from one environment to another has always been tedious. It is about to get much easier!