Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors