Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have an excel file which I use as data source in PowerBI. When I examine it n Excel I see the following:
9896700000111100432411004310 |
9896700000111100432411004311 |
9896700000111100432411004312 |
9896700000111100432411004313 |
When I import this in PowerBi, I shows up as:
9896700000111100432411004310 |
9896700000111100432411004310 |
9896700000111100432411004310 |
9896700000111100432411004310 |
All data is at all times fomated as TEXT. I do not want to use these as numbers. Why is PowerBi rounding this down? And how can I fix this?
Hi
It seems when imported, the data duplicated and changed to text type automatically, right?
Though I can't reproduce your problem, could you share me an excel file or a pbix file including some data as shown?
Best Regards
Maggie
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |