Forum Discussion

IanCockcroft's avatar
IanCockcroft
Icon for Post Patron rankPost Patron
7 years ago

WEB data decimal formats

Hi guys, I am scubbing a web page for data and the values are quiet big. The figure $175,244,830,137, is brought into PBI as $175.24 B. I presume the B is for billion. Any idea why and how   I ca...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi IanCockcroft ,

By my tests, I cannot reproduce your scenario when load data from web in power bi.

Do you have this issue for loading data or creating the visuals?

In addition, will you have this issue if you get data from the local excel ?

Best  Regards,

Cherry

 

  • IanCockcroft's avatar
    IanCockcroft
    Icon for Post Patron rankPost Patron
    7 years ago

    Hi guys, thanks for having a look.

    the site is coinmarketcap.com

    They do  have an API which I am trying to connect to, so I have abandoned this effort.

    thanks again.

    i

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      Hi IanCockcroft ,

      By my tests with the web site, I could reproduce your issue.

      I'm afraid that issue should be caused by the API.

      Best Regards,

      Cherry