Composite Model Incremental Refresh Error "DM_GWPipeline_Gateway_MashupDataAccessError"

Hi All,

I am getting an error and wonder if anyone else came across the same issue and managed to solve it.

Here is a snippet of the current composite model that I have.

• Data sources:
  • Excel Files hosted on OneDrive
  • API

I have disabled both the refresh and load of excel files as they are just historical data.

The Incremental refresh is configured only on the API table, which gets combined later with the historical data.

Following the upload of the pbix file to the premium capacity to refresh (so it gets partitioned), I receive the following error:

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":"The operation has timed out."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}Cluster URI:WABI-XXXXXXX-G-PRIMARY-redirect.analysis.windows.netActivity ID:XXXXXXXXXXXXXXXXXXXXXXXXXXXX

Looking at the gateway config, I can see the below missing info:

 Do I need to do more configurations?

Thanks