3 Nov’17

BIDrillthrough Reports in Power BI

Introductions:

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

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more