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

[v-ssriganesh]

Hello @hish,

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[v-ssriganesh]

Hello @hish,

Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.
Please don’t forget to “Accept as Solution” and Give “Kudos” if the response was helpful.
Thank you.
 

[v-ssriganesh · Accepted solution]

Hello @hish,
Thank you for reaching out to the Microsoft fabric community forum.

Since your report refreshes successfully in Power BI Desktop but fails in the service despite correct gateway and privacy settings, it’s likely related to data source compatibility or configuration.

I’ve investigated similar cases and found some relevant discussions in the Microsoft Fabric Community that might help:

• Thread 1 suggests rebooting the server hosting the data source or gateway, which could resolve connectivity issues.
• Thread 2 points to checking for data model or schema inconsistencies, especially with the edgemaking_state.accdb file.
• Thread 3 recommends verifying gateway settings and driver compatibility, which might apply if there’s a format mismatch.

I suggest you review these solved threads and try the following:

• Ensure the edgemaking_state.accdb file is accessible and not corrupted.
• Check the gateway logs and consider a reboot if needed.
• Verify the database schema and privacy settings in Power Query Editor.
• Confirm the gateway configuration matches the data source requirements.

Thank you, @lbendlin & @wardy912 for sharing valuable insights.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-ssriganesh]

Hello @hish,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.
Thank you.

[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.