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.....

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

Power BI Dev Camp Session 25 with aka link 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, August 25 at 11a PDT for a great session with Ted Pattison!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.