Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
67 | |
64 | |
52 | |
39 | |
25 |
User | Count |
---|---|
80 | |
57 | |
45 | |
44 | |
35 |