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?
t
Ankur04's avatar
Ankur04
Icon for Resolver II rankResolver II
2 years ago

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
2 years ago

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.