Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

0

Displaying a specific report page with Power BI Publish to web

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

Status: Delivered
Comments
v-yuezhe-msft
Employee

@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.
1.PNG

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Delivered
 
VidaLi
Frequent Visitor

@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
Employee

@VidaLi,

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

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

Regards,
Lydia


VidaLi
Frequent Visitor

@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
Employee

@VidaLi,

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

Regards,
Lydia

VidaLi
Frequent Visitor

@v-yuezhe-msftThank you Lydia,

 

That is what we currently do.

 

Thanks,

Vida

FXFelix
Helper II

Hi @v-yuezhe-msft

 

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

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
Helper I

Adding &pageName=ReportSection logic doesn't work? 

FXFelix
Helper II

But where can I find the ReportSection for each page ?

 

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

 

Thanks for replying !