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.
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.
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.