Get list of reports for entire tenant with publisher and workspace with Powershell

[davidwc]

Hey guys,

So I just recently learned about the PowerBI powershell modules and commands. 

I am the admin for the PowerBI tennent and I was wondering if there was a way get a list of all reports in the organization with the following data points:

(Required)

• Report name
• Workspace
• Publisher

(optional)

• dataset
• created time

I was playing around with the Get-PowerBIReport -Scope Organization command and that just returns the report name, urls, and datasetID. 

Thanks

[collinq]

Hey @davidwc ,

The api capability (https://learn.microsoft.com/en-us/rest/api/power-bi/) and I don't think that there is one silver bullet in there for what you want.  I think you will have to run the GetReportsAsAdmin and then the GetReportUsersAsAdmin and then combine those results.