How to get a list of all current tenant settings in the admin portal

[Artefact]

Hi,

Is there a REST API for exporting all current tenant settings in the admin portal? Or some other method? 

And is there a way to import this export again, so all settings are restored in one go?

thanks, 

[Jugi]

Feel free to reuse 

https://github.com/jugi92/fabric_admin_settings_export/blob/main/Export_Tenant_Settings_to_Table.ipy...

keep_history = True

import requests

import pandas as pd

import datetime

token = mssparkutils.credentials.getToken('pbi')

headers = { 'Authorization': f'Bearer {token}', 'Content-type': 'application/json' }

url = f"https://api.fabric.microsoft.com/v1/admin/tenantsettings"

print(url)

response = requests.get(url, headers=headers)

df = pd.DataFrame(response.json()["tenantSettings"])

df["Export_Date"] = datetime.datetime.now()

display(df)

sdf = spark.createDataFrame(df)
write_mode="overwrite" 
if keep_history: 
    write_mode = "append" 
sdf.write.saveAsTable(name="Tenant_Settings", mode=write_mode)

[GilbertQ]

Hi @Artefact 

As far as I know currently there is no process to export or restore the settings via an API call.

The only thing I Could find is the current features available via the API: Available Features - REST API (Power BI Power BI REST APIs) | Microsoft Learn