Forum Discussion
connecting to dynamic web url - problem with m query
Hi Anonymous ,
As far as I know, dynamic M query parameters are only available for DirectQuery mode, not for import mode.
Dynamic M query parameters in Power BI Desktop (preview) :
With Dynamic M Query Parameters, model authors have more control over how filter selections get incorporated into DirectQuery source queries.
And your data source (web and csv) does not support DirectQuery.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandakwhat do you mean when you say what is my source?
It's a "web" source, as in a link to an internal server that exctracts data from my database.
It returns a table based on a script in said server.
I'm honestly not sure how else to explain it. I know they have this working with an excel sheet, but no one in my team knows how it was set up, it's an old file that everyone just changes a bit over time, but the source is still the same since the last 4/5 years, and now i have to move it to a powerbi solution somehow.
I know there is a simpler way to extract the data from my database, but that is how it is set up right now and it's not in my power to change it yet.
Community SupportHi Anonymous ,
As far as I know, dynamic M query parameters are only available for DirectQuery mode, not for import mode.
Dynamic M query parameters in Power BI Desktop (preview) :
With Dynamic M Query Parameters, model authors have more control over how filter selections get incorporated into DirectQuery source queries.
And your data source (web and csv) does not support DirectQuery.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.