Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I keep receiving an error when I import my excel file into PowerBI Desktop. I think what is happening is that in some of the fields, there is a comma.
For example, I have a column titled Procedure Code and typically Procedure codes are just all numbers like 99213 but there are occassions when a Procedure Code will contain a modifier and that modifier is identified after theProcedure Code and is separated with a comma: 99213,PRO or 99213,52,AS. How can I get PowerBI Desktop to reverse the error and just import the data like it is in the excel file?
Thanks,
Kim
Solved! Go to Solution.
Thanks that worked for me. In advanded editor when selecting Changed Type and finding the field NAMEID it showed
... {"NAMEID", Int64.Type}, ....
Then I just changed it to
... {"NAMEID", type text}, ....
and it worked
This works for me too!
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |