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, 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
Solved! Go to Solution.
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |