Exporting financial reports to Excel with formatting preserved

Started by François Leblond · 1 year, 5 months ago · 3 replies · 1 view

François Leblond Participant

1 year, 5 months ago

Our finance team wants to share formatted financial tables with stakeholders who don't have access to Fabric Plan. The docs mention 'Fully Formatted Exports to Excel & PDF'. How well does the Excel export preserve formatting?

3 Replies

Sort

Lena Fischer

Power BI Developer · AlpenTech GmbH · 1 year, 5 months ago

The Excel export from Intelligence sheets is very high quality — it preserves column widths, row groupings, subtotal formatting, bold/colour for headers, and number formats. The exported file is static (not connected to Fabric Plan) but it looks like a professionally formatted report.

Up

0

James Whitfield

Head of Management Reporting · Apex Capital Partners · 1 year, 5 months ago

We use the PDF export for board packs (pixel-perfect, print-ready) and the Excel export for finance teams who want to do their own analysis on top of the data. Both are excellent.

Up

0

Ayesha Okonkwo

Corporate Finance Manager · Meridian Bank · 1 year, 4 months ago

One limitation: complex conditional formatting (RAG colour coding based on values) doesn't always translate perfectly to Excel. Simple formats (bold, borders, number format) translate cleanly. Test your most complex reports before committing to Excel as your delivery format.

Up

0