Forum Discussion
Direct Query & Paramters
Hi,
I have a dashboard that will be embedded into my company website, users will login to the website and an ID will be passed to the dashboard using microsoft API to filter the data accordingly. I originally tried with my data called through Import Mode, however since refreshing the dataset is asynchonous and I will have multiple users accessing at once this is not possible.
I then tried using Direct Query however I can't seem to call a stored proc and pass a parameter through, is this possible? If not are there any workarounds?
Thanks
5 Replies
Incarnadine Check the roadmap, I thought there was something on the roadmap for parameter support for Direct Query:
https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/power-bi/planned-features
Greg_Deckler - Thanks for your response however I don't think it will work in my situation.
The dashboard will be accessed by external companies and the token needs to be passed to the dashboard in the background as opposed to a slicer selection mentioned in your suggestion.
Incarnadine Not 100% on your situation but it sounds like you should be using RLS or that you should be using Power BI Embedded (A SKU's)
