So I have appfigures set-up and it tells me things such as revenue in £GBP but when the data comes through the connector into BI it seems to keep the same value but it's in USD. I'm not sure if this is a problem with BI or the appfigures api.
Anyone else spotted this (or know a way I can flip the currency in BI)?
I have two reports based on the same data format (I still have to create a new report each month - that's a separate post) and PowerBI displays one using USD and one using GBP. I can't figure out why - the advanced query editor shows the same transformations going on - nothing relating to locale.
I am using PowerBI desktop to create the reports and haven't added anything beyond what comes with what is downloaded from Microsoft.
Just found the interface for specifying the currency that is being used - it isn't in the data transformation interface. Rather it is a setting that can be applied when viewing the data tables in PowerBI desktop - the menu on the right in PowerBI desktop - second from the top that is a graphic of a table.
Select the columns that are a currency, then in the Formatting group, select format > Currency > the currency you want.
I can't work out how you would do this in the web interface.
You can use the desktop to upload your data and reports to the web interface - use the publish button. You can't go in the opposite direction, so if you are going to use the Desktop tool at all, I would recommend doing all your authoring in it, so you can save all the settings locally.