Hello,
I'm trying to create a report that shows all the reports we have built in Power BI. We are doing this because organisational users do not know what we have built, and I thought we could create a living documentation report that would get all the reports in our workspaces and the description attribute that goes along with it. This way they could see a summary of the reports that existed and know what to request. It would be updated automatically each time a report was added to a workspace. Also sometimes we are moving reports to new workspaces and this would also allow people to find a report that had moved.
I am using PowerShell and contacting the Power BI API.
This documentation shows that the Description attribute for each report is present.
https://docs.microsoft.com/en-us/rest/api/power-bi/reports/get-report
But when I run the PS cmdlet Get-PowerBIReport -WorkSpaceId $workspace.Id from MicrosoftPowerBiMgmt the description tag is not returned along with the report object. Is there another way I can get the Description tag for each report?
I can see in the documentation it says
"A Power BI report. Below is a list of properties that may be returned for a report. Only a subset of the properties will be returned depending on the API called, the caller permissions and the availability of the data in the Power BI database."
Seems like this attribute is not included
This is broadly what I'm doing
$userName = 'serviceaccount@company.com'
$p = ConvertTo-SecureString -AsPlainText 'pw' -Force
$credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $userName, $p
Connect-PowerBIServiceAccount -Credential $credential | Out-Null
$workspace = 'WorkspaceName'
$workspaceObj = Get-PowerBIWorkspace -Name $workspace
$reports = Get-PowerBiReport -WorkspaceId $workspaceObj.Id
foreach ($report in $reports)
{
$report
# Insert into table
}
Once I have the report information I was going to put it in a SQL table and query it back out to Power BI via a report.
If there's a better way to display what Power BI reports have been created, like if Power BI can connect directly to the Power BI API and get what it needs. Am happy to try something else.
All the best,
