Forum Discussion
Working with Functions or Stored Procedures on Direct Query Mode
Hi Anonymous ,
"Any" or "Binary" type parameters work in Power BI Desktop, but we currently don't support them in the service, for security reasons. You can use "Date/Time" type, then users can change these dates on the PowerBI Service.
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
https://docs.microsoft.com/en-us/power-bi/connect-data/service-parameters
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry for the late response ,
Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs
That link show the solution what I needed but unfortunately it's not supported on T-SQL based sources.
I wonder if there is any other solution or way to workaround or trick that end user can manipulate m query with dynamic parameters in Power BI service.