Keep original number format of Power BI table during Excel export

(1) Share

Report

Posted on by Holodan95

Hello All,

I'm currently working on a Power BI report with several tables, that I want to be exported in xlsx format.

It's working alright, however for some reason when I run the flow and check the result, all the numbers are messed up.

In the table visual I have 405 160 334 but in the export it looks like this: 405,160,334,677,667.00

What I need is simply the same data, looking exactly the same as in the online report.

Any idea how to solve this? Also please note, there are different types of values (%,whole number etc..) in the table visual.

When I started, I thought that there will be a method to export the table as is, without all the fuss. I went through this tutorial:

https://youtu.be/cT4JdClkLh8

My region is Hungary. We use , as thousand seperators (but in the report it doesn't show)

Thank you!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Holodan95 10 on at

Like (1)

Report
Copy link

Link copied!

Thanks, I'll give it a try

Was this reply helpful? Yes No
trice602 15,606 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Holodan95 ,

Yes, here is a quick walkthrough from the 30,000 ft level.

Essentially you are going to have a two step flow, 1 trigger, 1 action. Here in this example, I am going to launch an attended desktop flow with runs with Power Automate Desktop. This could be attended or unattended; unattended meaning it will run on a VM on its own with no interaction required.

What this flow does Daniel it essentially launches a browser and opens up your Power BI service page, the one you use to export all your tables. What Power Automate Desktop provides you is the ability to "click on all these visuals" and "click the export buttons", so even if you have 200 tables you need at the end of the month, you can write this one-time and it can be called with a recurrence flow in Power Automate cloud. I do have a handful of flows like this that run with no maintenance or involvement on my part and they "just work".

Here's what this will look like in your cloud flow.

So in this example, I open up a report that contains a visual with a matrix/table that I want to export with the current formatting.

You instruct Power BI Desktop to:

1) Go to this report;
2) Click on the "..." of the visual;
3) Select the appropriate export option;
4) Click on export.

5) Loop to next report, loop through commands, export, next....

So, imagine you have 100 visual matrix's you need to do this for once a month, or at the beginning of the week: Power Automate cloud and desktop together, can do this for you in the middle of the night and when you go in the following morning, all your exports are there and ready for you and the team.

Was this reply helpful? Yes No
Holodan95 10 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Can you give me a walkthrough on automating this kind of export? I knew that I can manually export with this option, but I'm looking for a one button solution, because there are a LOT of tables.

Thanks,
Daniel

Was this reply helpful? Yes No
trice602 15,606 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Holodan95 ,

Here's a great walkthrough to preserve formatting on export. If you want to automate this portion of the export, you may need to implement a quick Desktop flow to click the export button (and steps included) to get your export but I think this is what you are looking for.

Export to Excel Improvements for Table and Matrix Visuals (Preview) | Microsoft Power BI Blog | Microsoft Power BI

Was this reply helpful? Yes No