When these AI offerings first come out, they don’t always function as promised, but I will be interested to see how this evolves. This is the first step in a broader commitment to writing code via natural language to empower even more citizen developers. Microsoft does caveat that the scope is currently narrow, but they are working on expanding that.
Even if you don’t have a need to refresh a single table in your Power BI dataset, you should watch this video. Patrick Leblanc walks you through several nice ways to interact with your model via a number of tools, including SSMS, Tabular Editor 3, and scripts. I especially liked the integration with Azure DevOps.
Matt Allington has a neat trick to rename several columns simultaneously in Power Query. It uses a list of lists created within the same query.
I wish I had known this since the beginning. You know how how Power BI doesn’t show dimensions for which there is no data? ADDMISSINGITEMS allows you to very easily put them back in.
If your Power BI report is slow, Adam Saxton walks you through the basic steps to measure its performance and see what’s taking up the most time.
Reid Havens has an extension of a video he did last week, this time allowing you to switch the category by which you break down the waterfall and to switch between a dynamic value and 0 for Y axis start.