[see update in description] How to create an Excel Table linked to a Power BI dataset

Опубликовано: 04 Октябрь 2024
на канале: Access Analytic

25,867

429

⚠️See Update below...⚠️⬇️⬇️⬇️

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

⚠️update:
This functionality now seems to have been limited with single table and no measures... not great! ... BUT... you can now create the same thing direct from a visual in a Power BI report:
read this new feature release Jan 2023) https://powerbi.microsoft.com/en-us/b... ⚠️

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)

Here's the article from Matt Allington that got me thinking about this
https://exceleratorbi.com.au/extract-...

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/

Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/