cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeO Regular Visitor
Regular Visitor

"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

Accepted Solutions
MarcelBeug Super Contributor
Super Contributor

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

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

3 REPLIES 3
MarcelBeug Super Contributor
Super Contributor

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

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

Microsoft dkay84_PowerBI
Microsoft

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

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).

ivanac01 Visitor
Visitor

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

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors