Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bdenny
Frequent Visitor

Cannot transform text to decimal after Combing Binaries

Hi,

 

I have a folder with a lot of csv-files and they have the same columns. When I tell Power BI to combine all those csv-files using 'Combine Binaries it looks pretty good but each column has the data type 'text'. So I can't create any visualizations yet because the column containing values is still seen as text and when I try to transform it to decimal is shows an Error. When I filter that specific column the values look very weird:

 

d90182803e

 

Any idea why Power BI reads the data this way? A sample of the raw data for this column:

28

1.238

42.890

1 ACCEPTED SOLUTION

Hi,

 

Thanks for your reply. The / you saw is a 7. But Power BI detected the wrong encoding. When I selected the right encoding (Unicode) everything works fine 🙂

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @bdenny,


According to your screenshot, I find a lot of types in your column.(text: 1.1/1, decimal number, whole number)

Since your column contain the data which can't convert to decimal(1.1/1), it may get some odd result when you try to convert them.

 

In addition, can you share us a sample file to test?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi,

 

Thanks for your reply. The / you saw is a 7. But Power BI detected the wrong encoding. When I selected the right encoding (Unicode) everything works fine 🙂

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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