cancel
Showing results for 
Search instead for 
Did you mean: 

Refresh error: Underlying error messageInformation is needed in order to combine data

Why do I keep getting this error on refresh in Power Bi Service? The issue does not occur when I refresh in Power BI Desktop. I am merging two queries into a new query which then I load and use in the report. See error below and kindly advise:

Something went wrong
Unable to connect to the data source undefined.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code: -2147467259 Table: CLTSPreTriggerSurveyView.
Underlying error message: Information is needed in order to combine data
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"Web","path":"https://www.commcarehq.org/a/mawa-wash/data/export/custom/dailysaved/download/417b5cadb186746914a3adbe8bf7f2b7/"},{"kind":"Web","path":"https://www.commcarehq.org/a/mawa-wash/data/export/custom/dailysaved/download/5301b91fe095515d681cd145a4c7694f/"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacySetting
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 3ebbbced-48a9-4837-b9f8-79a8a7d0f53e
Request ID: 9412cd8d-606d-f623-9968-80360c77d254
Time: 2019-04-15 19:58:41Z
Status: Needs Info
Comments
Community Support Team

Hi @chaiwa ,

 

What types of data source were loaded into desktop? If removing the merged step, does error persist when refreshing in service?

 

Since there existing two kinds of data source in a single dataset, did you add both of them into data gateway?

 

Besides, please update data gateway to the latest one and set Privacy Level to Organizational for a test. 

 

Best regards,

Yuiana Gu

Community Support Team
Status changed to: Needs Info