Forum Discussion

talk114's avatar
talk114
New Member
2 years ago
Solved

Report Server Error no credentials when refresh

Hi everyone,
I am using Power BI Report May 2024 version, I was set to schedule auto refresh via the import method, but sometimes I have an error: No credentials were found for the data source.
I tested on SQL Server and Oracle, but maybe this error:
ErrorCode":-1056505856,"Message":"COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.","CallStack":null},{"ErrorCode":-1055129594,"Message":"The current operation was cancelled because another operation in the transaction failed.","CallStack":null

 

Data source,it's  seem okay. I am sometimes refresh okay.

 

I hope someone can save my life, Thank you so much!
Best regards,
talk114, loveu
no credentials
powerbi
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, talk114 

    You can refer to the following case, where you encountered the same problem and other community members used the solution to solve the current problem:

    Solved: Fix for "Datasource XXXXXX Not Found" PowerBI Refr... - Microsoft Fabric Community

    Here's how my config.json file is configured, and you can try updating it.

    I was able to refresh the report in SQL Server database import mode smoothly in Report Server:

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, talk114 

    You can refer to the following case, where you encountered the same problem and other community members used the solution to solve the current problem:

    Solved: Fix for "Datasource XXXXXX Not Found" PowerBI Refr... - Microsoft Fabric Community

    Here's how my config.json file is configured, and you can try updating it.

    I was able to refresh the report in SQL Server database import mode smoothly in Report Server:

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • aduguid's avatar
    aduguid
    Memorable Member
    2 years ago

    This happens to me when I switch between test and production database connections. I have to update the credentials each time.