Forum Discussion
extract The Power Query Result in Excel
Hi, I'm Working a lot in Power query to realize the report in Power BI....I'm merged some tables, I'm filtered some data and I have created new columns (the final table has 13.000 record). After that I have realized all the analysis with Power BI.
Now, who ask me the report wants also all the data that I have used, I think to verify or to do new analysis, but I can't extract the data from Power BI to Excel and I cannot do Copy and paste because: I see only 1000 record and however, all numbers are then pasted wrong (with decimals becoming thousands).
Do you know how can I do it?
thank you
Carlo1975
You easily export the data to CSV format using DAX Studio: https://xxlbi.com/blog/dax-studio-export-all-data/DAX Studio can be downloaded from: https://daxstudio.org/downloads/
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
2 Replies
Carlo1975
You easily export the data to CSV format using DAX Studio: https://xxlbi.com/blog/dax-studio-export-all-data/DAX Studio can be downloaded from: https://daxstudio.org/downloads/
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Hello Carlo1975
you can go to every single table in Power BI Desktop, and copy paste the content to Excel
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
