•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power query where is my error
Our take
It sounds like you're facing a frustrating challenge with Power Query, specifically a “dataformat.error cannot convert to number” message when trying to open your query in Excel. You've already taken important steps by isolating the raw data, which loads correctly, and identifying a potential error line with the term "TFR." However, since it doesn’t appear in your data, pinpointing the source of the issue can be tricky. Let’s explore strategies to troubleshoot and resolve these specific errors effectively.
Hi all I’m struggling with an error, I keep getting a “dataformat.error cannot convert to number” when I have run my query and try to open in excel. In the editor I am not finding anything.
I did some digging and separated the raw data from all subsequent queries and the raw data loads correctly.
I have managed to find an error line and it says “ dataformat.error Details TFR” however in my data there is nothing called TFR
Any ideas on how I can find the specific errors?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience