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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

400 reports and 300 bookmarks - consolidation help

Hi

working on pbix that has 300 reports and 400 bookmarks 

too many visuals and charts/filters etc. 

 

im finding it  very time consuming  to update bookmarks.  some time have to make simple change to all  reports and takes forever.

 

is there way to reduce number of bookmarks/reports so there are fewer places to update?

is there way to apply changes to all reports and maintain consistency without having to change every single page/visual ? 

 

thanks in advance 

 

 

 

 

 

5 REPLIES 5
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

AFAIK, current power bi not contains functions to bulk update bookmark/report pages.

How did you report designs? AFAIK, general reports not required to create such more report pages. Have you created/duplicate multiple versions of the report page/bookmarks with different scenarios or users?

If this is a case, I think you need to find out the category or common part of your report contents first. Then you can consider using RLS with username to show specific content based on the current user or try to use query parameters to create a template report that can be used to generate multiple reports with different situations.

RLS with UserName() 

Deep Dive into Query Parameters and Power BI Templates 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

reports are for public / internet users and there are similarities and common parts. i sent you message with report 

Hi @Anonymous,

Thanks for your message report, but currently our team only works on forums and not provide other channels of support. If you are work with sensitive data or urgent/serious scenarios, you can consider choosing other high-level channels. (e.g. phone, email, or FTE support)

Since these reports are designed based on the same database, you can parameterize the underlying connection to choose afferent parts of tables.  After these steps, you can arrange similar charts or analyses to one report, this should be one feature of your facility. 

If you are fairly new to power bi and did not know how to design them, you can check the template connector pack/app or find out similar service from MS partner and find out existing solutions.

Connect to the services you use with Power BI 

Data Stories Gallery 

Contact a Power BI Partner 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@Anonymous , I think that need to design reconsideration. Like can you use drill through in place of bookmark at few place. Consolidate and remove few bookmarks. But this all can only done with complete knowledge of datamodel and requirement,  Can you ask specific questions. Can you share a sample pbix after removing sensitive data.

Anonymous
Not applicable

i sent you private message 

thanks 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.