Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
First time poster - I'm working with importing several Excel files into Power BI. Each of them contains a CUSTOMER ID column. Within Excel, the column is formatted as TEXT. Within the column, there are customer IDs that are all-numbers (example: 123456) & also IDs that contain letters & numbers (example: WB123456). After the importing & transforming the data, I'm seeing that only the all-numbers IDs were imported.
As part of the intial transform, Power BI tried to default format this column as whole-number, but I have changed it to text. Still though, I'm not seeing that my letters & numbers IDs (example: WB123456) were imported.
How can I make sure these IDs get imported? Is there a transform step that I'm missing?
Thanks for any insights that can be provided
Hi,
Remove the "Changed Type" step in the Applied steps pane of the Query Editor.
Welcome to the forum.
Can you post a picture of the power query screen please OR the actual code from the Advanced Editor in Power Query?
Also, do you see errors for the fields that are letters and numbers?
Hi there, I've posted a few screenshots, ranging from a sample of the original Excel file, to Power Query Editor & Advanced Editor. What I'm seeing is that the IDs that are letters+numbers aren't making it into Power BI at all. I'm wondering if the issue has to do with the way the 2 different ID types are formatted in Excel, but I haven't found a way around it yet. Thanks for any insights you or anyone else can provide
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |