Power BI dynamic M query parameter support

This post has been republished via RSS; it originally appeared at: Azure Data Explorer articles.

Azure Data Explorer in a superfast analytics service that unlocks snappy data exploration use cases.

As such, we aim to make our dashboard integrations as efficient as possible and more specifically the integration with Power BI which is a heavily used BI service in conjunction with ADX.

For long time you have been asking for dynamic parameter binding in Power BI and we have been listening and discussing with Power BI team.

We’re very happy to announce that this is now available in public preview as part of the October Power BI desktop release.

For more details please read the Power BI blog post - https://powerbi.microsoft.com/en-us/blog/power-bi-october-2020-feature-summary/#_Toc52195564

This important feature allows Power BI users to create filters and slicers in reports in a much more performant way.

By default, when using a report filter, the filter operation is added at the tail of the derived Kusto Query Language (KQL) query, which is significantly less efficient in some cases.

The new capability allows users to explicitly inject the filter at the designated place in the query and improve query performance by a few factors, especially when the report is built on top of a very big dataset, or using complex query logic.

To unlock this the dashboard author needs to create a M Query Parameter, and reference it in the M query.

The author then needs to create a table with a column that provides the possible value to that parameter and bind it to the parameter.

Once all of this is done you can use that parameter in report slicers and filters to get the performant effect users are expecting.

 

PBI.png

Kudos to Power BI team that worked on designing and implementing this important report performance optimization.

This is now in public preview and we’re looking forward for your feedback.

Kusto team

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.