Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

jenbeiser
Microsoft Employee
‎03-13-2025 09:00 AM

Streamlining Admin Settings Monitoring

Managing tenant settings in a Fabric environment can be a complex task, especially when it comes to tracking changes and updates. To simplify this process, I’ve outlined two options to ensure you stay up to date on new and upcoming Fabric settings.

 

Option 1: M365 Admin Portal Message Center Alerts

New tenant settings, especially the ones that are default on, are going to show up in advance of the feature rollout in the M365 Admin portal in the Message Center. If you sync Message Center to Planner, and choose Power BI as the service to sync, when new messages come in, a new task will be created in Planner. You could create a PBI report on top of the Planner data, or use the Planner App in Teams, to get notified of new settings.

 

Use this solution if you only want to know what the new settings are in the admin center and are not interested in additionaly tracking changes to existing settings.

 

Here's how you can set it up:

  1. Go to the Admin Center: Navigate to the Microsoft 365 admin center.

  2. Access Message Center: Go to Show all > Health > Message center.

  3. Enable Planner Syncing: Right above your messages list, select Planner syncing.

  4. Set Up Syncing: In the Planner syncing pane, select Set up syncing

  5. Include Power BI: Select "Power BI" as the service to include messages about

Once you enable syncing, Message Center posts will sync to one plan in Planner, and into one bucket of that plan. You could then create a PBI report on top of the Planner data, or use the Planner App in Teams, to get notified of new admin settings. This setup is a simple yet effective way to stay on top of tenant settings changes in your lakehouse environment. By automating the process and leveraging alerts, you can ensure that your team is always informed and ready to act. 

 

Option 2: Delta tables in Fabric OneLake

A Fabric notebook is designed to extract tenant settings and save them into a Delta table. One of the key columns in this table is lastModifiedDate, which records the date and time when a tenant setting was created or updated. This column is crucial for tracking changes over time.

 

Use this solution if you only want to not only know what the new settings are in the admin center, but also keep history and track settings to existing settings. 

 

Here's how you can set it up:

  1. Daily Execution: The notebook can be scheduled to run daily, ensuring that the Delta table is always up to date with the latest tenant settings.

  2. Change Tracking: By leveraging the lastModifiedDate column, you can easily filter the data to identify settings that were inserted or updated in the last 24 hours.

  3. Reporting: Build a report on top of this Delta table to visualize and analyze the changes.

 

Taking It a Step Further with Alerts

To make this setup even more powerful, you can:

  • Set Up Alerts: Configure an alert on the report visual to notify you whenever a tenant setting is changed or updated. This eliminates the need to check the report manually every day.
  • Stay Proactive: With alerts in place, you’ll always be informed of changes in real time, enabling you to respond quickly to any updates.

 

Why This Setup is Beneficial

  • Efficiency: Automating the notebook and report reduces manual effort and ensures data consistency.
  • Visibility: The report provides a clear view of recent changes, making it easier to monitor and manage tenant settings.
  • Proactive Monitoring: Alerts keep you informed without requiring constant oversight, saving time and effort.

 

Accessing the Notebook

You can find the notebook at the following link:
Useful-Fabric-Scripts/Administrative at main · iamjenetzler/Useful-Fabric-Scripts > Save Tenant Settings.ipynb

 

Feel free to explore the notebook and adapt it to your team’s specific needs. If you have any questions or suggestions, don’t hesitate to reach out—I’d love to hear your feedback!

Both setups are a simple yet effective way to stay on top of tenant settings changes. By automating the process and leveraging alerts, you can ensure that your team is always informed and ready to act.

0
Comments