Power BI

From the Power BI dashboard to a specific page in a Report

Recently, I was working with a customer designing Power BI reports and dashboards.  Everything was going great until she asked this question, “Is it possible to set the hyperlink of a tile on a dashboard to go to a specific page on a report?”.  Hmmm, I thought.  Is it possible?  I dug around the Power BI documentation page looking for an answer, but could not find anything.

While she worked on some additional report formatting I continued my research, and stumbled upon a golden nugget when viewing a report in the Power BI service.  Pay close attention to the URL when navigating between the different pages in the report.  As I changed pages I noticed that the URL suffix changed.

PowerBIReportSection

Page 1, ReportSection, Page2, ReportSection1, Page 3, ReportSection2, this continued in the same manner for each page that was added.

What a great find!  I explained this to the customer.  We copied the URL for the corresponding page, returned to the dashboard and set the hyperlink to the tile to that URL.  Click here for documentation on adding a hyperlink to a dashboard tile.  As always, if you have any questions or comments please send me an email at patrick@sqllunch.com.

Talk to you soon,

Patrick LeBlanc

2 thoughts on “From the Power BI dashboard to a specific page in a Report

  1. Permalink  ⋅ Reply

    Matt

    March 18, 2016 at 3:55pm

    Unfortunatly this does not work when sharing the dashboard and report to another user. Since the guid in the URL is not the same, the link will say the report does not exist.

    Have you encountered this issue and do you know a way to work around this limitation?

    Thanks

    • Permalink  ⋅ Reply

      pleblanc

      October 6, 2016 at 12:38pm

      Matt I am working on a fix for this problem.

Leave a Reply

Your email will not be published. Name and Email fields are required.