Weekly Roundup for August 24, 2020

MK_logo_horizontal_rgb.png

Belinda Allen, Microsoft MVP and leader of the Charleston Power BI User Group, will be presenting on the state of AI in Power BI Desktop on Thursday, September 10. I've seen this presentation before, and it was truly informative. Be sure not to miss this one!

 

The October Release Wave 2 updates for PowerApps are out.

 

I didn’t realize that the August 2020 version of Power BI Desktop has a Power Query function called Table.AddFuzzyClusterColumn. This is a great way to clean up dirty data, and would be best used in Dataflows, so that you only have to clean up the data once. Daniil Maslyuk has a brief introduction to the new function.

 

When using the Analyze in Excel function of Power BI, any data sensitivity labels used in the dataset to which Excel is connected will now flow through to the Excel pivot interface.

 

For several years now, you have been able to import an existing PowerPivot model in Excel straight into Power BI for an instant dataset. Patrick LeBlanc shows you how to do this in both Desktop and the Service along some best practices.

 

External Tools is perhaps the biggest update to Power BI Desktop since it came out. It really is revolutionary within the Power BI authoring experience. PowerBI.tips has several additional external tools. They’re definitely pushing their website, but it’s worth checking out.