Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

PowerBI JS Library exportData loses formatString when exporting column aggregations

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.

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

You may check the result by using the Export data command on the options menu and also try FORMAT function.