Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 50 | |
| 44 | |
| 42 | |
| 19 | |
| 19 |
| User | Count |
|---|---|
| 69 | |
| 68 | |
| 32 | |
| 32 | |
| 32 |