Search code examples
powerbiazure-blob-storagepowerbi-desktop

Power BI refresh multiply currencies

I have a Power BI dashboard that is reading .CSV files form an Azure Storage Account.

I'm using it to compare our Azure costs and on the Power BI Desktop everything is fine. The columns are created from the costInBillingCurrency to which I gave:

  • Data type: Decimal number
  • Format: Currency

enter image description here

So I publish it online and I see the same result. Beautiful.

Then I wait 24h, the data refresh pulling the data from the Azure Storage Account, all broken:

enter image description here

It seems like that the currency is multiplied multiple times.

What it is going on?

Solution

  • I changed the Data type form Decimal number to Fixed decimal number.

    And this is actually how money should be treated, as per the icon next to it:

    enter image description here