extract The Power Query Result in Excel

[Carlo1975]

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

[Jimmy801]

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

[Fowmy · Accepted 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 🙂

Website YouTube  LinkedIn