Forum Discussion

Michael85's avatar
Michael85
Regular Visitor
2 years ago
Solved

Missing Data when creating a report from Sharepoint list

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. 

 

 

 

1 Reply

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion

    Hi Michael85 

    looks like there is a mismatch in the currency used