Forum Discussion

GarethNW's avatar
GarethNW
New Member
3 years ago

Problem publishing Report that uses a separate On prem dataset via PowerShell

My goal is to set up an Azure DevOps pipeline that can publish a report to the Development workspace.   The below code uses a service principle account to authenticate and then successfully publish...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi GarethNW ,

The error message "New-PowerBIReport: Operation returned an invalid status code 'BadRequest'" usually occurs when there is an issue with the request being sent to the Power BI service. One possible cause could be that the service principal being used does not have the necessary permissions to publish the report. You can check the permissions for the app in the Azure Portal by running the command "Get-Help Connect-DataGatewayServiceAccount -Examples". For Service Principal Scenario, use the "Get-Help Connect-DataGatewayServiceAccount -Examples" to get information about the permissions on the azure portal. In the Azure portal these will show as the Permission names "Tenant.Read.All" and "Tenant.ReadWrite.All" with the "Application" type under the Power BI Service API.

Another possible cause could be that the report name already exists in the Power BI service and is connected to the same dataset. In this case, you can try publishing the report with a different name.

Best Regards