Forum Discussion
Using Parameters to bring dynamic data
Hi, We have a table which is terribly large so we want to bring in only the data that matches what a user clicks on in a table. I've created the Data Parmeter, and my M Code shows the parameter is...
Hi Anonymous ，
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create query parameter
2. Add filter
= Sql.Database("xx", "xx", [Query="select * from xx where Page_URL='"&Page&"' "])Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Solved: Use table values as a parameter - Microsoft Fabric Community
3. Change the parameter name
Best Regards
Only works for Direct Query data sources
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
But this will work for Databricks queries as well, correct?