Forum Discussion

Incarnadine's avatar
Incarnadine
Frequent Visitor
5 years ago

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....
Need Help
Incarnadine's avatar
Incarnadine
Frequent Visitor
5 years ago

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's avatar
Greg_Deckler
Community Champion
5 years ago

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's avatar
    Incarnadine
    Frequent Visitor
    5 years ago

    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