Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Consuming a DAX query in Excel - Unplugged #5

SQLBI
120K subscribers
14K views 4 years ago #unplugged
Did you know you can execute a DAX query... in Excel? It is way faster than a PivotTable when it comes to retrieving a large amount of data in a table format. Let's see how it works and how to create a query in DAX Studio (just with the Query Builder, no DAX knowledge required!) and then customize the query in Excel so that you enter a parameter... in Excel cells, of course! Spoiler: Marco is a developer, but he is not that good at VBA. You are allowed to make jokes about his VBA skills in the comments! Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged ...more
...more
Consuming a DAX query in Excel - Unplugged #5
364Likes
14,226Views
2021Feb 6
Did you know you can execute a DAX query... in Excel? It is way faster than a PivotTable when it comes to retrieving a large amount of data in a table format. Let's see how it works and how to create a query in DAX Studio (just with the Query Builder, no DAX knowledge required!) and then customize the query in Excel so that you enter a parameter... in Excel cells, of course! Spoiler: Marco is a developer, but he is not that good at VBA. You are allowed to make jokes about his VBA skills in the comments! Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Follow along using the transcript.

SQLBI

120K subscribers