Forum Discussion

malikirfan28's avatar
malikirfan28
Helper II
7 years ago
Solved

Dynamic Data Source based on dynamic parameter from login user session

Hi All, We have mulitple clients with separate copy of exactly same database schema on same SQL Server. I know how to create parameterized query within Power BI Desktop and then build separate copy ...
General Comment
Need Help
Show and Tell
Tips and Tricks
GilbertQ's avatar
GilbertQ
Super User
7 years ago
Hi there

What I would suggest doing is to have all the data in one SQL Server table or ideally build an SSAS or AAS tabular model. You can then have all the reports accessing this tabular model.

You can then configure Row Level Security and based on which user logs in, you can then only show them their data.
This will allow you to only create 1 dashboard and 1 report.
malikirfan28's avatar
malikirfan28
Helper II
7 years ago

Hi GilbertQ ,

Thank you for your message. How can we use this RLS with custom application? As mentioned before, we have App Workspace in Power BI Service through which we are embedding dashboards into our Custom Applications (ASP.Net MVC). So how can we pass this Role information from Custom Application to Dashboard?

 

2nd: I believe, RLS feature will work if Dashboard is using Direct Query. Right? 

 

3rd: These dashboards will be readonly (we manage it through our custom application) however our App Workspace is configure to allow end users for Edit/Update dashboards (not these but other type of dashboards). So will it have any implication?

 

Thanks 

 

 

    • malikirfan28's avatar
      malikirfan28
      Helper II
      7 years ago

      Hi GilbertQ ,

      Thank you for your support.

      However I couldn't understand your point 3 reply. Can you please give some detail. 

       

      Thank you.

      • GilbertQ's avatar
        GilbertQ
        Super User
        7 years ago
        Hi there

        Currently people who are a member of an App Workspace do not have RLS applied to them when they view the reports or dashboards.