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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

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.