badrequest
1 Topic
Failed to publish Power BI Report (DirectQuery + Gateway)
The issue: 1. When I'm attempting to publish the .pbix file (data load with direct query) through the Azure DevOps pipeline, the Power BI Service returns a BadRequest error. This error occurs even after updating the SQL Server and database parameters to the client’s specified gateway-compatible values. 2. I also notice that, the .pbix still reference the on-prem servers that I used to test locally, they exist in the data models. The thing is I cannot connect to client's SQL server from my device, so PowerBI desktop throws error that wouldn't let me apply the changes, save without apply didn't work. The old connections remain in the file. I tried with one BI report, where I change all the direct query into import mode, then it works and successfully published. But I'd better keep the direct query bc in some reports the dataset can be very large. Is there any way that I can update the Sql server / database parameters withouth actually connecting? Thank you for your time and attention.Solved2.5KViews0likes7Comments