data democratization using power bi

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.