Error during refresh

[HMack]

Hello.  I have built a report of which pages for every month of the year.  This for maintenance monthly downtime and kpi data.  I'm pulling data from an excel spreadsheet.  Every moring, i check downtime logs and add the info to the excel sheet if there has been downtime, and then refresh pbi and the data loads.  There has been a few times where i could go a week or so with no downtime on a fresh month, and then when i do get some, I get errors when refreshing.  Usually, i delete the query, reload it and its fine for the rest of the month.  This time, I double clicked on the error and its says 'DataFormat.Error:  We couldn't convert to Number.  I'm not sure why because it shouldnt be a number, only text.  When i create the queries, i always use transform data and make sure those column are converted to text.  When i get the errors, i right clicked on the column, go to change type, and text was already highlighted.  Does anyone have insight on this?  My security will not allow me to upload and screen shots

[Anonymous]

Hi @HMack ,

Agree with @dharmendars007 .

In summary, there are two solutions:
1. Replace the error values.
2. For error fields, modify them to the correct data type, such as text type here. And make sure that the steps that have been applied are coherent.

Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.

If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.

There're also some similar post for your reference:

Solved: DataFormat.Error: We couldn't convert to Number - ... - Microsoft Fabric Community

Solved: DataFormat.Error: We couldn't convert to Number - ... - Microsoft Fabric Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dharmendars007]

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

LinkedIN 

[HMack]

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