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