Forum Discussion
BUG: Datamart doesn't honor currency formatting
I have various dataflow columns set as currency, but they appear as decimal numbers in the datamart with no way of changing the format when using the datamart in the client.
It's not a bug, it's a documented limitation as these columns are stored as float in the SQL database:
"Currently datamarts don’t support the currency data type, and such data types will be converted to float."
From:
https://docs.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-administration
2 Replies
- otravers
Community Champion
It's not a bug, it's a documented limitation as these columns are stored as float in the SQL database:
"Currently datamarts don’t support the currency data type, and such data types will be converted to float."
From:
https://docs.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-administration 
PBI_AMSHelper I
I recognize this is in the documentation and why, but how are folks working around it? I have a sharepoint table with employee sales goals that I'm bringing into a datamart. In my Power BI report, I'm able to report the sales against the goal, but I want to be able to show it like this:
$Sales | $Goal | $Remaining to sell
I can get Sales and Remaining to sell to show as currency, but I can't figure out how to convert Goal from an integer to currency. Any thoughts?