Forum Discussion
Error trying to retrieve table from a dataflow Gen2
Hi everyone!
It’s definitely a firewall configuration issue on my company’s network. For your information, it works perfectly from home.
PBI Desktop directly queries the SQLAnalytics endpoint (Azure SQL Server TDS endpoint), by default through port 1433. Our corporate network policies block this traffic. Therefore, we need to consider a workaround if we want to roll out Fabric to other users, as the same applies to SQL connections to both Fabric Warehouse and Lakehouse.
We found this documentation here => https://learn.microsoft.com/en-us/fabric/database/sql/connect
Regards,
XCT
XCT ,
Thank you for reaching out to the Microsoft Fabric community forum.
Shahid12523 , MohamedFowzan1 Thank you both for your prompt responses.
XCT In addition to the inputs shared by Shahid12523 and MohamedFowzan1 , I’ve also added the previously resolved threads here. They may help you better understand the issue and work toward a resolution.
Solved: Power bi connect to dataflow gen2 - Microsoft Fabric Community
Solved: PBI Desktop - Unable to connect to Dataflow Gen2, ... - Microsoft Fabric Community
Solved: Power bi connect to dataflow gen2 - Microsoft Fabric Community
We appreciate your engagement and thank you for being an active part of the community.
Best regards,
Lakshmi.