Forum Discussion
Power Query Deletes Customers With Letters
Hi Sbegnaud,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps to Keep Customer Numbers with Letters in Power BI;
1.In Power Query Editor, select the customer number column and change its data type to Text.
2.Remove any hidden spaces or special characters by trimming or replacing them (e.g., use Text.Trim).
3.Ensure the customer number column in your source system (Excel, database, etc.) is formatted as text, not numeric.
4.After applying these changes, refresh your Power BI data load.
Please continue using Microsoft Community Forum.
If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.
I ended up grouping them together before I brought into Power BI.
Hi Sbegnaud,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps to Keep Customer Numbers with Letters in Power BI;
1.In Power Query Editor, select the customer number column and change its data type to Text.
2.Remove any hidden spaces or special characters by trimming or replacing them (e.g., use Text.Trim).
3.Ensure the customer number column in your source system (Excel, database, etc.) is formatted as text, not numeric.
4.After applying these changes, refresh your Power BI data load.
Please continue using Microsoft Community Forum.
If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.