topic Re: Fix for "Datasource XXXXXX Not Found" PowerBI Refresh issues in Report Server

Fix for "Datasource XXXXXX Not Found" PowerBI Refresh issues

gsprague — Fri, 23 Apr 2021 19:25:25 GMT

Hi community. There are a class of Refresh errors for PowerBI reports where the message in the logs shows 'Datasource xxxxx is not found'. There is a fix in the upcoming May release that should help a large number of customers hitting this error.

In the mean time, this can be fixed by editing the RSHostingService config to add Hosting-databaseValidationStatus to the AS configuration.

Steps:

1. Open RSHostingService config.json file. for example: "C:\Program Files\Microsoft Power BI Report Server\PBIRS\RSHostingService\config.json"

2. Find the section with name = "AS".
3. Under "restartOnChangesTo" key, add "Hosting-databaseValidationStatus" to the entries

For example-

before:

{
"name": "AS",
"launcher":"AnalysisServices",
"path": "ASEngine\\msmdsrv.exe",
"Config":
{
"Workspaces.path": "ASEngine\\workspaces",
"restartOnChangesTo": "ASPort,Workspaces.path"
}
}

after:

{
"name": "AS",
"launcher":"AnalysisServices",
"path": "ASEngine\\msmdsrv.exe",
"Config":
{
"Workspaces.path": "ASEngine\\workspaces",
"restartOnChangesTo": "Hosting-databaseValidationStatus,ASPort,Workspaces.path"
}
}

Re: Fix for "Datasource XXXXXX Not Found" PowerBI Refresh issues

hbao4 — Sun, 25 Apr 2021 02:58:35 GMT

Thanks！ Finally found the root cause.....

Re: Fix for "Datasource XXXXXX Not Found" PowerBI Refresh issues

kevinrw — Wed, 12 May 2021 16:40:32 GMT

Finally a solution that works!!! This issue has caused me so much pain.

Re: Fix for "Datasource XXXXXX Not Found" PowerBI Refresh issues

a4peterson — Thu, 10 Jun 2021 13:41:13 GMT

This worked for us, and one of our error messages was: "Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource."

And, we did not have to restart the report server service.