Missing Data when creating a report from Sharepoint list

[Michael85]

Good day

I'm trying to create a simple report directly from a sharepoint list, however the data in one of the column appears to be blank more specifically the price column. 

If I click on "show data table" in power Bi I will get the following:

The entire price column appears as "0". 

However, if you look at the column in  the sharepoint list, there are prices in some of the items.

Any idea what could be causing this? 

Thank you for any help provided. 

[aj1973 · Accepted solution]

Hi @Michael85 

looks like there is a mismatch in the currency used