DEV Community

Zane
Zane

Posted on Originally published at unraster.ai

Power BI to Editable PowerPoint: Fixing the Flat Export

Power BI to Editable PowerPoint: Fixing the Flat Export

A quarterly review arrives as a .pptx. You open it, click the revenue number, and the whole slide gets a selection box. Nothing types. Nothing moves.

The file is not broken. In the Power BI service, Export → PowerPoint → Export as image gives each report page its own slide, and each slide holds one picture. Microsoft's documentation calls the exported page a single high-resolution image and the slide static, and notes that the export adds a link back to the report. Fine for circulating a deck; useless for the one edit your manager just asked for.

Below are the routes I would try, manual first. I build one of the tools here, so I will be explicit about where it helps and where it stops.

Check what you actually have

Open the .pptx and click a label or a number. A text cursor means the slide is already editable, so stop reading. If the whole slide gets one selection box, you have a picture. The same test works on a PDF: select a sentence; a box around the page means an image.

Power BI's export makes this predictable: each report page becomes an independent image at 1,280 × 720 pixels. That is fine on a screen and thin in print, which matters for a handout.

Option 1: rebuild the page from the report and the image

This is the route I would take for a single slide, and it needs no extra service.

  1. Get a clean page image. Open the exported .pptx, right-click the slide picture and save it as PNG or JPG, or screenshot the report page.
  2. Read the values from the report. If you still have access, copy the numbers there. Retyping from the source beats OCR on a chart label, which is where recognition tends to slip.
  3. Build the slide. Start from a blank 16:9 slide, put the title and each KPI in its own text box, draw rectangles for the cards, and rebuild table visuals as a native table.
  4. Use a real chart. Insert a PowerPoint chart and type the series values. This is what the image route cannot give you: a chart with a data sheet behind it.
  5. Compare side by side. Original image on one side, rebuild on the other; check spacing, alignment and every figure.

If you have lost access to the report, a desktop text picker (the menu name varies by version) can lift the numbers; proofread every one.

When it is worth it: you need a chart you can edit from data and the deck will be reused. What it costs: your afternoon; a page with four visuals and a table can take an hour, and next month you do it again.

Option 2: patch the picture in place

The shortcut everyone tries first: leave the image as the slide background, draw a rectangle in the background colour over the old number, and type the new one on top.

It works on a flat background for a short label. It falls apart on a gradient, when the replacement text is longer, or when someone else moves things around. The old value is also still underneath the patch, which matters if a reviewer checks the slide against the report. Keep this for a single showing, not for a file that gets passed around.

Option 3: convert the page image into slide objects

Here is where my own tool fits. I build Unraster, and the Power BI page is at unraster.ai/power-bi-to-editable-powerpoint. It takes the page image and rebuilds it as native PowerPoint text boxes and shapes. It does not connect to Power BI or your dataset; it only sees the image you upload.

The steps:

  1. Save the page as an image. Use the same PNG or JPG from Option 1, or a screenshot of the dashboard.
  2. Upload it. One image per slide. On the website you can also upload one PDF of up to 30 pages, or up to 30 images, and get one deck back. The API takes one image per request.
  3. Look at the preview for a single page. The first PowerPoint preview on a new account is free, with rebuilt objects outlined, so you can see what became text and what became a shape. Whole-deck uploads have no free preview.
  4. Download and edit. Text lands in text boxes you can retype. Bars, lines and donut segments land as separate shapes you can move and recolour.

What a converted dashboard actually looks like

The sample on that page is a self-made, Power BI-style sales dashboard with invented data, not a customer report. On that sample, titles, KPI numbers and table text came back as text boxes, and the bars, lines and donut came back as shapes.

The same page records what did not survive: the legend swatches and the smallest bar were lost, and several month labels were merged into a few text boxes. The result is a first draft of the layout, not a substitute for checking the numbers.

Where the conversion stops

Charts are drawings, not charts. A bar or a donut comes back as shapes with no data table behind it. To change a value you retype the label or rebuild the chart from your data. If the slide has to be updated from a spreadsheet later, rebuild it as a native chart.

Dense pages lose detail. Large titles and numbers do well. Very small text, legends and thin lines can be misread or dropped, so a dashboard with eight visuals and a footnote is a harder input than a page with three KPI cards.

Interactivity does not travel. The export is a static image, so slicers, filters and tooltips are only pixels by the time they reach PowerPoint. The converter rebuilds what is visible; it cannot bring back a control that was never in the image.

Someone still has to check it. Read every figure against the report before the deck leaves your hands. The tool saves the redrawing, not the proofreading.

If the deck is refreshed every month

If the deck is a snapshot for a meeting and nobody will edit it, the exported image is fine as it is. If the audience needs to filter or drill, Microsoft offers a live report page in PowerPoint through its add-in; that stays connected to the report, which is not the same thing as editable shapes. If the slide needs a rewritten headline or a reordered layout, convert it or rebuild it.

For a monthly deck with the same layout, the durable answer is a template: rebuild the page once with native charts and text boxes, then swap the values each month. Converting the image again every month is fine for a one-off appendix, but it is not a refresh workflow.

A five-minute checklist

  • Click the number. Is the slide a picture or real text?
  • Can you read the values from the report instead of the image?
  • Does the deck need a live chart with data, or just editable labels?
  • Did you check every figure against the source before sharing?

PowerPoint output is 2 credits per delivered file or page, the first preview on a new account is free to inspect, downloads add nothing, and a failed conversion costs no credits.

Disclosure

I build Unraster, the converter in Option 3, and I run it as an individual. The manual routes above are not straw men: for one slide with the report open beside you, rebuilding often gives the cleaner file. If a conversion comes back wrong, email support@unraster.ai with the image and I will look at it.

Top comments (0)