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

"Datasource XXXXXX Not Found" PowerBI Refresh issues

tobiaskay — Thu, 05 Aug 2021 12:26:00 GMT

Hi community! After installation of the Release May 2021 the error for the "Datasource XXXXXX Not Found" PowerBI Refresh issues are gone for the primary node of a Scale out Deployment. But for the second member the same error exists.

The primary node in our landscape hosts the portal and the secondary node has the role "IsDataModelRefreshService".

In both config.json the new setting "Hosting-databaseValidationStatus" is available.

Does anyone have the same problems? Is there a special setting needed for the second scaleout member?

Re: "Datasource XXXXXX Not Found" PowerBI Refresh issues

Icey — Mon, 09 Aug 2021 09:02:53 GMT

Hi tobiaskay ,

Please check if adding "Hosting-databaseValidationStatus" could fix the issue:

1. Backup the config.json file (usually located in "C:\Program Files\Microsoft Power BI Report Server\PBIRS\RSHostingService\config.json") ;

2. Edit the config.json file and add this in the AS section (make sure to add the comma):

"name": "AS",

"launcher":"AnalysisServices",

"path": "ASEngine\\msmdsrv.exe",

"Config":

{

"Workspaces.path": "ASEngine\\workspaces",

"restartOnChangesTo": "Hosting-databaseValidationStatus,ASPort,Workspaces.path"

}

3. Save the config.json file and restart the Power BI Report Server service.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: "Datasource XXXXXX Not Found" PowerBI Refresh issues

tobiaskay — Mon, 09 Aug 2021 10:56:36 GMT

Hi Icey

i checked our powerbi report-servers and the parameter "Hosting-databaseValidationStatus" was already there (May 2021 Version is installed). So the error still occurs in a scale out environment.

Configuration Overview:

1st server

Portal: Yes
IsSchedulingService: No
IsDataModelRefreshService: Yes

2nd server ("Datasource not found" error occurs)

Portal: No
IsSchedulingService: Yes
IsDataModelRefreshService: Yes

Tobias

Re: "Datasource XXXXXX Not Found" PowerBI Refresh issues

Icey — Fri, 13 Aug 2021 08:40:10 GMT

Hi tobiaskay ,

I have researched a lot, but can't find anything helpful. Further research may need to check some of your configuration information. For your information security, it is suggested to create a support ticket to get further help.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: "Datasource XXXXXX Not Found" PowerBI Refresh issues

Icey — Thu, 26 Aug 2021 08:07:28 GMT

Hi tobiaskay ,

Have you created a ticket? If you got any solution, could you share it to us?

Best Regards,

Icey