Forum Discussion

jeremyg's avatar
jeremyg
Advocate I
7 years ago

Powershell PowerBIMgmt - WriteError

Hi, 

In PowerShell, using the Microsoft.PowerBi.Management Cmdlet API,
https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps

When i want export Report with command Export-PowerBIReport ,
something went wrong and said status code 404 'not found'.
- Report Id is good. âœ…
- Path OutFile is working with other command. âœ…

PS> Export-PowerBIReport -Id b0f8c75d-24b2-4eb3-f0b0-19bc4f3cd7e6 -OutFile C:\Temp\Production.pbix
Export-PowerBIReport : Operation returned an invalid status code 'NotFound'At line:8 char:5
+ Export-PowerBIReport -Id $space.Id -OutFile $name
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...rtPowerBIReport:ExportPowerBIReport) [Export-PowerBIReport], HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'NotFound',Microsoft.PowerBI.Commands.Reports.ExportPowerBIReport

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jeremyg ,

    Is there anything special on your report? If you test on service side, can you find export option on that report?
    In addition, did this issue only appears when you use current id and path?

    Regards,

    Xiaoxin Sheng

    • jeremyg's avatar
      jeremyg
      Advocate I

      Yes, I can export the report from Powerbi service, we are looking for backup automotion,
      and no issue with path, this work with other commands.

      • jeremyg's avatar
        jeremyg
        Advocate I
        Connect-PowerBIServiceAccount
        Get-PowerBIDatasource -DatasetId c972ee60-37c9-b446-846f-9b4224166e3e

        Return same error,
        but bypassed below with commands REST API, i get results

         

        Connect-PowerBIServiceAccount
        $headers = Get-PowerBIAccessToken
        $Uri = 'https://api.powerbi.com/v1.0/myorg/groups/ --- [WORKSPACE ID] --- /datasets/c972ee60-37c9-b446-846f-9b4224166e3e/datasources'
        Invoke-RestMethod -Headers $headers -Uri $Uri