Getting DataFormat.Error: We couldn't convert to Number

[Anonymous]

I keep getting the error DataFormat.Error: We couldn't convert to Number. Details: UNK. The columns that I am getting these errors are set as text already. See below.

Thanks in advance!

[Anonymous]

It worked!

Thanks!

[Abduvali]

Great stuff mate, glad it helped 👍

Regards
Abduvali

[Greg_Deckler]

Can you post your M code? View | Advanced Editor or perhaps a screen shot of your steps?

[Anonymous]

Is this what you need?

[Greg_Deckler]

So is 2016 a reference to another query?

[Anonymous]

No that is the name of my query

[Greg_Deckler]

So where are the columns coming from? Confused. Usually the source line actually references a source. Are you in the Query Errors when doing the View | Advanced Editor? You want to be on the original query when you do that.

[Anonymous]

A table in an excel worksheet named 2016.

[Abduvali]

@Anonymous ,

Go to Edit Queries and select your table with errors and on right side click on Navigation:

And see if data is displayed as expected delete all steps below Navigation.

Regards

Abduvali

[Anonymous]

That seems to correct the errors. But when I unpivot my sales columns the errors return.

[Abduvali · Accepted solution]

Just delete step called Changed Type, I assume its there before you unpivot your columns.

[Abduvali]

Hi @Anonymous,

Just check your previous steps on the right side in Edit Query mode.

By default when data as loaded, power bi changes data types automatically so if you delete that step it might solve the problem. Alternatively click SOURCE on the right side and see if errors remains at loading stage or not. If yes then check the "#2016" table that you are referencing.

Regards

Abduvali