network issue while connecting SQL server using data flows

[Anonymous]

As part of  Data Pull in Power BI, we have created Dataflows in Power BI service but unable to fetch data in Power BI Desktop.

We tried with Dataflows and Power BI Dataflows Legacy options but still the issue persists. Network issues while establishing connection to SQL Server.

Please help and suggest.

[v-veshwara-msft]

Hi @Anonymous ,

Just checking in again as we haven’t heard back from you. If the provided response addressed your issue, kindly mark the helpful reply as the Accepted Solution to assist others with similar queries.

If your issue is still unresolved or you need further help, feel free to reach out.
Thank you.

[v-veshwara-msft]

Hi @Anonymous ,
We wanted to check in again regarding your issue and if its been resolved. If the provided response was helpful, please consider marking it as Accepted solution to help others with similar queries. If not, please reach out for further assistance.
Thank you.

[v-veshwara-msft]

Hi @Anonymous ,
Just following up on your issue to check if its resolved. Are the troubleshooting steps provided by @suparnababu8 helpful?. If yes, please consider marking it as Accepted solution to help others facing similar issue. If you are still experiencing issues, please reach out.
Thnaks @suparnababu8 for your suggestions.

Thank you.

[suparnababu8 · Accepted solution]

Hello @Anonymous 

• Make sure that the login information and connection settings in the dataflow are correct. Sometimes, connection problems happen because the details are wrong or missing
• Make sure you have installed and properly set up an on-premises data gateway. It's essential for connecting to an on-premises data source.

Please go through below accepeted solutions. It might helps you to solve your issue.

Solved: Cannot connect to SQL Server in Dataflow - Microsoft Fabric Community

Solved: PBI Desktop - Unable to connect to Dataflow Gen2, ... - Microsoft Fabric Community

Troubleshooting dataflow issues - connection to the data source - Power Query | Microsoft Learn

Thanks!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!