Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Error - DataFormat.Error: We couldn't convert to Number. -> happens after unpivoting

Hi,    I have similar Excel reports which I combine and load to PBI. They are formed in a way that each month's invoicing is a new column which means I have lots of columns which I would like to co...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Please check the data type of each month's invoicing column after loading data to Power BI desktop.

 

There might by some odd rows in the end of the files but these does not seem to affect the loading to PBI reporting since this only happens after unpivoting (and some filtering).

What are the odd rows? Please show us sample data. If possible, please send me your excel files so that I can test on my side.

 

Regards,

Yuliana Gu