cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gsprague
Microsoft
Microsoft

Fix for "Datasource XXXXXX Not Found" PowerBI Refresh issues

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"
    }
}

1 ACCEPTED SOLUTION
hbao4
Frequent Visitor

Thanks! Finally found the root cause.....

View solution in original post

3 REPLIES 3
a4peterson
Frequent Visitor

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.

kevinrw
New Member

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

hbao4
Frequent Visitor

Thanks! Finally found the root cause.....

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps