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,
So I'm importing in a school data sheet into Power BI from excel. My student id is a 14 digit number (i.e 12500300981613) and a unique id.
When I import it into Power BI, it automatically transfers into 12500300981000. In the Query Editor it is:
1.25003E+13 |
I've tried all ways to make sure the number stays the same...This is happening only one file...the rest are ok.
Any help would be appreciated. Thanks.
Solved! Go to Solution.
Hi,
So that seems to work, but it is a saved as a number on ther other tables, so the join is not working.
Would I have to change all of them to text to make it work? Or is there a work around...
Thanks.
If it is saved as number on other tables, you can duplicate the column and set that duplicated column to text. It is like 2 same columns but 2 different data types.
Thank you, that seemed to work.
Kind Regards.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |