Data Format Error

[csteves]

When refreshing a query I am receiving an error message saying "Cannot convert to number". However, the column should be a text. Any reason this would be happening? Am I able to change this column to text in the Query editor? 

[v-caliao-msft]

@csteves,

You said that this error occur on refresh time, so data was loaded success at first time, right? Then this issue could be caused by that you changed one of the columns' data type. You can change the this column to text in the Query editor. Please refer to the screenshot below.

Regards,

Charlie Liao