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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
abc_777
Super User
Super User

Power Bi to Excel Pivot format

Hi,

 

We are waiting for the power bi pivot table to take to ms excel. 

 

This time when we take a report it comes csv format which is hard to read, alternatively, we have to connect the data points to excel and again re structure data for getting the report.

 

in qlik sense taking a report to excel is easy 

 

is there any timeline when Microsoft can solve this issue as power bi and ms excel both are their own product?

 

thx

1 ACCEPTED SOLUTION
ALLUREAN
Solution Sage
Solution Sage

Hi @abc_777 

 

I think that you can export the same structure of the table to excel (pivot-like)

https://www.youtube.com/watch?v=P3YGijJSPAw

 

 

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Ola_S
Frequent Visitor

Export to Excel with a live link to Power BI Desktop

You may also want to try an External Tool called "Power BI Side Tool" :

* ext; External Tool - PBI SideTool :

+ Export to Excel : https://youtu.be/z04v4vy7T50?t=1719

+ DAX Debugger : https://youtu.be/z04v4vy7T50?t=2653

+ download portable version (no install) : https://github.com/didierterrien/Power-BI-Sidetools/tree/master/Power%20BI%20Sidetools%20test%20vers...

..Test your Measures in a Separate Window, as you build

ALLUREAN
Solution Sage
Solution Sage

Hi @abc_777 

 

I think that you can export the same structure of the table to excel (pivot-like)

https://www.youtube.com/watch?v=P3YGijJSPAw

 

 

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




thank you. this is the one I am looking for. they have newly added in pivot table eclipse.

 

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors