There was an error when processing the data in the dataset.

Hello,

maybe someone here can help me out....

I have an report published in Power BI service with a scheduled refresh a couple of times during the week. It used to refresh just fine but up until three weeks ago, an error occured while refreshing the data. I have no clue what causes this problem.

Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"ACMBISQL1;BIDataAccess\"},{\"kind\":\"SQL\",\"path\":\"enmsql07;SPAD\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: EMEA_Shipped_Units_History.

When I do a manual refresh via the gateway, same issue. When I download the data, do a refreh in Power BI Desktop and publish the dataset, no issues.

I don't know in which direction to look to solve this problem. Can someone help me out?

Thanks in advance.

Regards.