gateway connections

3 Topics

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.
Solved
Sue777
1 year ago Place Report Server
2.5KViews
0likes
7Comments
Gateway com banco de dados
Olá, na empresa em qual trabalho estamos como seguinte problema: O gateway está online e aparenta estar funcionando, porém quando vamos fazer a ligação, está dizendo que "O gateway ou origens de dados não estão acessíveis", abro o power bi desktop e consigo atualizar normalmente, mas no fabric acontece isso, o que posso fazer?
wagms10
2 years ago Place Report Server
665Views
0likes
2Comments
Unable to connect to database through Personal Gateway
Hello, I am having a connection issue with personal Gateway to our client database. One of our client stored their data in their database, and we managed their reporting through Power BI. Our client has created a credential and also added our IP address to whitelist to make sure we can access their data through Power BI. It worked on PBIX file and we can also refresh the data on desktop. But we want to automate the refreshing on Power BI service. So we have created a personal gateway (On Promise), but it pop up an error message when we try to connect. We have used the same credential as we used in Desktop PBIX file. It's not working through Gateway. Does anyone has the same experience? Is there any suggestion? Thank you in advance. Percy
Percy
3 years ago Place Report Server
795Views
0likes
2Comments