Forum Discussion
Export multiple table visuals to one excel
I would to export all the 4 tables shown in the screenshot below to one excel file. How can I approach this.
I was thinking to build this in powerbi builder and give the end user a button to send it to himself by email or blob storage. But is there an easier way for the end user to download this directly on his laptop ?
Thank you
3 Replies
Hello Reda899 ,
You can simply create a new table using DAX
New_Table = UNION(Table1, Table2, Table3, Table4)
(This only works when you have the same columns on all 4 tables)This will give you a single view of data from which your users can export data directly.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂I should have mentioned that it's not all same columns with same calculations. So thats the issue I am facing.
Hi Reda899 ,
You may take a look at analyze-in-excel feature.
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/
Best Regards,
Jay
