In our SSAS model, we have a column defined as follows:
{
"name": "Progress",
"dataType": "double",
"sourceColumn": "Progress",
"formatString": "Percent"
},
Whenever we export a visual, i.e. regular table, with this column using the exportData function, documented in the link below:
https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/export-data
If the column is currently marked with "Don't Summarize" aggregation, the exported data loses the formatString.
For instance, if the column is summarized in any way, the value is exported correctly formatted:
"100.0%"
If the column has "Don't Summarize" aggregation:
1
I think this might be an issue since it is not reported in the limitations.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.