Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Ask your tenant admin to run the inventory for you.  Much simpler that way.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community 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 Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.