Forum Discussion
data democratization using power bi
powerbiexpert22 Well, for visibility, you could share datasets, etc. with All Company group or something similar. However, this will actually give them at least read access to it. So, if you want to expose content items that they do not already have access to then I think you are going to need to create a separate site that exposes this information. You can get this information from the Power BI REST API's. Perhaps something like using a PowerApp or Power Pages to do this would work (or just any old website) and the workflow could be handled by Power Automate.
Hi Greg_Deckler ,
thanks, how I would give shared dataset access to all company group? can it be done for reports also?
what do you mean by exposing content items?
I am not sure if I can utilize apps feature for this however if we use apps then we need to first create apps for all existing reports which would be additional task for me
powerbiexpert22 Well, I Azure tenant came with an All Company group with an email address of allcompany@[tenant].onmicrosoft.com. So, in theory you could share a content item with that group and then everyone would have the rights you specify to that item. Or you could use a similar, not built-in group, an "everyone" group.
Power BI has built in features for "Automatically Install App" and "make all content discoverable". The very first thing we did in our company was to shut both of these down. There needs to be a balance between making it easy for users to discover data subjects and reports, and inundating them with hundreds of thousands of reports they may not need.
Hi Greg_Deckler ,
how i would provide a consolidated view of all reports, worskpaces and datasets ?, think this like data catalog of reports which would provide consolidated view of all BI reports information
powerbiexpert22 In the Service, there is a Browse feature as well as OneLake Data Hub. However, these are only for content that they have access to. If you want to expose content that they do not have access to, that is where you will need to build that yourself and populate this information via the Power BI REST API.
