How to export clean values from ai/bi dashboard table that uses html formatted columns

anmolhhns
New Contributor III

I'm working on Databricks AI/BI dashboard containing a native visualization; to achieve custom styling such as progress bars, the dataset SQL Generates HTML strings using expressions similar to:

CONCAT( '<div style="...">', CAST(value AS STRING), '</div>' ) AS formatted_value

The HTML renders correctly within dashboard table but when the data is exported the HTML tags are also exported along with it. Is it possible to export data without HTML tags?

anmolhhns_0-1785592434957.png