Passing Dropdown Selection to a SQL Function or Procedure.

[TheCenturion]

Hi

My SQL Function needs a Parameter @Language to be passed. 

Here in Switzerland most things are at least in 3 Languages(German, French and Italian) + also English.

I have a Dropdown with the Values: G, F, I and E.

I would like to pass it to my Function so that i only get the French Values back, for example.

This worked so well in MS Reports.

I see a lot of posts that say it doesn.t work, but those posts are also quite old sometimes.

Thanks for the Help 🙂

Best Regards

-Boris

[lbendlin]

They are slowly going in that direction.  Have a read here and see how far that helps.

Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs