How to export table visual with conditional formatting from Power BI to Excel?

Question

I have a table that I want to export to excel with conditional formatting inclusive from Power Bi table visual. How should I go about doing so? I would like to retain it in an as-is manner if possible.

Is there a way to maintain the formatting and appearance in excel??

I don't think this is possible. – Alexis Olson Jun 05 '20 at 20:31 — Alexis Olson, Jun 05 '20 at 20:31
I don't see how DAX Studio would help. – Alexis Olson Jun 06 '20 at 00:52 — Alexis Olson, Jun 06 '20 at 00:52

score 1 · Answer 1 · answered Jun 08 '20 at 20:01

1

I am sorry but in Power BI you can only export raw data. No conditional formatting, no totals.

If you really need this, investigate Report Builder.

Otherwise, you might want to investigate the Analyze in Excel tool.

answered Jun 08 '20 at 20:01

Seymour

3,104
2
22
46

analyze in excel did not work, I'll look into report builder – konsama Jun 08 '20 at 20:09

How to export table visual with conditional formatting from Power BI to Excel?

1 Answers1