My Favorite Power BI Desktop February 2022 New Features

Last week it was that time of the month again! No not that time.
I mean time for the Power BI February 2022 Feature Summary blog post by Jeroen ter Heerdt of course.

Dynamic M Query Parameters

The new thing is that dynamic M Query Parameters now supports SQL Server (and more data sources). There are several use cases that come to mind and a few people have already blogged about this:

• Teo Lachev (@tlachev) talks about calling a Stored Procedure with a parameter, and the requirements you need to meet and consider to pull this off
• Chris Webb (@cwebb_bi) has a similar approach, but uses a T-SQL Table-Valued Function with 2 parameters

The high level steps to dynamic M query parameters are:

• The source (SP/TVF) has to be in DirectQuery mode
• Create a parameter(s) in PQ
• In the model view, bind that parameter(s) to the column in your datamodel
• And then use the parameter(s) in your source in PQ

If you want to read up on all the features, supported datasources, limitations and risks, go read the documentation on how to use dynamic M query parameters.

New mobile formatting options

If you're into mobile formatting for Power BI, you're going to love this update. There's a lot more you can configure, now also independently from the web version.

To enable the new mobile formatting pane, the blog post says you'll have to enable the preview feature under Options, but after my installation of the February update it was already enabled:

And more...

Of course there's a lot more in the February update, to mention a few:

If you haven't started using Goals, there are more updates to it, including:

• Teams notifications integration,
• Multiple owners for a single goal and 
• The ability to create scorecards in My Workspace

Deployment Pipelines enhancements: there's a (fairly) new Azure DevOps extension and multiple pipelines working together, for example for disconnected reports and datasets

Download .pbix improvements: starting with this release you can download a .pbix file in more scenario's. Specifically, if a report is connected to a dataset that is configured for large models, incremental refresh or has been modified using the XMLA endpoint, you are now able to download that (connected) report, so not the dataset itself 😉

Read up on all the gotcha's and limitations of this export to PBIX.

Now go download that new update and check it out ourself! 😀