Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.