topic Re: Report Server Error no credentials when refresh in Report Server

Report Server Error no credentials when refresh

talk114 — Thu, 18 Jul 2024 10:45:08 GMT

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

Re: Report Server Error no credentials when refresh

aduguid — Fri, 19 Jul 2024 13:49:46 GMT

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

Re: Report Server Error no credentials when refresh

Anonymous — Mon, 22 Jul 2024 06:27:29 GMT

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.