OK so I started having refresh failures yesterday on my models which have been running fine for years with auto-refresh turned on. After digging around here in the forum I found there seems to be a number of users having similar issues so I thought I'd chime in and post what worked for me - thanks to all those who have taken time to post back what had worked for them because that's what helped me. Here is a cross-reference for others following in my footsteps: https://community.powerbi.com/t5/Service/error-when-processing-the-data-in-the-dataset/td-p/980971
The error I was getting (some server info masked):
| 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\":\"MySql\",\"path\":\"xyz123.ap-southeast-2.rds.amazonaws.com;admin_po\"},{\"kind\":\"MySql\",\"path\":\"xyz123.ap-southeast-2.rds.amazonaws.com;logistics\"},{\"kind\":\"SQL\",\"path\":\"xyz456.database.windows.net;xyz789\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: purchase_order_number. |
So, based on others' comments I noticed that my privacy settings in the service for my Data Source Credentials were set to None or Private. I changed them one at a time to Public and it was only after setting both sources (AWS and Azure based) to Public did the error resolve and the update works again.
