Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I'm trying to add parameters in my queries to reduce the size of the retrieved data and create this parameter as a slicer in the dashboard, this is because I need this parameter available in the dashboard to allow the users to filter the data, but for some reason, I can't bind the table to a parameter, I am using the ODBC connector to pull the data
Solved! Go to Solution.
Hi @Anonymous ,
As far as I know, ODBC connector could only load data by import connection mode.
Dynamic M query parameters give model authors more control over the filter selections to incorporate into DirectQuery source queries.
For reference:
Dynamic M query parameters in Power BI Desktop
So you couldn't use dynamic m query parameters in your report.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
As far as I know, ODBC connector could only load data by import connection mode.
Dynamic M query parameters give model authors more control over the filter selections to incorporate into DirectQuery source queries.
For reference:
Dynamic M query parameters in Power BI Desktop
So you couldn't use dynamic m query parameters in your report.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |