The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey all,
Just a quick overview of what I'm trying to accomplish, what I've done, and then what I see as the issue. I have a direct SQL query that takes parameterized values. I've created the two parameters and pass them over fine without issue. I've created lists of acceptable values for this. I've opened up model relationship view and bound the list to the created parameters. Whenever I select a value from the bound list, the parameter doesn't update. Other visuals (text boxes) update with the selected values, but the parameter and the visuals using the direct query will only use the default value I manually selected.
In BI desktop, I can click "Edit Parameters" and select a different value from the list, but it's pretty unintuitive and I do not believe that's an option for users in the web app.
Does anyone have any ideas?
-Ray
I have the same problem, did you ever fix it?
Hi @Doghouse ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
Hi @Doghouse ,
I can't reproduce your problem, please check the below screenshots about my testing results. Could you please provide some screenshots with parameter setting? And could you please explain where you applied the parameters? Thank you.
Power BI Desktop side
Power BI Service side
Best Regards