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
abc_777
Post Prodigy
Post Prodigy

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
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.