Export multiple tabels to excel

[ThomasWeppler]

Hi power Bi community

My client wants to export two diffrent tabels to excel.

Is it possible to make it so they don't have to download two diffrent excel arks and cut and paste them together?
I was thinking exporting the two tabels into the same excel ark or just make a very complicated tabel in excel that allows this?

[v-jianpeng-msft · Accepted solution]

Your solution is so great audreygerred 

Hi, @ThomasWeppler 

In addition to the methods mentioned by Super User, you can also utilize Power Automate to export reports to excel and utilize Power Automate to provide the Merge Multiple Workbooks into One Excel feature to do what you describe.
Of course, we can also utilize the export file API provided by Power BI to do this with Power Automate Merge Excel.
Here are some tutorials that may help you:
First is the Power Automate tutorial for exporting Power BI reports to Excel:

Export and email a report with Power Automate - Power BI | Microsoft Learn

Next up is the Power Automate tutorial for merging multiple Excel files into one excel:

Combine workbooks into a single workbook - Office Scripts | Microsoft Learn

In addition, if you are good at programming, you can call the API interface provided by Power BI:

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Overall, you need to have an understanding of programming and then go about realizing your needs. There is no direct implementation of the functionality you describe in Power BI Service itself. But it is possible to achieve similar effects through programming or scripting or Power Automate.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ThomasWeppler]

Thansk for the answer, @v-jianpeng-msft It seems to be what I needed.

[audreygerred]

In Power BI, can you make a table that is the combination of both tables and then he only has to download from one? Another option would be using Analyze in Excel and just building the pivot in there as it is connected to the semantic model. You can also check out connected tables and maybe create what is needed this way and again, it is connected to the semantic model. With these connected options the user would need a pro license: Announcing new ways to create connected tables in Excel connected to Power BI | Microsoft Power BI B...