Solved: Invalid cell values

Anonymous · ‎01-07-2020

In one of my text columns, I see an error explained as: DataFormat.Error: Invalid cell value '#NAME?' In the Excel source file, I have rows which contains = before the text, which is interpreted as a formula. And it's not. Is there a way to force Power Query show what I can actually see in Excel and then drop this = sign and just keep the text. I am not entitled to change the source file. directly.

Thank you in advance.

Jimmy801 · ‎01-07-2020

Hello @Anonymous

there is no way power query gets to this data. For power BI This is simply a database. And it reads what it gets, and this in an error.
The only way you can bypass is, to open excel file, run a programm that fixes this issue create a local version and use this as your data source

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

Jimmy801 · ‎01-07-2020

Hello @Anonymous

there is no way power query gets to this data. For power BI This is simply a database. And it reads what it gets, and this in an error.
The only way you can bypass is, to open excel file, run a programm that fixes this issue create a local version and use this as your data source

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy