Using both PBI desctop and web versions. That issue didn't happen before. Here is the full text of the error:
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)
Hide details
| Activity ID: | 85f18e28-a110-4ece-962f-76facf84b674 |
| Request ID: | e79b89b2-f6c2-2959-17e3-f532a3095ed9 |
| Status code: | 400 |
| Time: | Fri Apr 01 2022 16:24:33 GMT+0300 (GMT+03:00) |
| Service version: | 13.0.17952.44 |
| Client version: | 2203.3.10669-train |
| Cluster URI: | can't post with this url |
Thing is: the credentials are the same as the ones used to connect to server on the downloaded report. They work in the downloaded version but don't work in the web. We didn't apply any IP restrictions to credentials yet, so that couldn't be the issue.
v-tianyich-msft
on:
How can i use a measure as a slicer?
Hi @Sviatoslav ,
In addition to make sure the correctness of the service name and credential, please make sure your SQL Server database and the machine that installed the database is running properly including its startup status and the port needed. Also, please check the status of your on-premises data gateway and make sure it can connect the data source smoothly. If needed, upgrade it to the latest version.
Here is an official document related to connect to SQL Server that might help you as well.
Manage your data source - SQL - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Caiyun