cancel
Showing results for 
Search instead for 
Did you mean: 
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 🙂

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors