Power BI dynamic M query parameter support
Published date: November 03, 2020
Azure Data Explorer is a superfast analytics service that unlocks snappy data exploration use cases. As such, we aim to make our dashboard integrations as efficient as possible, specifically, the integration with Power BI. Customers have been asking for dynamic parameter binding in Power BI. Now, we’re making this available in public preview as part of the October Power BI desktop release. 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 large dataset, or using complex query logic.
To unlock this dashboard, the author must 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 values to that parameter and bind it to the parameter. Once done, you can use that parameter in report slicers and filters to get the performance effect users are expecting.