3 Nov’17

BIDrillthrough Reports in Power BI


This blog highlights the feature for Drillthrough in Power BI Services, this is the ability to define a report page as a drillthrough page.

You can now define an individual report page as a Drillthrough page. Ideally these report pages should be configured across a single entity.

With that focused report page, users can right-click on a data point in other report pages, and drillthrough to the focused page to get details that are filtered to that context.

Report Example:

Below example uses the NORTHWIND database as a data Source, you can download sample database from here.

To use drillthrough, create a report page that has visuals you’d like to see about the type of entity for which you’ll provide drillthrough.

Your entity Relation should exist while you provide the drillthrough.

Entity Relation Diagram:

To use the drillthrough functionality right click on the any model and then you can go to the next related page, and data will be filtered according to that data point.

How to create Drillthough in Power BI Reports:

Select the entity that is used in the report, place the column that will be used from the drillthrough and at the page level drop the column in Drillthrough section below, this needs to be added to child page.

When this is added in child page, there will be a back button that will be enabled in the child page.

This button helps to navigate back to the parent page or to Drill Up.

When this setup is complete you can use the drill up functionality in the parent page when you right click on any visual, option will be enabled.

You can try this by yourself on the below power BI Report:

Parent Page: Product
Child Page: Orders, Region, Customer

Feel free to leave comments if there are any issue while implementing the same, or feel free to contact us.

Written by

Jayant Patel

Sr. Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more
  • Cause and Solution for Scribe MSMQ not receiving Message from AX

    10 March’ 2018

    Issue: Microsoft Message Queuing (MSMQ) service running on Server might be unable to receive messages. Therefore, messa...

    Read more
  • User Privileges on SharePoint – D365 Document Integration

    10 March’ 2018

    Overview: Often, we wonder what could be wrong where we see a generic error on Documents in Dynamics 365. Something lik...

    Read more