Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
BigKev
Helper III
Helper III

Query Errors when Refresh Data

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

Capture.PNG

3 REPLIES 3
v-xicai
Community Support
Community Support

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.

Chnage Type.png

 

 

 

 

 

 

 

 

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

 

 

 

amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.