Power BI–Export Data (To Excel)–Drillthrough is here!

I’ve already described the basic concept of Analyzing Power BI models in Excel in a previous post.  What I found out today is that drill through to source data is already available!

Starting with an Excel pivot table based on a Power BI model, there is an option called “Show Details” which enables drill through to source data.


The action itself opens a new Excel sheet containing the source data (by default the first 1000 rows are extracted) –> Excel built-in drill through! Smile 


Happy analyzing!



Further Links:


About wolfgang

Data Platform enthusiast
This entry was posted in Business Intelligence, PowerBI and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s