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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors