Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
cspann
New Member

Need to Export Pivoted Data

Hello.

 

We have a need to export pivoted data from Power BI, into Excel, with the ability to drill down.  I realize that there is a feature that has been requested, but not yet implemented, to do just this.  It is a major need for my company.  We are a small team, and we really can't handle the administrative/development overhead of installing and maintaining SSRS or SSAS to accomplish this.  

 

Surely someone has a simple trick to do this?

 

Thank you in advance.

6 REPLIES 6
FirojLayek12
Regular Visitor

I think you can use "Analyze in Excel" option. it will help you to achive your requirement.

Analyze in Excel would be a good option for certain users, but not for all.  In addition, when you refresh, it will overwrite the previous data, and there is a strong possibility that someone will do that before saving an offline copy of the previous report.  this would be bad, because we need to keep copies of monthly reports.

 

According to this link, the Matrix export will be availiable for public preview in October.  This looks exactly like what we need.  Any thoughts on this?

 

https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/export-excel-improve...

 

Hi @cspann,

If you have any additional requirements or personal insight about this feature, you can consider to submit to the idea forum or send feedback to help improve the preview feature usages.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
FirojLayek12
Regular Visitor

I think you can use "Analyze in Excel" option. it will help you to achive your requirement.

v-shex-msft
Community Support
Community Support

Hi @cspann,

AFAIK, power bi export feature will export the soruce table records with underline or summarize mode, they did not support exporting the pivoted records or keeping current visual styles.

Export data from a Power BI visualization - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
lbendlin
Super User
Super User

Is teaching your users how to use "Analyze in Excel" an option for you?  It would do all this and then some, but it requires a little bit of training.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.