Displaying a specific report page with Power BI Publish to web

[VidaLi]

Hi all,

we are having issues to display a specific sheet of PBIX file which have more than 1 sheet in the PBIX file. Normally, it's published to the web, the iframe normally lands to the 1st page of PBIX file. 

how can we update the iframe so that we can display 2nd or 3rd or 4th etc of the PBIX file as the landing page?

the below link DIDN'T work

https://app.powerbi.com/view?r=eyJrIjoiYjVhZWNiNGItNWM0Ni00MmJiLWExZGItMjNjZDA2ZTA2NzQ2IiwidCI6IjZjZ...

In total, we have 4 sheets in this PBIX, by changing the last number to either 2 or 3 it doens't reference to the relevant sheet..

I found this link https://blogs.msdn.microsoft.com/charles_sterling/2017/01/10/displaying-a-specific-report-page-with-... on web, however the solution it's suggested only worked for certain pages of the same PBIX.

But this didn't work...

by the way, we display the link through IFRAME..

Thanks,

Vida

[v-yuezhe-msft]

@VidaLi,

In your scenario, to make the 2nd page as landing page, the URL is https://app.powerbi.com/view?r=eyJrIjoiYjVhZWNiNGItNWM0Ni00MmJiLWExZGItMjNjZDA2ZTA2NzQ2IiwidCI6IjZjZ...&pageName=ReportSection

To make the 3rd page as landing page, the URL is https://app.powerbi.com/view?r=eyJrIjoiYjVhZWNiNGItNWM0Ni00MmJiLWExZGItMjNjZDA2ZTA2NzQ2IiwidCI6IjZjZ...&pageName=ReportSection2

To make the 4th page as landing page, the URL is https://app.powerbi.com/view?r=eyJrIjoiYjVhZWNiNGItNWM0Ni00MmJiLWExZGItMjNjZDA2ZTA2NzQ2IiwidCI6IjZjZ...&pageName=ReportSection3

You should check the share URL of each report page as the report section number in the publish to web URL is not same as the report page number.


Regards,
Lydia

[VidaLi]

@v-yuezhe-msft

Thank you Lydia.

problem solved.

we have some more questions:

1. is it possible to hide the rest of the pages. for example in out above example, we have 4 sheets in the same PBIX file, we want to display the 2nd page using your suggested method, however, we don't want the audience to see the rest of the pages, in order words we want to hide them. currently they can click on the bottom arrow bar to change to different page, we want to suspend this function. is it possible?

2. is it possible to remove the Micorsoft Power BI bar at the bottom of each visual completely?

thanks,

Vida

[v-yuezhe-msft]

@VidaLi,

1. You can hide page in Power BI Report and then publish to web.


2. Using publish to web, it is not possible to remove the logo bar. You can use Power BI embed instead.

Regards,
Lydia

[VidaLi]

@v-yuezhe-msftHi Lydia,

In a real life example, we have 4 pages in one PBIX, we will use your first suggestion to display at different landing page of the cube. so we will have 4 iframe links included in the same HTML page to display the four.

if we hide the pages like you suggested, that means we need to save four copies with 4 different names, hide the relevant pages, and push them to powerBI online, which will have 4 copies with different names on line.......

so maybe thats the only way.....

please confirm.

Thanks,
Vida

[v-yuezhe-msft]

@VidaLi,

Other method is to seperate these report pages in different reports.

Regards,
Lydia

[VidaLi]

@v-yuezhe-msftThank you Lydia,

That is what we currently do.

Thanks,

Vida

[FXFelix]

Hi @v-yuezhe-msft

I have the same problem as VidaLi, but I don't understand your explanation

If I have 2 pages on my report, and I want to land on the second one, I juste have to add &pageName=ReportSection to the embedded link ?

[Gwhiz]

Adding &pageName=ReportSection logic doesn't work? 

[FXFelix]

But where can I find the ReportSection for each page ?

=> Reading my sentence again, I find after all the ReportSection in the link

Thanks for replying !