New SQL Connection and Power BI Service refresh

[Anonymous]

Hi,

I am trying to connect to a new SQL Server (desktop data refreshes fine) but I cannot seem to get the gateway setup correctly.

I am using the Sever and DB name that are in the desktop version and my network ID./password    You can see the error that I am getting at in the attachment

Does anyone know the right configuration?  Thanks

[Anonymous]

Hi @Anonymous ,

If you get an error after trying to connect, please provide a screenshot of the error.
You can check whether the following username and password for connecting to the database and the name of the database you want to connect to are correct.
If you want to connect to Azure PostgreSQL, I recommend that you use the virtual network data gateway instead of the on-premises data gateway to connect. For more information about how to connect, see the following documents:
PostgreSQL connector for the virtual network data gateway | Microsoft Power BI Blog | Microsoft Power BI
Connect PowerBI Service to Azure PostgreSQL for Flexible Server via Vnet data gateway - Microsoft Q&A

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.