Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
madashelliam
Regular Visitor

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 and re-importing but doesnt seem to make any difference.

 

any suggestions on where im going wrong?

2 REPLIES 2
v-haibl-msft
Microsoft Employee
Microsoft Employee

@madashelliam

 

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

MattAllington
Community Champion
Community Champion

Almost certainly your query step has automatically set an integer number format early in the query.  If you then switch it back to string later in the query - it is too late - the damage is done.  Find the step "Changed data type" that turned it into Integer and delete that step.  That should fix it.



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.