Issues refreshing my report with standard gateway DM_GWPipeline_Gateway_MashupDataAccessEr

[hish]

Hello everyone, I have issues refreshing my report on app.powerbi.com. On the Desktop version I never faced any diifculties in refreshing my report. I did some research and think that it has something to do with my privacy setting. I am new to Power BI. I get this error message (see below), eventhough all privcay settings are on organisation. Does anyone know how to fix this?

My report is connected with correct gateway and the gateway is active

The data privacy of my gateway is set on organisational

The data privacy setting of my report is also set on organisation

When I want to refresh my report on power bi service, I am getting this error message:

Fehler bei der Datenquelle:	{"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":"Unspecified error"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"edgemaking_state.accdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: states_eqs.
Cluster-URI:	WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Aktivitäts-ID:	e8fd43af-1f84-43f8-913e-808e4b94cef3
Anforderungs-ID:	7ab2f37e-8b04-7209-5b00-d73c7d88bba5
Zeit:	2025-06-26 12:31:36Z

[lbendlin]

You are using an Access database as a data source. Highly not recommended.  You need to install extra 32 bit drivers on the gateway VMs.

[wardy912]

Hi @hish 

 I've encountered this error when trying to use on prem and cloud sources over the on prem gateway.

If there are any cloud tables (sharepoint, fabric lakehouse etc) remove them from the on prem gateway and use cloud connections.