Problem with automatic updates

[Vinzitc]

Good afternoon.

I'd like to share an issue I'm having when I want to set up automatic updates so that someone can help me fix it.

I have a Power BI file powered by several sources: 

Some of them are web-based.

Others through google sheets.

To try to set up automatic updates, what I did was publish the PBI, then I went to "My workspace" and once here, I clicked on the "schedule update" option in the semantic model.

I created a data gateway and made the connection to the cloud (for the google sheets files)

Subsequently, I edited the credentials of the data source and activated and scheduled the updates.

After doing all these steps, it doesn't work and gives the following error:

Error del origen de datos: {"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":"Se ha agotado el tiempo de espera para que se cargue la página web."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://xxxxxxxxxx"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: NIQUEL_Update_GS.
URI de clúster: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Identificador de actividad: fd814782-ba6e-4685-be91-606d58238ab9
Identificador de la solicitud: 65f7a302-1959-41f7-832e-6c6ff0e15c2c

Thanks for your help

[Anonymous]

Hi @Vinzitc ,

It seems that the problem is DM_GWPipeline_Gateway_MashupDataAccessError.  This error is often associated with connectivity or configuration issues related to the data gateway or the data source itself.

Firstly you need to ensure that the on-premises data gateway is properly configured and is running the latest version. You can read this document: On-premises data gateway sizing - Power BI | Microsoft Learn

Check on the Data Source Credentials is necessary: Data refresh in Power BI - Power BI | Microsoft Learn

Finally you can try increasing the timeout settings for the specific data source connection within the Power BI service or the gateway configuration.

Best Regards

Yilong Zhou

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