Dynamic M Parameters for SQL are here in Power BI! YES!!! Let’s revisit a Power BI solution and how we can take it to the next LEVEL using these!
LEVEL UP Power BI Conditional Drill with Paginated reports!
https://youtu.be/43CwBmaym8Q
Teo Lachev’s Blog:
https://prologika.com/power-bi-dynamic-m-query-parameters-reloaded/
Chris Webb’s Blog:
https://blog.crossjoin.co.uk/2022/02/20/tsql-table-valued-functions-and-dynamic-m-parameters-in-power-bi-directquery/
Documentation:
https://docs.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters