Forum Discussion
Solved
Problem with data type from an excel file
Hello, I have a simple excel file with a single table that I'm trying to implement to my report. My problem is that one of the colums has number data that power bi recognises as dates. The colum...
Look at my response here...
http://community.powerbi.com/t5/Desktop/Sort-a-columns-by-the-rows/m-p/29830#U29830
Basically don't load the Excel data immediately - hit EDIT first - then in the Query Editor change the Data Type to decimal
then go ahead and load to the Data Model
let me know if this works.