Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
Zorgonaute84
Regular Visitor

Decimal data strange issue

‎01-24-2018 07:13 AM

Hello,

 

I'm using PowerBI from 2 months ago now, and I occure a very strange issue regarding decimal data.

 

In fact, my data is a duration in hours. So 20 minutes is 0.3 hours. The problem with my data is some lines are correct, but someones are multiplied by 100 without any reasons.

 

I'm connected to my data with a OLEDB connector and when I configured the same connection into Excel, the data are correct. Any idea ?

 

Thanks a lot for your help.

Message 1 of 11
2,137 Views
0
1 ACCEPTED SOLUTION
Zorgonaute84
Regular Visitor

‎03-06-2018 07:22 AM

Hello,

 

I finally fixed my issue !

 

I CAST my field as a float in my SQL request :

 

SELECT CAST(GA_NBH as Float) as GANBH

 

So my new field GANBH is now correct !!!  No idea why I had to do that, and why some value was correct and other not.

 

View solution in original post

Message 11 of 11
2,131 Views
0
10 REPLIES 10

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

View All