Failed to publish Power BI Report (DirectQuery + Gateway)

Hi Sue777 ,

Please ensure that you have access to the client server. Without appropriate access, you may not be able to modify the gateway or update parameters as expected.

If you do not have access, kindly reach out to the client and request the necessary permissions. Without access, we will not be able to make changes to the server details on the on-premises data gateway.

Since you cannot connect to the client's SQL server from your device, updating the SQL server/database parameters directly in Power BI Desktop is challenging. Here are some potential solutions:

-->Create a parameter table in your Power BI model where you can store the SQL server and database parameters. Use these parameters in your queries instead of hardcoding the server names. This way, you can update the parameters without connecting to the SQL server.

If these workarounds don't help, I suggest reaching out to Microsoft Support by raising a ticket. Microsoft will analyze backend logs and provide a resolution

Below is the link to create Microsoft support ticket:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
B Manikanteswara Reddy