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
SantoshKumar
Microsoft Employee
Microsoft Employee

Dataformat error: we couldn't convert to Number issue

Hi ,

I am trying to Left Outer Join the two excel data here. ->  lets say Table1, Table2.

 

Below is my condition: Left Outer (All from first, matching from Second)

I have used ID coumns from the both tables and since few values are of alphanumeric like cac123 etc, i made sure that both ID columns are in Text format.

I was able to apply the Left Outer Join but when i tried to Expand the second table(table2) in the MergedTable , it throws me an  error as " Dataformat error: we couldn't convert to number: Details  C15810"

 

Any help is greatly appreciated.

 

Thanks

Santosh 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@SantoshKumar , with this error, it seems like still in one of the tables, the data type is not text. Make sure you have changed it in correct table. Or there is transformation post that causing it 

View solution in original post

6 REPLIES 6
ALLUREAN
Solution Sage
Solution Sage

Hi, @SantoshKumar 

 

Would you attach a picture of tables headers and 1-2 rows with data?




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




@ALLUREAN thanks for looking into my issue but its a transformation post that caused the issue and at now, it is corrected.

amitchandak
Super User
Super User

@SantoshKumar , with this error, it seems like still in one of the tables, the data type is not text. Make sure you have changed it in correct table. Or there is transformation post that causing it 

@amitchandak you were right. i took all the steps which i have performed on the data and its look like,

at first the ID column which was in Text format - i have changed it to Numeric and later on i rechanged it agian to Text format.
by removing the wrong step : which is changing the format to numeric, i was able to resolve the issue.
I could say its an Human error but accept your suggestion as a solution for my question.

Thanks again !!

@amitchandak Yes , i have crossed checked the data type on the both tables and amde sure both are text before merging them. looking for any alternate solutions to solve the issue.

@SantoshKumar , Can you a sample pbix after removing sensitive data.

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.

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.

Top Solution Authors