Forum Discussion
Problem with data type from an excel file
I have a table of data i import from excel with employee id as a column when i import the data the employee id with letters in them do not import i have tried changing the field to text and number an...
Please try with the solution provided by MattAllington. If your problem still persists, could you please provide some data in you excel table which can cause it? Based on my testing, if the column contains both number and text in the excel table, all data in this column can be imported to Power BI Desktop with data type “Any”.
Best Regards,
Herbert