Forum Discussion

Zorgonaute84's avatar
Zorgonaute84
Regular Visitor
8 years ago
Solved

Decimal data strange issue

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...
  • Zorgonaute84's avatar
    Zorgonaute84
    8 years ago

    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.

     

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Zorgonaute84

 

Based on your description, it seems like your issue is related to something like decimal rounding which is caused by ODBC connector. There may exists compatibility issue between the connector and Power BI.

 

To troubleshooting it, I would suggest you to keep one time type field data in source table and after importing the source table in Power BI, do the formatting at Power BI desktop side. To verify if the issue persists.

 

Thanks,
Xi Jin.

  • Zorgonaute84's avatar
    Zorgonaute84
    Regular Visitor
    8 years ago

    Hello,

     

    Thanks for your help.

     

    But I have the issue in the Query Editor and in Power BI. I tried to localize the decimal value, to apply rounding etc... But nothing change. The strange thing is, I used the same OLEDB connector into Excel, and I havn't this issue. The data are correct.

     

    Any idea ?

     

    Thanks

    • v-xjiin-msft's avatar
      v-xjiin-msft
      Solution Sage
      8 years ago

      Zorgonaute84

       

      Power BI is different with Excel for OLEDB connector.

       

      Could you please share us some screenshots about your issue if possible? So that we can understand your issue more clearly.

       

      Thanks,
      Xi Jin.

      • Zorgonaute84's avatar
        Zorgonaute84
        Regular Visitor
        8 years ago

        This is a screenshot from PowerBI :

         

         

        The same SQL request from Excel :

         

        And the values display in the original source :

         

        The value from Excel are good, but from PowerBI the 1st is correct, but the second is multiplied by 100.