Forum Discussion

Wanglf's avatar
Wanglf
New Member
2 years ago
Solved

Can I select several sheets from the report

Can I select several sheets from the report instead of loading all pages of the entire report into the app when creating an app
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,Wanglf .I am glad to help you.


    I rediscovered another alternative for you (using a navigation page + jump buttons + hiding the target page), which I think is better than the above two alternatives
    You can do this by adding a navigation page to the report (page4 in the image)

    Add a back button to other pages so that users can click back to the navigation page and hide the pages you don't want to show to users. You can also set up the RLS to ensure that users accessing the app only see the corresponding report page, realizing data protection.

    Create the app in workspace and turn on the option: Access to hidden content
    Ensure that audience users have access to hidden content

    Creating a Power BI Workspace APP

     

    Add audience users to the app and share Link to the audience users.

     


    Realize the end result:
    Your users will only see what they can see after the RLS restriction, and you can set up page hopping buttons that allow you to freely choose which pages are visible and can be accessed by the user via the buttons, improving the interactivity of the report.
    like this:

    Setting a jump button for the report to hide the target page is more convenient and easier than setting a dashboard as I provided before, and it makes the report more interactive, I hope my suggestion is helpful to you.

    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.