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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RZ
Frequent Visitor

Unexpected behaviour in Power Query

Hello,

 

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.
Details:
    True

 

 

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

 

RZ_0-1685689429606.png

 

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,,,

 

RZ_1-1685689463975.png

 

Any suggestions? 

 

Thanks...

Ruchan 

 

3 REPLIES 3
RZ
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...

RZ
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..."  

lbendlin
Super User
Super User

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors