Forum Discussion

Nikhill90's avatar
Nikhill90
Frequent Visitor
8 years ago
Solved

Number getting rounded off

Hi,   While importing data from Shopify, it automatically is rounding off the the columns, even though the data type is set to decimal number. I set the data type, format and decimal to 2 places in...
Need Help
  • Nikhill90's avatar
    Nikhill90
    8 years ago

    Hi all,

     

    Thank you for the help. I had directly sent a mail to the suüpoort of power bi API connector for shopify. It was a problem in their API and they fixed it today morning. Thank you again for all the help.

     

    Regards,

    Nik

Nikhill90's avatar
Nikhill90
Frequent Visitor
8 years ago

Would be great if someone could tell me the code for setting data type in the power querry editor itself, so that it is imported that way.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

 

Hi Nikhill90,

 

Which datasource you used? Does it sqlite?
If this is a case, you can refer to below link which about sqlite decimal issue.

Connection ODBC Sqlite decimal size limit

 

Regards,

Xiaoxin Sheng

  • Nikhill90's avatar
    Nikhill90
    Frequent Visitor
    8 years ago

    Hi all,

     

    Thank you for the help. I had directly sent a mail to the suüpoort of power bi API connector for shopify. It was a problem in their API and they fixed it today morning. Thank you again for all the help.

     

    Regards,

    Nik