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
not sure what is PowerBI RS? Currently on desktop version september 2023..
lbendlin
Super User
Super UserThere are two different Power BI Desktop versions. One "regular" version for publishing to the Power BI Service, and one Power BI Desktop RS for publishing to on-premise Power BI Report Server. The latter has reduced functionality.