Forum Discussion
Slicer doesn't update parameter
Dear all I have an Oracle Server i'm direct query'ing from PowerBi Desktop. When I create a parameter and give it a default value it collects the data from my server. When I bind the parameter to a ...
Hi ZeDe ，
Check if your operation involves restrictions
And to reference a query parameter in query statement Where clause, we need to modify Power Query below:
refer:https://community.powerbi.com/t5/Desktop/Query-Parameters-Not-Bound-Oracle-Database/m-p/334384
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi, I realize this is an old post, but I don't think that was the problem that ZeDe was trying to solve, nor do I think this extra bit of code (Number.ToText) is necessary if the parameter is correctly typed as text when originally created. It can also easily be changed by going to Parameters -> Manage Parameters -> Type: Text.