Forum Discussion

eolasode's avatar
eolasode
New Member
3 years ago

Unable to connect to SQL Server through Power BI Service

I want to create a Dataflow connecting to a SQL Server Database but it is not working, however if I connect to the same SQL connection in PBI Desktop, it works fine in PBI Desktop.

I have a standard Gateway installed on a VM and works just fine as well. If I publish from PBI Desktop, I have an updated data but I am unable to schedule refresh as I am unable to reaach the Data Gateway in PBI Service.

This process works fine when my SQL Connection was set to Any Any connect, but there was settings change to Private and since then PBI Service have been unable to connect to the SQL which defeats the purpose of Dataflow as well as Scheduled Refresh.

Any help will be well appreciated.

 

 Error received: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider error: 0 - The wait operation timed out.) Request ID: 2c3d3d06-a8dc-268c-7b35-538b5d1c0b69 Activity ID: 977c14bd-09c9-449b-9011-7c4d75ec7525

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    3 years ago

    Hi eolasode 

     

    Can you make sure that if you had to log into the Gateway server that you can connect to the SQL Server?

     

    If you can connect you can then use the same data source name and details when you create the data source in the Gateay connections in the Power BI Service?