Changing the currency on online version of PowerBI from a sharepoint list

[nigelcreaserc]

I have a report that has been created using the sharepoint integrate with PowerBI option, the problem I have is that i cannot change the currency to be £ and cannot see how to get the report into power BI Desktop to make the changes, any help appreciated.

I also have a issue where some of the dates were incorrect on my list when I first generated my query, i subsequent;y fixed this and now I still get the date coming through incorrectly on the Power BI report

[BHS_KI]

I have the same problem. Is it a bug? And if so, why MS does not fix it?

[Anonymous]

Hi,

I'm having the same issue, I have created a sharepoint list using GBP as the currency, I use the power bi link to create a report and it changes it to USD, I cannot see how to change it online so I downloaded power bi desktop, but it tells me I cannot access the list I have full access to?

[Anonymous]

Hi Nigel, I have the same error, were you able to solve it?

Thanks 

Alexa

[Awie]

Hi Nige

Did you get a way to change the currency when using the Sharepoint integrate with the PowerBI option?
The currency is displaying correctly in my SP list but not in the report. 

Regards

Awie

[Anonymous]

Hi @nigelcreaserc ,

Could you please provide some screenshots to help us clarify your scenario?

In my test, I have got the excel file from SharePoint Folder.

Best Regards,
Eyelyn Qin

[nigelcreaserc]

Hi Eyelyn,

I am using a sharpoint list rather than and excel spreadsheet, the images below show the list and the integrate selelction option adn then the power BI screen

[Anonymous]

Hi @nigelcreaserc ,

Based on my test, you could change the display format of the column:

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Victor0]

Hi Evelyn,

I have the same problem than Nigel

We are using sharepoint lists and the integrated reports that come alone.

In those reports (online), I don't see any option to change the currency either. The data in the corresponding list is displayed as euros (in my case), but I cannot format it in the report (change the symbol, the separator, decimals, etc)

[nigelcreaserc]

Hi Eyelyn,

The report I am using is generated from a SharePoint list and when I look at the Power Bi page there is no ribbon and it does not look like the standard PowerBi online

Thanks

Nige