Query Errors when Refresh Data

[BigKev]

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

[v-xicai]

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.

[BigKev]

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

[amitchandak]

@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