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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.