Forum Discussion
Error during proccessing data
Hi everyone.
I'm trying to refresh my data at my workspace online but apears this message:
Can anyone help me?
At the desktop i don't have any kind of error in the table or other stuff.
I verified my table FATO_DISTRATO and don't have any error at the desktop too.
{"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":"Não conseguimos converter o valor \"[Record]\" em tipo Record."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: FATO_DISTRATO.
Found the error guys!
There was an improper step in the table causing the error when I tried to do the refresh online. The same step did not cause any errors when I refreshed on the desktop.
It was a "null" filtering step. Hence the problem with null.
Thanks to everyone who responded!
5 Replies
Hi ,
So I did a translation of your error message as I am not familiar with Spanish
{"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 can't get converter or value \"[Record]\" in Record type."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{" code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: FATO_DISTRATO .
The error message seems to say - cannot convert null value to ... - at the field name [Record] of Table [FATO_DISTRATO]
Basically, you can replace null value then the issue should be fixed. Hope that suggestion helps.
The problem is: There isn't null value at this table.
Tiago_Medina , so you confirmed you removed / treated null value for that Record field? Is that field a data column or calculated column?
Confirmed. There is no errors in the table.
I can refresh normaly at the desktop. But online i can't.
Found the error guys!
There was an improper step in the table causing the error when I tried to do the refresh online. The same step did not cause any errors when I refreshed on the desktop.
It was a "null" filtering step. Hence the problem with null.
Thanks to everyone who responded!
