Forum Discussion
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
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 !!!
3 Replies
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 !!!
thank you. this is the one I am looking for. they have newly added in pivot table eclipse.
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%20version
..Test your Measures in a Separate Window, as you build
