Refreshes Failing with following error

[ryanmason82]

Getting the following error on refresh that is set up but not sure where to start in terms of resolving? this is causing issues across many of our reports because the data isnt refreshing.

{"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":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: Date Difference.Cluster URI:WABI-EUROPE-NORTH-B-redirect.analysis.windows.netActivity ID:f4f891d4-17d6-4973-b851-07d2dbe8de35Request ID:4c74077e-fa1c-4cf7-aed2-68943e639544Time:2023-11-14 10:11:57ZDetails

[Anonymous]

Hi  @ryanmason82 ,

You can also try to check the following:

1. Can you successfully refresh it on Power BI Desktop? Please check the credentials in Power BI Service and Power BI Desktop. If the credentials are completely different, an error may occur, check in gateway to see if the connection to this data source credentials are expired.
2. Check if the gateway is up to date, if not, check the link below to update to the latest version, and keep only one type of gateway running on a machine (either an enterprise gateway or a personal gateway). Do not run both type of gateways at the same time. Install an on-premises data gateway | Microsoft Learn
3. Restart the gateway server: Restart an on-premises data gateway | Microsoft Learn
4. Find more detailed information about the error by reading the gateway log: Troubleshoot gateways - Power BI | Microsoft Learn

This is the related document, you can view this content:

Error while refreshing in power bi service - Microsoft Fabric Community

Error while refreshing in power bi service - Microsoft Fabric Community

Solved: Gateway Mashup Data Access Error - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @ryanmason82 

Problem is in this Table: Date Difference. You need to go back to Power Query and check it out for mistakes.