Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm new to Power Query and I'm having issues loading the data. Some of the values contain alphabets and/or characters that are giving me errors and are not being loaded properly. How can I load the entire dataset that includes non-numeric values that is causing the error?
Solved! Go to Solution.
You need to make sure the coloumns you have defined in your set is aligned with the values that could be present in that coloumn. In this case it seems like you are getting non-numeric values in a coloumn defined as numeric. You can either 1) change the coloumn type to text, or 2) replace errors in the coloumn with null.
You need to make sure the coloumns you have defined in your set is aligned with the values that could be present in that coloumn. In this case it seems like you are getting non-numeric values in a coloumn defined as numeric. You can either 1) change the coloumn type to text, or 2) replace errors in the coloumn with null.