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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MikeO
Helper I
Helper I

"OLE DB or ODBC error: [dataformat.error] invalid cell value '#NAME?'

I have connected to a single table in excel and whenever I try to close and save the query editor, I get the above message.  In reviewing the table in query editor I see the bottom row is all errors; however, when I try to delete the bottom row the entire table goes away and the same error message appears in the query editor.

 

Any suggestions on how to correct this would be appreciated.

1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

My suggestion would be to correct the error where it originates: in Excel.

Specializing in Power Query Formula Language (M)

View solution in original post

5 REPLIES 5
djankuna
Frequent Visitor

Hi! 

Same issue from our side. I am trying to refresh Power BI (updated excel sheet uploaded), it says:

OLE DB or ODBC error: [DataFormat.Error] Invalid cell value '#NAME?'...

 

But I cannot track this mistake in my excel sheet, nor check this in Power BI query edditor (because the excel is not uploading/refreshing - old format data is 'standing'). 

 

any suggestions here? 

Facing same issues here.  It happens when i try to expand the table after merge query. Everything works well before that.. even after an append query.

Tried replacing error with values and removing empty rows etc but does not solve the issue.

 

Appreciate any guidance to troubleshoot the issue and hopefully fixing it at power query

In addition to Marcel's comment, have you tried removing errors as a step in your query editor flow?  If that doesn't work, you can try filtering, and lastly add a new column that checks if the value is error return null otherwise return the original value.  Then use that column (and remove/filter the blank row if needed).

MarcelBeug
Community Champion
Community Champion

My suggestion would be to correct the error where it originates: in Excel.

Specializing in Power Query Formula Language (M)

really not useful. I design the report and 10 other ppl edit the excel files that I only had read access to. There must be a way to resolve this in power bi

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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