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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Frequent Visitor

Unexpected behaviour in Power Query



I have a Power BI report that connects to variouys data sources (files, API)  and brings them together. I made some changes yesterday, And I started getting dataformat.error's during refresh. The error is not  associated with one row. Instead the whole step fails. After some backward steps to identify the issue , now I am at a stage where I am getting the error



DataFormat.Error: We couldn't convert to Number.



at the sorting step where I was hoping to find some problematic data... 




The immediate step before refreshes fine. It s the step where I converted the values to text in order to debug if something was wrong with the data I have,,,




Any suggestions? 





Frequent Visitor

Well it turned out to be one of the export files had missing columns, so some columns had mismatching type of data which was failing a group by step. I am not sure that expains Power BI behaviour though...

Frequent Visitor

I will now start to remove data sources one by one and see what happens. I  was expecting a magic solution like "OK the cached data must have been corrupt..   Click ctrl-alt-shift refresh and see if that solves it..."  

Super User
Super User

That is indeed weird.  Can you provide sample data in usable format (not as a screenshot) ?

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors