Forum Discussion
Power Shell command to extract Power BI Reports from Workspace.
Hi All,
I am hitting an error when I try to scan through all the workspace in my organization stored in a text file and retrieve all the power bi reports using the power shell command. Even I don't export to a text file, it runs for a while and then throws the same error.
I read in another thread it could be due to the tenant being busy. I tried executing this command at different times periods and it always results in an error. Is there any way to fix it?
Basically, I need to extract all the workspaces and artifacts under it in an excel or CSV format. So I extract a workspace id first and then copied to a text file and scan through it to get the report details.
foreach($line in Get-Content "C:\Mohan\PBIDetails\WorkspaceId.txt") {
if($line -match $regex){
#write-host $line
Get-PowerBIReport -Scope Organization -WorkspaceId $line | Export-Csv -NoTypeInformation –Path 'C:\Mohan\PBIDetails\pbreportws1.csv'
}
}
The input file has list of workspace id's which i have extracted using another script. Its just a single line of workspace id's.
2 Replies
- lbendlinSuper User
Ask your tenant admin to run the inventory for you. Much simpler that way.
- v-lionel-msftCommunity Support
Hi Anonymous ,
I created a similar script but I did not reproduce your problem.
Try to run this command directly and set the value of the parameter ‘-Worksapce’ to a fixed value. If there is no error, then there is a problem with your other code.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.