Error while refreshing dataset from Power BI service - Appended dataset

[ramyjelda]

I can't manually or use schedule refresh to refresh my report that is combined by two appended databases fetched from OData from the same service and log in credintials (CommCare) This is the error I receive: 

Data source error: Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: MC HH registration.
Cluster URI: WABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 86b9dc49-18c7-4ee7-9fbf-508202ce2475
Request ID: 69aa1e7c-cbd5-4aa2-bd6c-27ceb536e294
Time: 2021-09-06 06:26:16Z

Does anyone know how to fix this?

[v-yingjl]

Hi @ramyjelda ,

It caused by data source settings. The error can happen if the Data Source credential Privacy Settings don’t match in the desktop app and the Dataset settings on the Service.

Please try to change the all privacy level for all data source to the same level to check it again.

Refer this community blog: Refresh Failure in Power BI Service with Error “Information Is Needed in Order to Combine Data”  

Best Regards,
Community Support Team _ Yingjie Li

[ramyjelda]

Thank you! That's right.  Ichanged the privacy and it worked (Y)