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.
Hi Sbegnaud,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
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.
