Forum Discussion

Max_kaplan's avatar
Max_kaplan
Regular Visitor
2 years ago

Specific page in power bi

Hello

 

Somebody know how can i get url for specific page of power bi report in report server?

6 Replies

  • hackcrr's avatar
    hackcrr
    Memorable Member

    Hi, Max_kaplan 

    Navigate to a Power BI report on Power BI Report Server. Open the report where you want to link to a specific page. The base URL for the report will look like this:

    http://[YourReportServer]/reports/powerbi/[YourReportName]
    

    To link to a specific page, append the ?pageName or ?pageIndex parameter:

    http://[YourReportServer]/reports/powerbi/[YourReportName]?pageName=[PageName]
    

    For example:

    http://myreportserver/reports/powerbi/SalesReport?pageName=Page2
    
    http://myreportserver/reports/powerbi/SalesReport?pageIndex=1
    

     

     

    hackcrr

    If I have answered your question, please mark my reply as solution and kudos to this post, thank you!

  • Hi hackcrr , thank you for the reply. I have gone through the shared links above. but none of them talks about below points. and also there is another discussion going on for the same requirement where it can be seen that the below solution doesn't work. it would be helpful if you can share some screenshot with below point in working solution.

    http://myreportserver/reports/powerbi/SalesReport?pageName=Page2
    http://myreportserver/reports/powerbi/SalesReport?pageIndex=1

    https://community.fabric.microsoft.com/t5/Report-Server/How-to-select-a-specific-report-page-from-the-URL-when-using-the/m-p/557882 

     

    Thanks,

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, Max_kaplan 

      I've found that when you switch pages, most of the links don't change, only this one does:

      Page1

      Page2

       

      So we can recreate the report and use the URL to establish a connection to the page. Screenshot the redlined part of the URL and create a new table

       

      Then create a new slicer and create a new measure to change the view's label

      PageName = SWITCH(TRUE(),
      SELECTEDVALUE('Table'[PageURL])="ded9a87745eaa36596ca","Page1",
      SELECTEDVALUE('Table'[PageURL])="d832fef46a07c0149d1b","Page2"
      )

       

      Insert a button and create another measure, set the button Web URL:

      URL = "https://app.powerbi.com/groups/3baca28a-79b3-4ffe-bc6c-6fdeb943446f/reports/21dba6f4-a5da-4f10-a07a-130016c742a7/"&SELECTEDVALUE('Table'[PageURL])&"?experience=power-bi"

      When we need to change the page, we only need to modify the slicer and click the button to jump to a new page

       

      I will attach the PBIX file for your reference. Licenses and permissions are also required to open a report using a URL, which may require you to log in to your account again or gain access to view the report.

       

       

      How to Get Your Question Answered Quickly

      Best Regards

      Yongkang Hua

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Hi Max,

         I think it does not support by PBIRS because the documents are about embedding to iframe and filter things.

    According to my post here, i think MS should build a document to describe the available parameters when embed PBI to iframe, escpecially for RS.