Problema para atualizar as Bases de Dados no Power BI

[Rafael_Avila]

Ao agendar uma atualização do Dashboard, sempre gera um erro.

Base de dados provenientes de Excel abertas no Google Drive, e publicados na web, link da url sendo usado no Power BI.

Acontece este erro: {"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":"O servidor remoto devolveu um código de estado de HTTP \"500\" ao tentar aceder a \"https://docs.google.com/spreadsheets/d/e/XXXXXXX/pubhtml"}},

{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://docs.google.com/spreadsheets/d/e/XXXXXXX/pubhtml"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"https://docs.google.com/spreadsheets/d/e/XXXXXXX/pubhtml"}}],"exceptionCulprit":1}}} Table: XXX - XXXXX

Suspeito que seja nas bases de dados, que ao alterarem e nao salvarem na mesma forma que estava quando foi linkado ao power bi isso causa um erro, mas preciso de ajuda!!

[v-jianpeng-msft]

Hi, @Rafael_Avila 

Based on the refresh error message you provided, I first noticed the following points:

1. When trying to access your Google drive files, a 500 error is returned. This is a server-side error.

2. Also, I noticed this error: DM_GWPipeline_Gateway_MashupDataAccessError. The main reason for this error is that the server returns the above 500 error when accessing your Google Drive files through the gateway.

You can troubleshoot your issue by following these steps:

1.You should make sure that you have correctly added your connection credentials in Power BI Service. If you're not sure how to add credentials, you can follow the below steps:

2. You can try restarting your server. This workaround is from the case linked below:

Solved: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community

3. Check if you have access to the files of the current semantic model. Scheduled refresh requires you to properly configure your gateway and connection credentials.

How to Get Your Question Answered Quickly

Best Regards

Jianpeng Li

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