Forum Discussion
Solved
Help Please - Data Import Transformation
Hello - I'm trying to educate myself to switch from Excel to PowerBI for data analysis, so learning as I go along.... I'm trying to import data from an excel spreadsheet - one of the columns has ...
Thank you both - I removed teh transform step and now have the data I need. On to the next steps...
Grant
Please add ' at the beginning of your data like '2.7.8 and format it as text. In Power BI, when you import from excel go to transform data.
Click on Navigation and change the data type to Text
Delete any other change types which converts your column into date.
Close and Apply and it will stay as required.