Forum Discussion
Power BI Self service
- A user in our team has created additional report pages (sheets) directly in Power BI Service, extending a report originally published from Power BI Desktop (.pbix file).
- These user-added sheets are within the same report because they often need to reference and interact with existing pages and visuals created in the original .pbix file.
- When I publish an updated version of the .pbix file from Power BI Desktop (to update visuals, measures, or datasets), it overwrites the entire report, causing the loss of the user-created sheets.
- Users to continue creating their own report pages within the same report, ideally keeping cross-page referencing functional.
- Developers to safely publish updates to the report or dataset without overwriting user changes.
- Is there a supported method to preserve user-created sheets within a report while continuing to publish updates from Desktop?
- Are there any tools or features (e.g., deployment pipelines, dataflows, shared datasets) that might help balance the need for both centralized updates and flexible user edits?
- Is there a roadmap item or enhancement being considered to support this kind of collaborative reporting use case?
Hi devarasu07 For this separate the dataset from the report and publish only the dataset from Power BI Desktop. Users can create reports using shared datasets directly in the service, ensuring their changes remain intact. Deployment pipelines can help stage updates without disrupting collaborative workflows. Unfortunately, Power BI currently overwrites user-created pages when publishing reports, so monitor updates for any enhancements.
Hi devarasu07
The below is also another approach/practice to this requirement. Please see if this meets your requirement.
Leverage the combination Personalized visual and Personal Bookmark feature which can be saved by user and does not go overwritten with publishing of power bi files.
These are the steps:
1. In the PBI desktop, click on report setting and check Personalize Visuals. This will allow end user to change their visuals
2. After publishing to the service, on top right corner, End user has to click on Personlized visuals icon encircled in red below. This let users change the visual type and data.
3.Once you are done, end user has to save this as Personal Bookmark
In this way, we can provide a standard/generic page in the report along for end user. End user can leverage this page with their own data selection, filteration and visual change and save this as their personal bookmark. This will not get overwritten.
Few links
https://www.youtube.com/watch?v=20HwiEhIShc
If this post helps, please accept this as a solution. Appreciate your kudos.
Thanks,
Pallavi
Hi devarasu07 ,
Thanks for posting in Microsoft Fabric Community.
The publish action from Power BI Desktop replaces the entire report in the Service, including any pages added directly there.
To work around this, there are two supported approaches as mentioned by Akash_Varuna and pallavi_r
1. You can separate the dataset from the report by publishing only the dataset to a workspace and letting users build their own reports connected to it. These thin reports are not affected when the dataset is updated.
For more details please refer to this link: Solved: Re: Is it really not possible to publish report ch... - Microsoft Fabric Community
2. If users only need to customize visuals on an existing page, enabling Personalize Visuals along with Personal Bookmarks allows them to make changes and save their views. These are retained after report updates and are specific to each user.
For details: Let users personalize visuals in a report - Power BI | Microsoft Learn
Deployment pipelines and dataflows help with managing updates and reusability, but they do not preserve report changes made directly in the Service when a new version is published from Desktop.
There is currently no roadmap item announced to support preserving user-created pages within a single report when updates are published from Desktop. You may monitor the Microsoft Fabric roadmap for any future updates related to this capability.
Hope this helps. Please reach out for further assistance.
Please consider marking the helpful reply as Accepted Solution to assist others with similar issues.
Also thanks to Akash_Varuna and pallavi_r for your prompt responses and valuable contribution to the community.
Thank you.
6 Replies
- Akash_VarunaSuper User
Hi devarasu07 For this separate the dataset from the report and publish only the dataset from Power BI Desktop. Users can create reports using shared datasets directly in the service, ensuring their changes remain intact. Deployment pipelines can help stage updates without disrupting collaborative workflows. Unfortunately, Power BI currently overwrites user-created pages when publishing reports, so monitor updates for any enhancements.
- pallavi_rSuper User
Hi devarasu07
The below is also another approach/practice to this requirement. Please see if this meets your requirement.
Leverage the combination Personalized visual and Personal Bookmark feature which can be saved by user and does not go overwritten with publishing of power bi files.
These are the steps:
1. In the PBI desktop, click on report setting and check Personalize Visuals. This will allow end user to change their visuals
2. After publishing to the service, on top right corner, End user has to click on Personlized visuals icon encircled in red below. This let users change the visual type and data.
3.Once you are done, end user has to save this as Personal Bookmark
In this way, we can provide a standard/generic page in the report along for end user. End user can leverage this page with their own data selection, filteration and visual change and save this as their personal bookmark. This will not get overwritten.
Few links
https://www.youtube.com/watch?v=20HwiEhIShc
If this post helps, please accept this as a solution. Appreciate your kudos.
Thanks,
Pallavi
- v-veshwara-msftCommunity Support
Hi devarasu07 ,
Thanks for posting in Microsoft Fabric Community.
The publish action from Power BI Desktop replaces the entire report in the Service, including any pages added directly there.
To work around this, there are two supported approaches as mentioned by Akash_Varuna and pallavi_r
1. You can separate the dataset from the report by publishing only the dataset to a workspace and letting users build their own reports connected to it. These thin reports are not affected when the dataset is updated.
For more details please refer to this link: Solved: Re: Is it really not possible to publish report ch... - Microsoft Fabric Community
2. If users only need to customize visuals on an existing page, enabling Personalize Visuals along with Personal Bookmarks allows them to make changes and save their views. These are retained after report updates and are specific to each user.
For details: Let users personalize visuals in a report - Power BI | Microsoft Learn
Deployment pipelines and dataflows help with managing updates and reusability, but they do not preserve report changes made directly in the Service when a new version is published from Desktop.
There is currently no roadmap item announced to support preserving user-created pages within a single report when updates are published from Desktop. You may monitor the Microsoft Fabric roadmap for any future updates related to this capability.
Hope this helps. Please reach out for further assistance.
Please consider marking the helpful reply as Accepted Solution to assist others with similar issues.
Also thanks to Akash_Varuna and pallavi_r for your prompt responses and valuable contribution to the community.
Thank you.
- v-veshwara-msftCommunity Support
Hi devarasu07 ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.
- v-veshwara-msftCommunity Support
Hi devarasu07 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you. - v-veshwara-msftCommunity Support
Hi devarasu07 ,
Following up to see if your query is resolved and if any of the responses helped.
If you still need assistance, feel free to reach out.Thank you.