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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!