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.
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...
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.
I have the same question, like we do in SSRS where we can create a subreport or an action on a single bar of graph, then we will be directed to an seperate report where the filter is continued.
Can we do the same here, I somehow managed to pin a dasboard from other dashboard, but now I need to click on a particluar bar and go to the other repoort or dashboard that has detail information about that bar.
Drill Through Action - Default
Users can pin tiles from Reports (built in PBI Desktop or Service) to Dashboards. when users click on a tile on the dashboard, they will be redirected to the Report the tile belongs to.
Exception : If you pin the whole Report to a Dashboard using "Pin Live Page" option, then the drill through is disabled (may be because the whole report is live on the dashboard and there is no point in drilling through to a Report).
Problem: How ever the problem with that approach is that the users will not be able to use the Drill DOWN functionality if any in the dashboard mode. That if if one of the tile is a Bar chart with drilldown functionality, that is disabled in the Dashboard Mode (I wish it was'nt that way!!) please correct me if i am wrong!
Alternative Option : We can click on the ellipsis (...) on the top right hand side of the dashboard to go to the report. and all the functionality(including Drill Downs) will be available from the report.
Drill Through Action - Configurable
I guess what ShanAK and Cudjh1 are referring to is the capability of configuring Drill Through action from Tiles to a report of their choice (not just the default report the tile was pinned from ). for example if a Dashboard has a tile pinned from Report A, users should be able to configure a drill through to another report (say report B) if needed.
or for example add an image tile to a new Dashboard and configure it to go to a particular Report / Dashboard when a user clicks on that image tile! (That would be awesome! we can have one dashbord with links to all the fav reports / Dashboards )
I beleive That is NOT possible as of today.
Alternative Option : Add an image to each report you want to drill through to and pin those images to a central dashboard !
I am new to Power BI as well so please correct me if i am wrong!
Anonymous
at least is there any way in service that if we pin a visual to a dashboard from the first page of a report, when i click on the visual in the dashboard, can it take me to the second page of the same report...??:smileysad:
Anonymous You can get a visual to navigate to any page of your report.
Say you currently have visual A on report page 1, but you want it to navigate to report page 2. You can do this in 2 different ways.
1) Edit the tile on the dashboard and set a custom navigation path. click the '...' and the pencil icon, and set the URL to the report page 2. (there is a current bug in this and it won't open the page in another tab if you set it to do so)
2) You can take Visual A and recreate it on page 2 of the report. Pin it from page 2. Then delete it from page 2. This will have the desired effect, and the tile will continue to be updated with data.
Hey Anonymous
Thank You.
