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 All,
I have received a query error message when loading my data. Upon checking, I found that there is one column that PBI try to convert to Number although I have set the data type to string.
Anyone know why?
Cheers,
Kev
Hi @BigKev ,
You may enter into Query Editor, select on your issue query, delete the step named "Changed Type" behind of step "Source" , or change the data type of issue column to Text.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks V-xicai
It works.
Fore some reason, that column data type is still on 'Int64.Type', although I have set to 'text' using the UI.
After I changed manually the data type in the script editor, and reload the data, It works!
Cheeers,
Kecv
@BigKev , there some problems to convert number it main contains N/A, null, # etc.
Please change the data type to text and check. Later clean the data and change it back to number
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |