Error while publishing pbix. file to Power BI Service

[Analitika]

Hello,

I would like to ask how to fix error. This error happens when I am trying to to publish file. Error message below:

Failed to update data source credentials: 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: SQL Network Interfaces, error: 25 - Connection string is not valid)

[v-luwang-msft]

Hi @Analitika ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @Analitika ,

Please check if this post is helpful: SQL setup - Direct Query.

And refer:

https://stackoverflow.com/questions/12336613/sql-network-interfaces-error-25-connection-string-is-no... 

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

Best Regards

Lucien

[Analitika]

Hi.

I published .pbix file, wanted to set up schedule refresh but getting errro about database credentials, I inserted them, but after getting that message:

How to resolve this issue?

[Analitika]

Hello,

I would like to ask how to resolve this issue:

Failed to update data source credentials: 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: SQL Network Interfaces, error: 25 - Connection string is not valid)Show details

It appeared when I tried to setup schedule refresh.