Query editor error

[Anonymous]

Upon trying to refresh my report  (not importing anything, just refreshing), I am getting this error.    The field it is referencing..."Line" is actually a text value...even though it is a "numeric value"  1,2,3, etc.   But they are not fields I would be summing up, so they should be text values I think.   

I have all of the instances of this field set as text.    So not sure how to fix this error.   

[amitchandak]

@Anonymous , Look at the column, there should be a column with an error.

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

[edhans · Accepted solution]

Your RMA value is coming from your Program Codes table, and the error is there. You have a Change Type step that is converting RMA to numeric, but there is text. Go there and fix it by clicking on the Changed Type step, find the RMA field and change it to Text, and then tell it to Replace when it asks, as opposed to adding a new step.

[dax]

Hi @Anonymous , 

I am not sure which part cause this problem, if possible, could you please inform me more detailed information (such as yor sample data and M code, you could use virtual data instead of real data)? Then I will try to test this in my environment.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.