Our gateway is up to date (we just updated a few days ago) and I have been having this issue since the March gateway update. Random reports will frequently get this refresh error during it's scheduled refresh in Power BI service. This error is not consistent. For example, a 9:00am refresh completed without issue and then an 11:00am refresh failed with this 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":"<ccon>An error happened while reading data from the provider: 'Access to the path 'C:\\Windows\\ServiceProfiles\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Cache\\Uzd@iy7VOEcSTQNocKkMETMMCDlJeLNn+iocalJLh2WI=\\Cache.Key' is denied.'</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon>rjc-sql3;BI_ReferenceTables</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Safety Data.
I have tried researching this error and have gotten nowhere. Does anyone know why this is happening/how to fix it?
Thank you!
v-xiaoyan-msft
on:
ERROR CONNEC|T |TO SEMANTIC MODEL
Hi @mmerchak ,
We would like to know more details about this issue，if you downgrade gateway version to older than Feb 2024. Currently supported monthly updates to the on-premises data gateways | Microsoft Learn
Will this problem persist?
Best regards.
Community Support Team_Caitlyn