Forum Discussion
Dynamic M query Parameter to SQL Source Not Working in Web Service Version of Report
Hello, I have created a dataset that uses direct quert to sql server with the new dynamic M query parameter feature. The overall model uses a live connection to a power bi dataset and some direct...
Hello according to your post, I think you tried to set up a dynamic source query solution (I don't know if in import or DirectQuery mode), I want to put a dynamic query solution for a user on the power BI service, when he opens the report, the query only loads the data for its region
(a dynamic solution to avoid loading all the data) is it possible?
https://community.powerbi.com/t5/Power-Query/dynamic-parameter-value-in-sql-query-source-power-bi/m-p/3006404#M95205