Export from Power BI to Excel 12 ways - NEW in 2023

You can now export from Power BI to Excel in 12 ways including the new way to export a table and keep the data refreshed in Excel. The already existing way to export a "featured table" to a "Data type" in Excel is extraordinarily useful but rarely implemented.

Often I want to export data in as few clicks as possible to play around in Excel. It can be static and  Power BI's built in way is slow, so I have an unusual method to screenshot it and use Excel's new "Get data from picture" feature that I showcase here too.

Example files can be found here: www.xlconsulting-asia.com/youtube-files

00:00 - Introduction
00:33 - Export linked table
01:42 - Export pivoted data (static)
02:40 - Linked data types
06:01 - Get Data from Power BI
07:16 - Insert Pivot from Power BI
07:24 - Excel for the web
07:58 - Export data from Desktop
08:32 - Copy selection
09:00 - Copy value
09:10 - Data from picture
10:51 - Copy from data view
11:06 - Copy from Power Query editor
11:29 - Copy entire query
12:05 - Settings to grab data from Excel