This morning our datasets failed to refresh, all with this type of error below. We have done/checked the following:
- Verified the gateway data sources privacy is all set to Organizational and they were.
- Updated the gateway software to version December 2022 update (3000.154.3)
- Modified the PBIX to remove a datasource through the gateway and it solved the problem. But this work-around is not possible for other dashboards.
We are requesting help to identify the root cause of this issue and how to fix it or at least to work around it until a proper solution is in place. We have highly visible and sensitive reports viewed on a daily basis. Thank you.
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\":\"REDACTED;REDACTED\"},{\"kind\":\"SQL\",\"path\":\"REDACTED.database.windows.net;REDACTED\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Person Involvements.
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: 822d2f42-e9e6-4a6e-917e-ceebfab74e67
Request ID: abe117e8-c40a-7b89-94e9-03f35781ac44
Time: 2023-03-08 19:21:15Z
