Report Server Error no credentials when refresh

[talk114]

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

[v-jianpeng-msft · Accepted solution]

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]

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