Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
What is the best industry practice when you have live report published in service to put it in maintence mode. Is there something I can do with DAX to modify or create a flag that instead of report would show a banner "report under mainenance" based on that flag. I am refering to same pbif file that I can work on anf fix the issue locally while that same report is published but it is showing a banner,
Hello @stribor45,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Hi @stribor45,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @KarinSzilagyi & @danextian for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hi @stribor45, as @danextian already mentioned, you shouldn't be doing "open heart surgery" on your published reports.
The typical professional report life-cycle uses 2-3 separate workspaces, depending on the size of your team:
1) One for development (usually named something like "YourWorkspaceName_Dev") => This is the one where anyone that actually develops their reports would apply any changes within the Power BI / Fabric Workspace.
2) One for test (usually named something like "YourWorkspaceName_Test") => This is where your report is deployed for your Testers (e.g. selected coworkers from the target department that will use the report later) and where any testing happens - as the name suggests. Only when the testers agree that everything works and looks right you would deploy the report to your production Workspace, where the final users will be given access to the report. In smaller companies/teams the Dev + Test workspace are sometimes merged into a single Workspace for development or testing. Separating it into two Workspaces has the advantage that it's easier to keep track of which versions the testers are looking at vs what you might still be working on in parallel (e.g. if they are testing Page1 and you're still working on Page2 )
3) One production workspace (usually named something like "YourWorkspaceName" or "YourWorkspaceNameProd"), which is where your end-users access the report. Since they only see the report there (or via a PowerBi App published from there) you can work on your report in Dev/Test without impacting the productive version.
Depending on the size of your organization, there are different ways on how you can move your Reports-Versions between the different Workspace-Layers.
The probably most common version for smaller teams is that the report developers work on a local version of the report (e.g. stored in a OneDrive or Sharepoint Folder) via Power BI Desktop and then just publish it to the target Workspaces. E.g. Dev just to test themselves how the report looks in the Browser, then to Test for the testers, then to Prod once the Testers agree that everything looks and works as intented.
The "cleanest" solution is to use Deployment Pipelines in the Power Bi Service/Fabric to automatically push the reports from Dev > Test > Prod with an approval Workflow, which requires a Power Bi Premium Capacity, Premium per User Workspace or Fabric Workspace.
https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipel...
If this post helped resolve your issue, please mark it as the solution to make it easier for future readers to find.
Hi @stribor45
We don't really touch the live report but test a different copy before overwriting what's in prod. If you really want to tell user that the report is under maintenance, you can use a textbox overlaying the main page, stating that is under maintenance and remove or hide that textbox once maintance is over. There is no automatic way to do this.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.