Forum Discussion
M query dynamic parameter
Hi Anonymous ,
According to your statement, I know you get data from excel file by import connection mode.
As far as I know, dynamic M query parameters give model authors more control over the filter selections to incorporate into DirectQuery source queries.
So I think you need to connect to the data source which supports DirectQuery connection mode to use this feature.
For reference: Dynamic M query parameters in Power BI Desktop
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to your statement, I know you get data from excel file by import connection mode.
As far as I know, dynamic M query parameters give model authors more control over the filter selections to incorporate into DirectQuery source queries.
So I think you need to connect to the data source which supports DirectQuery connection mode to use this feature.
For reference: Dynamic M query parameters in Power BI Desktop
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,
I have premium license with June 2024 desktop version. I only created a new parameter, a table with one column which included possible value in the parameter. however, I still can't find Binding to parameter for the field in the table property advanced. Does this issue be resolved?
Ellenwan , please create a new post with your question, instead of replying to a post that is over a year old and already has an Accepted Solution.
If your requirement is solved, please make THIS ANSWER a SOLUTION βοΈ and help other users find the solution quickly. Please hit the LIKE π button if this comment helps you. Proud to be a Super User!
