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.
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,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
i am having same issue.
i developed one dashboard with Direct Query. i created one parameter in power bi (associated with slicer) which i am passing to table valued function in sql server.
in my local machine its working fine. but once i am deploying to reporting server. slicer values are not refreshing.
in the below screenshot please see i created parameter1 as Text. and then in the other screenshot i am binding to Parameter1.