The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
To connect to Synapse I use a proxy server indicating the address and port.
The issue occurs when trying to get data into PowerBi deskpot from Synapse . I select the data source option 'Azure Synpase Analytics SQL' but even though I have the proxy server active on my computer, it does not connect.
I've seen a couple of threads talking about this problem but I can't find a solution. I would like to know if it has already been solved. My PowerBi version is: 2.120.963.0.
Thanks in advance!
Hi @Anonymous ,
If I understand correctly, it seems that you can't connect to Azure Synpase Analytics in Power BI Desktoop. There could be several reasons why you’re unable to connect to Azure Synapse through a proxy in Power BI Desktop:
1. The proxy authentication server on your network blocking the web requests issued by Power BI Desktop
The option1: Ask your network administrator to add the following domains to the allowed list on the proxy authentication server: app.powerbi.com, api.powerbi.com, and domains in the *.analysis.windows.net namespace. If you are using a government cloud, you can add the following domains to the allowed list: app.powerbigov.us, api.powerbigov.us, and domains in the *.analysis.usgovcloudapi.net namespace.
Add Power BI URLs to allowlist - Power BI | Microsoft Learn
The option 2: use system default credentials for web proxy
Using default system credentials for web proxy
2. Authentcation problem
Please make sure that you apply the suitable authentication method and the correct credential info
3. The version of Power BI Desktop
Please update the version of your Power BI Desktop to the latest one.
Download Power BI Desktop from Official Microsoft Download Center
The following link is the thread which has the similar problem as yours, hope its solution can help you solve your problem.
Solved: Unable to make the connection to Azure Synapse Ana... - Microsoft Fabric Community
Best Regards
Thank you very much for your response but everything stated has been checked and the problem has not yet been solved.