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.

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

Hi guys,

 A short update from my side. Based on the solution proposal from @smoupre I think I have a good enough implementation.

 

I ended up creating an additional sub model of pre-aggregated data. The Power BI “GROUP BY”   functionality in Query Editor helped a lot.

 

The solution for me was:

  1. Use RLS to limit the access only to the user company data
  2. Determine measures/values that a user would need to see aggregated for all other companies (tenants)
  3. Determine dimensions (slicer values or categories in the visual) we need to see for all companies
  4. Use “Group By “ function to create additional data sources containing aggregations of measures across dimensions calculated below.
  5. At the end you get a sub-model of tables that are not collected to your main power bi model
  6. Enjoy playing with a safe way to compare your company data against aggregated others J

 

Note: Depending on the amount of data the “Group by” functionality tends to be extremely slow. I ended up creating views/ queries in the database which delivers aggregated data so that I don’t need to use Group By. Group BY in power BI is useful to test the approach or if you don’t have access to the database or if your data source is not a database.

 

@smoupre, thanks for the idea.