Sviatoslav's avatar
Sviatoslav
Regular Visitor
4 years ago
Status:
Investigating

Failed to update data source credentials

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.

Reports

3 Comments

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago
    Status changed:
    New
    to
    Investigating

    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

  • Sviatoslav's avatar
    Sviatoslav
    Regular Visitor
    4 years ago

    Please note, that the exact same credentials and server are being used on my desctop PBI app and there are no issues there.

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Sviatoslav ,

     

    Thanks for your reply! I understand. If so, please consider creating a support ticket in Power BI Support. Then, there will be a support engineer to help you troubleshoot on this issue.

     

    The link of Power BI Support: Support | Microsoft Power BI

    For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

     

     

    Best Regards,

    Community Support Team _ Caiyun

Completed Ideas