The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.