The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
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
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.
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
Hi @jeremyg ,
If you use fiddler to trace powershell request, can you trace some details error message about that request?
In addition, you can also post to develop forum to get better support.
Regards,
Xiaoxin Sheng
Can we get the error message in powershell which we get from fiddle during trobleshooting, i dont get much infromation except status code 400, etc
in fiddle we get like below error message
{"error":{"code":"InvalidRequest","message":"Invalid dataset refresh request. Another refresh request is already executing"}}