PowerBi published in PowerBi report Server Direct link

[DaniEMIT]

Hi All,

i've a lot of PowerBi (.pbix) report published in our PowerBi Report Server (not powerbi.com).

Each report contains more than one sheet.

Is it possible to create a direct link that allow to open directly not the default page of the report?

I try using "pageName" or "ReportSection" but doesnt' work.

Below some example used (not working):

https://MyReportServer/reports/powerbi/MyReport?PageName=1

https://MyReportServer/reports/powerbi/MyReport?PageName=ReportSection1

https://MyReportServer/reports/powerbi/MyReport?ReportSection=1

Thanks in advance for you support,

Daniele

[Anonymous]

Hi,@DaniEMIT .Merry Christmas to you.

Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
For example, relevant code or links to articles.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[DaniEMIT]

Hi, merry Christmas to you.

No, i didn't get a solution of this issue at the moment.

Best Regards

[Anonymous]

Hello,Vanchy_Liao and Expiscornovus ,thanks for your concern about this issue.

Your answers are excellent!
And I would like to share some additional solutions below.
Hi,@DaniEMIT .I am glad to help you.

The report server API does not seem to support the ability to pass filter page parameters.
However you can try the following alternative.
1. Create a home page in the report, and then add buttons or shortcuts to link to other pages on this home page (by way of buttons, clicking on a button on the home page to jump to another page (Button binds to the report web URL of the other page))

2. Use bookmarks: Create bookmarks in the report and use them to navigate to different pages.
I hope that the following relevant issue will be of help to you.
URL:
Solved: Can I have the URL for a specific page for my repo... - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[DaniEMIT]

Hi Jian,

thanks for your reply. I'm sorry, but i can't use your suggestion. I need a direct URL for specific page in the powerbi report, because i have to share only specific page on a monitor. It can't work with button or bookmarks.

Anyway thanks for you reply,

Daniele

[Anonymous]

Hi,@DaniEMIT .Thank you for your reply.

The rest of my team and I came to the following conclusion after testing Url filter.
For PBIRS, the page switching of pbix reports in the web portal is completely based on front-end CSS code

You can see that the front-end page adds a selected attribute to <div> where Page2 is located, including its parent tag <li> is also added with selected attribute, and sets aria-selected = true
The TAB is currently selected
When I tried to change Page1's added selected state and changed aria-selected = false to true (page2 and page1 front-end CSS property Settings switched)
The report page automatically switches to page1

Unfortunately, there is no support for setting CSS properties to URLs, as you can observe, the URL of the report does not change when you switch report pages.
And regarding the SSRS URL filter feature, it supports paginated reports, not pbix reports.

For Power BI Service, the system supports users to filter reports and change the report display page by modifying the parameters of the URL, but for Power BI Report Server, there is no such API interface developed to realize similar effects for the time being.
You can consider modifying the CSS of the front-end page to try to achieve your goal.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

[DaniEMIT]

Hi,

Thanks for your reply.

All clear about first part of your answer.

About second part, i found the way to apply the filter via url: After your URL, you have yo add (using fields in you example):

?filter=[Table/animal eq 'cat'

The filter will be appear in the filter pane on the right.

Best Regards 

[Anonymous]

Hi,@DaniEMIT .Thank you for your reply.
If you are targeting Power BI Service
then your requirement can be realized, but not in the report server.
By creating a button in the report with a web URL jump function, you can specify the page to be displayed when the report is opened while passing the field filtering criteria.

this is my test measure:

For the report URL in Power BI Service, it contains information such as gourpID, reportID, PageID, and filter fields.

PageJumpURL1 = 
"https://app.powerbi.com/groups/yourgroupID/reports/2825de85-adf5-4e84-bd8b-ea0514420a29/"&[PageURL1]&"?filter=datarefreshTest%2Fanimal%20eq%20%27"&[SelectAnimal]&"%27"


PageJumpURL2 = 
"https://app.powerbi.com/groups/yourgroupID/reports/2825de85-adf5-4e84-bd8b-ea0514420a29/"&[PageURL2]&"?filter=datarefreshTest%2Fanimal%20eq%20%27"&[SelectAnimal]&"%27"

My pageURL (the pageURL is fixed for each page of the report, you can get the pageURL for each page of the report by copying the URL in the service)

PageURL1 = "d1cba0b7d3c7ab466150"


PageURL2 = "eba9e747ea0da7e5db78"

You can see that each page of a report has a different pageID.

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

But the report server doesn't support it, as you can see no matter which page I click on, there is no modification of the page parameter (there is no page parameter in the URL), which is also mentioned in my previous reply

So your needs are perfectly realized in power BI Service, but not in Power BI Report Server (I recommend you to write scripts to directly modify the front-end page code, so as to change the number of report pages displayed by default when the report is opened).

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[Vanchy_Liao]

@DaniEMIT 

i have asked similar question before and it probably only support "rs:embed" and "filter" parameters.

there is no specific documnet to introduce all url parameters for pbi.
Re: Available query string when embedding Power BI... - Microsoft Fabric Community

there is a thread describing the all parameters for pbi, but they only works in PBI Service.

PBIRS is just inferior to PBI Service from both products and documents perspectives.

[Expiscornovus]

Hi @DaniEMIT,

Back in SSRS days you used to be able to use the Section parameter for that. Have you tried to append rc:Section=2 to the end of the url to go to page 2.

https://learn.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-ser...

[DaniEMIT]

Hi Expiscornovus,

i tried with the parameter "rc:Section=2" but it doesn't work.