Actualización OK en PBI Desktop - Actualización errónea en PBI Service

[leoade87]

Buenos días, hace varios días que estoy rengando con un informe.

Cuando lo trabajo y actualizo en PBI Desktop funciona sin problemas. Al publicar ese informe en la web de PBI me da el siguiente error al realizarse la actualización programada:

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":"Valor de celda '#VALUE!' no válido."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}}
URI de clúster: WABI-PAAS-1-SCUS-redirect.analysis.windows.net
Identificador de actividad: 9e89a16f-1e1e-45a3-a308-63c08f9df492
Identificador de la solicitud: 413aa74c-7cda-4402-0139-9a727dfd8f0d
Hora: 2026-03-31 12:38:07Z

Qué puede estar pasando?

PBI Desktop no me detecta errores en ninguna de las filas, tampoco me da error al actualizar desde ahí.

Hace días que no puedo solucionarlo ni encontrar donde está el error.

[v-nmadadi-msft]

Hi @leoade87 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[leoade87]

Había pensado en eso pero no es ese el problema. Si fuera así el Desktop entiendo me lo marcaría.

Ya pude solucionarlo, era un tema de credenciales en uno de los orígenes de datos.

Gracias de todos modos.

[MFelix]

Hi @leoade87 ,

Glad you were able to figure it out don't forget to accept the correct answer in order to help others even if it's yours.

[v-nmadadi-msft · Accepted solution]

Hi @leoade87 ,

Please check these troubleshooting points:

A system error occurred due to a data type mismatch. This may be caused by an issue in your Power Query (M) script within Power BI Desktop or Excel. It could also result from using an outdated version of Power BI Desktop.

Data refresh can also fail due to expired cached credentials. Clear your internet browser cache, then sign in to Power BI and go to https://app.powerbi.com?alwaysPromptForContentProviderCreds=true, which forces an update of your credentials.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[MFelix]

Hi @leoade87 ,

Believe that this is based on an Excel file correct?

this means that one of the cells you have on your data has the #Value error you need to correct that error on the excel file since on PBI desktop that error is not recognized has an error.