Forum Discussion
data democratization using power bi
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.
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.
Hi Greg_Deckler ,
If i pull the content using rest api then how i will present it to the user, will it be in the form of power bi report which updates dynamically as soon as new report or workspace is created? or it would be some document on sharepoint ? what are your thoughts on this?
powerbiexpert22 Well, oddly enough, you can't use Power BI to pull data from the Power BI REST API which doesn't make a lot of logical sense but that's how it is. Well, I guess you *could* use Python or R step. So one way would be to use PowerShell as a tenant admin using something like this:
Get-PowerBIReport -Scope Organization
That would then create a file that you could import into Power BI, do some data transformation and then build a report that lists out the links to the reports. However, none of that will help you with a custom access and approval workflow. Well, maybe but it would be pretty difficult to have the report be automated and would likely be very manual.
The other way would be either a Power App or custom website or an R/Python step in Power BI, which you could have it access the Power BI REST API by creating an access token. For a website/Power App since you have full availability to code, you could have the code automatically render the links to the report however you want and include buttons, for example, for requesting access to individual reports. With Power BI, it would likely be import mode and you would probably face the same challenges as before in terms of an automatically generated versus manual report.