Forum Discussion
Drill-through report
Anonymous Dashboards are your highest level, and can contain tiles from any number of reports.
Dashboards only exist in the Service.
You can pin any visual, from any number of reports, to the same dashboard.
The user will click a "Tile" on the Dashboard, and be taken to a report page.
When you upload a file from the Desktop to the Service, everything exists on the Service (Azure back end). Nothing relates to your on premise desktop file at that point. There are a bunch of different scenerio's for using different back end sources, but we'll keep it simple...
The support documentation is really good, use the navigation on the left hand side of my link to explore these topics further.
Hope that answers your questions/points you in the right direction.
Anonymous There are only 2 drill through type actions at the moment.
1) Clicking a Tile on a dashboard allows you to drill down to a report page which can show the same or completely different visuals. Thus, allowing you to "drill down"
2) There is a drill-down feature that you can enable on several visuals, but it will only drill down to the next level in your heirarchy showing you the data in the same type of visual.
Hi Eno1978,
Thank you for the reply - how do you do #1 (drill to a report page to show the same or completely different visuals)? How do I create this in power bi desktop (and then publish to power bi in the cloud for the users)? I see the arrows on the visuals but those arrows only allow me to do your #2...
Thank you in advance
Anonymous I now understand the confusion.
OK, Power BI has two parts - The Desktop, and the Service.
They have different capabilities.
The Desktop - You can create models and build reports
The Service - You can build reports, and Share
In order to use the "Sharing" capabilities of Power BI you need to pull your PBIX file into the Service, or hit the "Publish" from your Power BI Desktop. When you have done this, you can go to the Service (app.powerbi.com) and pin visuals from the report that you built to a Dashboard. The Dashboard is shared with end users. So when they click on a tile you pinned to the Dashboard, they will be taken to the report page where the visual was pinned from, and be able to see all the other pages of the report you built.
Hi Eno1978,
Thank you for the prompt reply - one last question (I am very new to power bi) - so to summarize, you are saying that I would create a number of different reports/dashboards in Desktop (ex. Desktop #1, Desktop #2, etc) and then pin desired visuals from each of these into a power bi report via Service (so for example, that published power bi report would have two visuals from the Desktop #1 report, one visual from the Desktop #2 report, etc). If the user (via power bi) clicked on a data point (ex. a location on a map) on the Desktop #1 visual in the published power bi report, then he/she would be taken to the actual Desktop #1 report with its own unique set of visuals and data, correct? I assume the filter would be passed with it (ex. in this example, the actual Desktop #1 report the user was taken to would be filtered on the location that was clicked on by the user in the published power bi dashboard map visual), correct?
If the user clicked on the Desktop #2 visual in the published power bi dashboard, then he/she would be taken to the Desktop #2 report with its own set of unique visuals, etc.
Is the above correct?
Thank you again...