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.
I have a doubt about the parameters in BI.
I have the next store exec Proc Proc_Demo where dFecha = @Fecha
Now in the powerbi i've already did a function with the parameter but i can't make a relation with other tble.
What i need to do is bassed on this parameter has a date in other table that i will use as a filter so in that way the user can refresh the store with that date.
Have any idea how to do that?