CODEWITHSUNDEEP
powerbiazure-blob-storagepowerbi-desktop
Francesco Mantovani
Francesco Mantovani

Reputation: 12247

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:

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?

Upvotes: 0

Views: 35

Answers (1)

Francesco Mantovani
Francesco Mantovani

Reputation: 12247

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

Upvotes: 0

Related Questions