Weekly Roundup for October 26, 2020

MK_logo_horizontal_rgb.png

The October 2020 update to Power BI Desktop is out! Be sure to check it out.

 

In case your were interested in using the Power Automate Desktop tool, you can find several Microsoft-created “Getting Started” videos.

 

Adam Saxton has 3 tips for improving the performance of your Power BI report refreshes.

 

AI Builder capabilities in Power Automate are now generally available. This will be really helpful for anyone who wants to automatically process invoices, for example. There are tons of use cases.

 

Patrick LeBlanc has 5 great tips to take into account whenever creating a report in Power BI. Give it a watch!

 

I really enjoyed this video (and article) from Matthew Roche (aka BI Polar). He talks, at a strategic level, about how not every BI solution needs to be made into an enterprise-grade “production” solution and about how to think about that distinction.

 

Marco Russo has a really neat and simple trick to improve your date tables in Power BI that will eliminate the need for sort-by columns.

 

Marc Lelijveld has an interesting article explaining how to query session metadata via the XMLA endpoint. This is strictly for admins of a tenant with Premium capacity, but I could see all kinds of use cases.

 

Reid Havens has a video with an interesting way to animate buttons using animated GIFs. I liked the Millennium Falcon one!

 

I thought this was a great idea for setting up data-driven paginated report subscriptions. This is important when you have a lot of paginated reports that you manage. I could envision some great use-cases by incorporating PowerShell or logging. Also, being a SQL person myself, that’s probably where I would store the information.

 

One of the biggest factors in the success or failure of Power BI (or, really, almost any new tool) within an organization is the culture around that new tool. Matthew Roche is one of the few (maybe only) people communicating on this very important topic, and I’ve really enjoyed sharing in his wisdom.