The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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**
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.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
38 | |
21 | |
20 | |
16 | |
13 |