Direct Query & Paramters

[Incarnadine]

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

[Greg_Deckler]

@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

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/power-bi/end-user-editing-que...

[Incarnadine]

@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.

[Greg_Deckler]

@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)

[Incarnadine]

@Greg_Deckler  - I'm using PBI Embedded. I had it all working fine using Import mode - issue was the dataset can't be refreshed simultaneously by multiple users. I was able to use the below query to pass the parameter through however this functionality doesn't seem to exist in Direct Query (Which would allow multiple users to refresh data simultaneously)

let
Source = Sql.Database("ServerName", "Databasename",
[Query="EXEC StoredProc "&Parameter])
in
Source

[Greg_Deckler]

@Incarnadine Let me see who I can call in on this @dm-p