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....
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)
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
Incarnadine Let me see who I can call in on this dm-p