cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SantoshKumar
Microsoft
Microsoft

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
Super User
Super User

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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.