Dataset Data Source Credentials Error - Azure SQL Database

Question

Hello,&nbsp;I am unable to refresh, or schedule a refresh, for my dataset published to my Power BI workspace.&nbsp; My data source is Azure SQL Database, so I don't believe I need a Gateway setup.&nbsp; The gateway connection section also says I don't need a gateway because all of the data is in the cloud.&nbsp;Processing errorMicrosoft 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 - An attempt was made to access a socket in a way forbidden by its access permissions.)&nbsp;I can refresh the data set in Power BI desktop with the same credentials, so I know it is not an error in the credentials.&nbsp;I greatly apprecaite in help!

v-janeyg-msft · Accepted Answer

Hi,&nbsp;JCarr1321&nbsp;&nbsp;According to your description, I think maybe something wrong in the sql server,like TCP/IP ,firewall.You can follow Troubleshoot connecting to the SQL Server Database Engine&nbsp; to check the problem, and here are some similar solved cases.Solved: Can't connect to SQL Server named instance - Microsoft Power BI CommunitySolved: Data Gateway error - Microsoft Power BI CommunitySolved: Issue trying to connect a data source to gateway t... - Microsoft Power BI CommunityIf it doesn’t solve your problem, please feel free to ask me.&nbsp;Best RegardsJaney Guo&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Dataset Data Source Credentials Error - Azure SQL Database

1 Reply

Related content

Service principal for dataset datasource credential

Destruction of credentials

Database connectivity.

Data Source Credentials

Invalid credentials Snowflake