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.
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
Solved! Go to Solution.
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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
Proud to be a Super User!
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
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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
Proud to be a Super User!
thank you. this is the one I am looking for. they have newly added in pivot table eclipse.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |