Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Tiago_Medina
New Member

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.

1 ACCEPTED SOLUTION
Tiago_Medina
New Member

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!

View solution in original post

5 REPLIES 5
Tiago_Medina
New Member

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!

Tiago_Medina
New Member

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.

Tiago_Medina_0-1683812196962.png

 



rdnguyen
Helper V
Helper V

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors