Forum Discussion
Error during refresh
Hello HMack ,
There are few things you can check to resolve the issue you are encountering in regards to Data type.
1. Use Error handling formula to get rid of the error you are getting
if Text.From([YourColumn]) = null then "ErrorValue" else [YourColumn]
2. To ensure consistency, explicitly set the column like -> Right-click on the column header ->Select Change Type -> Text.
3. Open the source Excel file, select the problematic column, and ensure there are no stray spaces, special characters, or cells formatted as numbers
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Thanks dharmendars007 for the response. I tried error formula and it works for anything outputing "null", but mine is outputing Error on all text. My numbers are outputing correctly. The other two solutions i had already done. I'll just have to delete the query and load it again. Thanks again..
