How to create an Excel Table linked to a Power BI dataset

In this Video

00:00 Intro

00:25 Show Query - Create a Table and get the code

02:19 Open in Excel for Web and then open in desktop

03:30 Edit the table query

04:56 Creating Row Level Security

05:40 Share dataset build access

06:20 Opening the file and refresh as the other user (plus a bug)

Extract Tabular Data From Power BI Service to Excel

I first wrote this article about how to import Tabular Data from Power BI into Excel back in Jan 2017. The benefits of extracting tabular data are still the same as they were back then however the process of extracting the tabular data from Power BI has changed.

Open Article on exceleratorbi