- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Export data from Power BI desktop into multiple tabs of the same excel sheet ?
Can we Export data from Power BI desktop into multiple tabs of the same excel sheet ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, I used to do this all the time in SSRS.
Here is an article describing it in Paginated Reports, which I have just verified works as intended: https://www.sqlshack.com/exporting-ssrs-reports-to-multiple-worksheets-in-excel/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The following Microsoft doc suggests that it can be done (create an Excel file with multiple worksheets from one paginated report). Does anyone have experience doing this?
Pagination in Power BI paginated reports - Power BI | Microsoft Docs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Following up late: One can use PBI Report Builder to create a paginated report that can export to multiple tab Excel file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @kumar27
You can use DAX Studio to export tables to CSV files from Power BI Desktop. Go to Advanced > Export Data and choose CSV Files, then follow the steps in Export Data Wizard. This will export tables into separate csv files. You could use other tools or methods to combine them into multiple tabs of the same excel workbook.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@kumar27 , I doubt that. May be you can use R or Python code for that
https://pawarbi.github.io/blog/powerbi/python/sql/export/2020/06/23/export-powerbi-sql-python.html
https://owlcation.com/stem/How-to-Export-Data-from-Power-BI
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can copy entire table in the model view and paste it on the excel manually, export data from a visual in the options panel of the visual, or create a excel coneected to a BI dataset on power bi dataset , this will work as a power pivot with direct connection to the dataset.
Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!
Proud to be a Super User!
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
08-04-2024 09:49 PM | |||
08-17-2023 07:57 AM | |||
06-12-2024 08:14 PM | |||
Anonymous
| 12-23-2022 02:24 AM | ||
12-13-2022 07:47 AM |
User | Count |
---|---|
123 | |
79 | |
59 | |
58 | |
44 |
User | Count |
---|---|
179 | |
120 | |
82 | |
70 | |
53 |