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
pbradshaw
New Member

Merging Queries throws DataFormat.Error: we Couldn't convert to Number IC2007

I'm trying to merge two queries and it's giving me a "DataFormat.Error: We couldn't convert to Number. Details: IC2007" Error... except I'm not merging based on a number nor am I trying to return a number when joining the two queries...

 

I tried merging the two data sources just by themselves in a separate document and it worked, but it continues to throw the error in my large working document. 

 

I've also tried recreating the query and it still throws the same error. Any insight into what is causing this issue? Is my power bi file just too large? 

 

I haven't been able to find an error code IC2007 anywhere online. 

 

**cannot provide data due to security and privacy** 

1 REPLY 1
rohit_singh
Solution Sage
Solution Sage

Hi @pbradshaw ,

Really hard to say what might be happening without looking at the data, but my best guess is that there is a #"Changed Type" step somewhere in your query that is forcefully trying to convert an alphanumeric column into a number format. IC2007 may not be an error code but the actual value that in your column that is causing the issue.
Try checking columns in any #"Changed Type" steps after the merge and change type to text. 

rohit_singh_0-1654865022168.png

 

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Helpful resources

Announcements
Europe Fabric Conference

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors