Forum Discussion

Ermin's avatar
Ermin
Advocate II
9 years ago
Solved

Power BI Embedded and multitenant support

  Hi all, We’re are developing a multitenant application with a set of Power BI reports where our clients would be able to see only their data and KPIs relevant to them. Additionally they would be ...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    What I would recommend would be to do another import of your data but summarize the data in Power Query such that all of the details are removed and then base your measure calculation (if needed) on that table. So, for example, you could do a "Group By" in Power Query to remove row level detail. Then, give everyone access to that table in RLS, or portions of the table that are relevant. For example, if you summarize by industry and only want them to see the measure calculated by their particular industry.

Ermin's avatar
Ermin
Advocate II
9 years ago

First of all thanks on a fast response Greg_Deckler.

 

This is an interesting approach. I need to figure out how this may work in my case, since I’m not talking about one data source but multiple sources. However, there is definitely a potential to do something in that direction.

 

I was in the meantime testing another approach. I didn’t not use RLS but rather a hidden slicer which will then make sure that a user sees only his data. The measures would still work the across the  complete data set.  

The problem there is:

  1. How to hide a slicer in power BI?
  2. How to set it to a default company depending on the user using the dashboard?

 

Don’t forget we’re talking about application containing power bi embedded.

It’s hard to believe that no one out there had a similar problem. Multi—tenancy should be a quite common scenario.  :smileywink:

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I just posted the same question HERE

 

We are having the same issue. 

 

Greg_Deckler I think we need a more general solution to this. Ermin you can use visual level filter instead of slicer AND instead of row level security, but I am not sure if this is completely secure. Greg_Deckler is it possible to change the visual level filter thourgh the JavaScript API? If it is, then anyone can get the isntance of the embedded component and change the visual filter. Or any other filter. We have very strict data access policy. (BTW the export data from the embedded report is another issue for us). 

 

I think row level security is the only secure approach.