microsoft/semantic-link-labs

📦 Updated Functions

• sempy_labs
• [generate_direct_lake_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.generate_direct_lake_semantic_model) Added the 'include_descriptions' optional parameter which sets the table/column descriptions in the semantic model according to the table/column descriptions in the lakehouse (if specified).
• [list_data_access_roles](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_data_access_roles) The 'Rules' parameter is now 'Roles'. There is a new parameter 'Security' which shows the row level security and column level security for the relevant tables.
• [evaluate_dax_impersonation](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.evaluate_dax_impersonation) Now points to the evaluate_dax function in sempy.fabric as this contains a parameter for user impersonation (#1225).
• sempy_labs.admin
• [list_apps](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_apps) Now includes the Workspace Id and Users columns in the output (#1221)
• sempy_labs.lakehouse
• [run_table_maintenance](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.run_table_maintenance) Now includes optional parameters 'z_order' and 'purge_deletion_vectors'.
• + 12 more

🐛 Bug Fixes

• #1238
• Fixed issue with functions having circular dependencies.

✨ New Functions

• sempy_labs
• [ConnectMirroredAzureDatabricksCatalog](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.ConnectMirroredAzureDatabricksCatalog) Write SQL or T-SQL statements against a Mirrored Azure Databricks Catalog.
• sempy_labs.lakehouse
• [create_schema](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.create_schema) Creates a schema within a schema-enabled lakehouse (thanks @pawarbi!).
• [create_materialized_lake_view](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.create_materialized_lake_view) Creates a materialized lake view in a Fabric lakehouse. Only supported in schema-enabled lakehouses.
• sempy_labs.mirrored_azure_databricks_catalog
• [list_mirrored_azure_databricks_catalogs](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.mirrored_azure_databricks_catalog.html#sempy_labs.mirrored_azure_databricks_catalog.list_mirrored_azure_databricks_catalogs)
• [delete_mirrored_azure_databricks_catalog](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.mirrored_azure_databricks_catalog.html#sempy_labs.mirrored_azure_databricks_catalog.delete_mirrored_azure_databricks_catalog)
• + 17 more

📦 Updated Functions

• sempy_labs
• [list_data_access_roles](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_data_access_roles) Now supports 3 views using the 'view' parameter (Rules, MicrosoftEntraMembers, FabricItemMembers).
• [create_blank_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.create_blank_semantic_model) Now returns the ID of the created semantic model.
• [deploy_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.deploy_semantic_model) added the 'filters' parameter which allows deploying a [mini model](https://www.elegantbi.com/post/mastermodel) based on the objects in a perspective as well as filters applied to the underlying tables. This is only supported for single-lakehouse-sourced Direct Lake semantic models.
• [generate_direct_lake_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.generate_direct_lake_semantic_model) Generates a Direct Lake semantic model based on any viable source (Lakehouse, Warehouse, SQL Database, Mirrored Azure Databricks Catalog, or Mirrored Database).
• sempy_labs.admin
• [list_tenant_settings](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_tenant_settings) Additional columns added (#1177).
• sempy_labs.sql_database
• + 3 more

🐛 Bug Fixes

• #1163
• #1168
• #1180
• #1220
• Fixed bug in [remove_vertipaq_annotations](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.remove_vertipaq_annotations)
• <img width="1426" height="760" alt="image" src="https://github.com/user-attachments/assets/e3ba31fe-93c8-4160-b6aa-91e117a7a9d3" />

✨ New Functions

• sempy_labs
• [Item recovery](https://learn.microsoft.com/fabric/admin/item-recovery)
• [list_recoverable_items](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_recoverable_items)
• [recover_item](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.recover_item)
• [permanently_delete_item](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.permanently_delete_item)
• [Bulk Export/Import](https://blog.fabric.microsoft.com/blog/public-apis-bulk-import-and-export-items-definition-preview)
• [bulk_export_items](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.bulk_export_items)
• [bulk_import_items](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.bulk_import_items)
• + 2 more

📦 Updated Functions

• sempy_labs
• [vertipaq_analyzer](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.vertipaq_analyzer) This function has a brand new UI! Plus, new optional parameters (export_lakehouse, export_workspace, export_schema) allow you to export this data as tables to the destination of your choice. This function now displays additional content for Direct Lake semantic models (the Direct Lake Type (OneLake or SQL), Source Name, Source Type, Source Workspace, Source Table Name). The function also shows 'Levels' in the Hierarchy shows the number of levels within the hierarchy. Lastly, the read_stats_from_data will calculate column cardinality for both Import and Direct Lake models (as long as the Direct Lake source is a lakehouse or warehouse). Missing Rows is calculated only for Import models. (#1008, #103).
• <img width="998" height="238" alt="image" src="https://github.com/user-attachments/assets/b3867377-2d91-473b-9995-cc9d52aeba74" />
• <img width="982" height="190" alt="image" src="https://github.com/user-attachments/assets/1a26267f-5228-4807-a31c-f8a0382fb7eb" />

🐛 Bug Fixes

• #1117
• #1140
• #1163
• #1166 thanks @hurtn!

📦 Updates

• Updated sempy_labs to be compatible with Python 3.12 as this is now the default in Fabric notebooks.

🐛 Bug Fixes

• #1117

📦 Updated Functions

• sempy_labs
• [delta_analyzer](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.delta_analyzer) Added a parameter 'visualize' which defaults to True. When 'visualize' is set to True, the function displays the results in an interactive HTML-designed UI. Note that the function still returns the results as a dictionary of dataframes.
• <img width="909" height="484" alt="image" src="https://github.com/user-attachments/assets/079148e2-4e48-4d7b-a510-f51f90b731de" />

✨ New Functions

• sempy_labs.admin
• [delete_all_capacity_tenant_setting_overrides](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.delete_all_capacity_tenant_setting_overrides) thanks @tarente!
• sempy_labs.key_vault 🚀 New!
• [get_secret](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.key_vault.html#sempy_labs.key_vault.get_secret)
• [set_secret](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.key_vault.html#sempy_labs.key_vault.set_secret)
• [delete_secret](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.key_vault.html#sempy_labs.key_vault.delete_secret)
• [list_secrets](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.key_vault.html#sempy_labs.key_vault.list_secrets)
• [recover_deleted_secret](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.key_vault.html#sempy_labs.key_vault.recover_deleted_secret)
• + 10 more

📦 Updated Functions

• sempy_labs.directlake
• [update_direct_lake_model_connection](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.update_direct_lake_model_connection) Fixed an issue where relationships/measures disappeared when converting from DL on OneLake to DL on SQL.

🐛 Bug Fixes

• #406
• #1099
• #1106

📦 Updated Functions

• sempy_labs.sql_endpoint
• [refresh_sql_endpoint_metadata](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.sql_endpoint.html#sempy_labs.sql_endpoint.refresh_sql_endpoint_metadata ) Added the optional 'recreate_tables' parameter.
• sempy_labs
• All functions which leverage APIs which can be accessed via Service Principal authentication are now enabled. Previously it was limited to those functions which had the client ‘fabric_sp’ in the _base_api function but that is no longer the case.

🐛 Bug Fixes

• #406
• #886
• #1076
• #1078
• #1082 (thanks @jdocampo!)
• #1093

✨ New Functions

• sempy_labs.event_schema_set 🚀 New!
• [list_event_schema_sets](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.event_schema_set.html#sempy_labs.event_schema_set.list_event_schema_sets)
• [delete_event_schema_set](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.event_schema_set.html#sempy_labs.event_schema_set.delete_event_schema_set)
• sempy_labs.operations_agent 🚀 New!
• [list_operations_agents](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.operations_agent.html#sempy_labs.operations_agent.list_operations_agents)
• [delete_operations_agent](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.operations_agent.html#sempy_labs.operations_agent.delete_operations_agent)
• sempy_labs.rti 🚀 New package for Real Time Intelligence functions!
• [nl_to_kql](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.rti.html#sempy_labs.rti.nl_to_kql)
• + 9 more

📦 Updated Functions

• sempy_labs.directlake
• [generate_direct_lake_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.generate_direct_lake_semantic_model) Now supports schema-enabled lakehouses.
• sempy_labs.lakehouse
• [get_lakehouse_columns](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.get_lakehouse_columns) Added the 'Schema Name' column to the resulting dataframe.

🐛 Bug Fixes

• #1014

✨ New Functions

• [sempy_labs.daxlib](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#daxliborg-integration) 🚀 New! Semantic Link Labs now offers a seamless integration with [DAXLib.org](https://daxlib.org/) which allows you to easily view [user-defined function](https://learn.microsoft.com/dax/best-practices/dax-user-defined-functions) packages from [DAXLib.org](https://daxlib.org/) as well as add/remove/update these packages in your semantic model. Kudos @edwardpcharles for the inspiration and [SQLBI](https://www.sqlbi.com/) for their support of [DAXLib.org](https://daxlib.org/).
• [get_package_tmdl](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.daxlib.html#sempy_labs.daxlib.get_package_tmdl)
• [get_package_functions](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.daxlib.html#sempy_labs.daxlib.get_package_functions)
• [add_package_to_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.daxlib.html#sempy_labs.daxlib.add_package_to_semantic_model)
• [remove_package_from_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.daxlib.html#sempy_labs.daxlib.remove_package_from_semantic_model)
• [update_package_in_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.daxlib.html#sempy_labs.daxlib.update_package_in_semantic_model)
• sempy_labs.directlake
• [get_direct_lake_sources](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.get_direct_lake_sources) This function replaces the 'get_direct_lake_source' function and is able to retrieve all Direct Lake sources (#660).
• + 7 more

📦 Updated Functions

• sempy_labs
• [model_bpa_rules](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.model_bpa_rules) Updated the rule for ensuring measures are formatted. This rule now accounts for format string expressions.
• [get_item_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_item_definition) now supports the EventSchemaSet item.
• sempy_labs.admin
• [assign_domain_workspaces](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.assign_domain_workspaces) Now accepts either the workspace name or ID. Note that the parameter name has changed from 'workspace_names' to 'workspace' (#1040).
• sempy_labs.lakehouse
• [optimize_lakehouse_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.optimize_lakehouse_tables) Now supports schema-enabled lakehouses. Simply use the 'schema.table' format in the 'tables' parameter.
• [vacuum_lakehouse_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.vacuum_lakehouse_tables) Now supports schema-enabled lakehouses. Simply use the 'schema.table' format in the 'tables' parameter.
• + 4 more

✨ Functions moved to a new package

• [sempy_labs.connection](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.connection.html) 🚀 New!
• Connection functions have been moved to this new package.
• [sempy_labs.data_pipeline](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.data_pipeline.html) 🚀 New!
• Data Pipeline functions have been moved to this new package.
• [sempy_labs.external_data_share](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.external_data_share.html) 🚀 New!
• External Data Share functions have been moved to this new package.
• [sempy_labs.gateway](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.gateway.html) 🚀 New!
• Gateway functions have been moved to this new package.
• + 24 more

🐛 Bug Fixes

• #660
• #690
• #1006
• #1020
• #1021
• #1040
• #1064

✨ New Functions

• sempy_labs
• [list_favorites](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_favorites) Lists all items you have marked as a favorite.
• [list_endorsements](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_endorsements) Lists all items which have been endorsed.
• [takeover_item_ownership](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.takeover_item_ownership) Allows you to take over ownership of a report or semantic model.
• sempy_labs.variable_library
• [update_variable](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.variable_library.html#sempy_labs.variable_library.update_variable) Update the properties of a variable (within a variable library).
• [update_variable_library](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.variable_library.html#sempy_labs.variable_library.update_variable_library) Update the properties of a variable library.
• sempy_labs.dataflow 🚀 New!
• + 8 more

📦 Updated Functions

• sempy_labs.report
• [set_endorsement](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.set_endorsement) added new endorsement settings ('Certified', 'Master data'). (#1024)

🐛 Bug Fixes

• #949
• #1023
• #1026
• #1034

✨ New Functions

• sempy_labs
• [modify_immutability_policy](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.modify_immutability_policy)
• sempy_labs.admin
• [sync_role_assignments_to_subdomains](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.sync_role_assignments_to_subdomains)
• sempy_labs.apache_airflow_job 🚀 New!
• [list_apache_airflow_jobs](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.apache_airflow_job.html#sempy_labs.apache_airflow_job.list_apache_airflow_jobs)
• [delete_apache_airflow_job](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.apache_airflow_job.html#sempy_labs.apache_airflow_job.delete_apache_airflow_job)
• [list_apache_airflow_job_files](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.apache_airflow_job.html#sempy_labs.apache_airflow_job.list_apache_airflow_job_files)
• + 27 more

📦 Updated Functions

• sempy_labs
• [get_tables_mirroring_status](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_tables_mirroring_status) Added the 'Last Sync Latency In Seconds' column (#1005).
• [get_item_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_item_definition) Now supports the 'Ontology' and 'Lakehouse' items.
• sempy_labs.lakehouse
• [create_shortcut_onelake](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.create_shortcut_onelake) Now supports additional source items (previously only supported lakehouses). Note that the parameter has changed from 'source_lakehouse' to 'source_item' and a new parameter has been added 'source_item_type'. (#501).

🐛 Bug Fixes

• #960

✨ New Functions

• sempy_labs
• [cancel_item_job_instance](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.cancel_item_job_instance) (#950)
• sempy_labs.lakehouse
• [is_schema_enabled](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.is_schema_enabled) identifies whether a lakehouse is schema-enabled.
• sempy_labs.snowflake_database
• [list_snowflake_databases](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.snowflake_database.html#sempy_labs.snowflake_database.list_snowflake_databases)
• [delete_snowflake_database](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.snowflake_database.html#sempy_labs.snowflake_database.delete_snowflake_database)

📦 Updated Functions

• sempy_labs
• [get_item_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_item_definition) now supports Snowflake Databases, Cosmos DB Databases, and Operations Agents.

🐛 Bug Fixes

• #836
• #949
• #970
• #971
• #973
• #975
• #976
• #982

✨ New Functions

• sempy_labs
• [list_domains](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_domains) This is the non-admin version. The admin version of this function already exists in the admin package.
• [get_workspace_git_outbound_policy](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_workspace_git_outbound_policy)
• [set_workspace_git_outbound_policy](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.set_workspace_git_outbound_policy)
• sempy_labs.deployment_pipeline
• [deploy_stage_content](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.deployment_pipeline.html#sempy_labs.deployment_pipeline.deploy_stage_content) (#960)
• sempy_labs.directlake
• [set_autosync](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.set_auto_sync) Sets whether a Direct Lake semantic model detects data changes in OneLake and automatically updates the Direct Lake tables that are included in the semantic model.
• + 17 more

📦 Updated Functions

• sempy_labs
• [list_lakehouses](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_lakehouses) Added new columns: Schema Enabled, Default Schema, Sensitivity Label Id
• sempy_labs.report.ReportWrapper
• [list_bookmarks](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.ReportWrapper.list_bookmarks) Added new columns: Current Page Selected, Apply Visual Display State, Apply To All Visuals (#944).
• sempy_labs.sql_database
• [list_sql_databases](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.sql_database.html#sempy_labs.sql_database.list_sql_databases), [create_sql_database](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.sql_database.html#sempy_labs.sql_database.create_sql_database), [delete_sql_database](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.sql_database.html#sempy_labs.sql_database.delete_sql_database), [get_sql_database_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.sql_database.html#sempy_labs.sql_database.get_sql_database_tables), [get_sql_database_columns](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.sql_database.html#sempy_labs.sql_database.get_sql_database_columns) have been moved from sempy_labs to sempy_labs.sql_database.
• sempy_labs.lakehouse
• [list_lakehouses](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.list_lakehouses) is now in this package (it will remain in the sempy_labs package for a temporary period). Added new columns: Schema Enabled, Default Schema, Sensitivity Label Id
• + 3 more

🐛 Bug Fixes

• #938
• #940

🐛 Bug Fixes

• #934

✨ New Functions

• sempy_labs
• OneLake Settings
• [get_onelake_settings](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_onelake_settings)
• [modify_onelake_diagnostics](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.modify_onelake_diagnostics)
• Dataflows
• [discover_dataflow_parameters](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.discover_dataflow_parameters)
• Managed Private Endpoints
• [list_managed_private_endpoint_fqdns](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_managed_private_endpoint_fqdns)
• + 10 more

📦 Updated Functions

• sempy_labs.directlake
• Added the 'columns' parameter to the [add_table_to_direct_lake_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.add_table_to_direct_lake_semantic_model) (#814)
• sempy_labs.graph
• Added output column 'Department' and added optional parameter 'show_manager' to [list_users](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.graph.html#sempy_labs.graph.list_users) and [get_user](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.graph.html#sempy_labs.graph.get_user) (#925).

🐛 Bug Fixes

• #883
• #884
• #895
• #905
• #906
• #910
• #911
• #913

✨ New Functions

• sempy_labs
• [get_sql_audit_settings](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_sql_audit_settings)
• [update_sql_audit_settings](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.update_sql_audit_settings)
• [set_audit_actions_and_group](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.set_audit_actions_and_group)
• [list_user_defined_functions](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_user_defined_functions) Lists the user-defined functions within a semantic model.
• sempy_labs.admin
• [bulk_set_labels](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.bulk_set_labels)
• [bulk_remove_labels](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.bulk_remove_labels)
• + 24 more

📦 Updated Functions

• sempy_labs
• [list_semantic_model_errors](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_semantic_model_errors) Now shows errors from user-defined functions.
• sempy_labs.tom
• [remove_object](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.remove_object) Now supports removing user-defined functions.

🐛 Bug Fixes

• #870
• #877
• #881
• #882
• #885
• #888
• #889 (thanks @vytautas9!)
• #896 (thanks @richbenmintz!)
• + 1 more

✨ New Functions

• sempy_labs
• [get_connection_string](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_connection_string) This function replaces the 'get_warehouse_connection_string' and serves as generic function which supports Lakehouses, Warehouses, & SQL Endpoints.
• [bind_semantic_model_connection](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.bind_semantic_model_connection)
• [unbind_semantic_model_connection](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.unbind_semantic_model_connection)
• sempy_labs.graph
• [list_sensitivity_labels](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.graph.html#sempy_labs.graph.list_sensitivity_labels)

📦 Updated Functions

• sempy_labs
• [refresh_sql_endpoint_metadata](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.refresh_sql_endpoint_metadata) (#870) Removed the 'tables' parameter as it is no longer supported by the API. Added the 'timeout_unit' and 'timeout_value' parameters as they are now supported by the API.
• sempy_labs.tom
• [convert_direct_lake_to_import](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.convert_direct_lake_to_import) (#871)

🐛 Bug Fixes

• #383

✨ New Functions

• sempy_labs
• [get_warehouse_connection_string](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_warehouse_connection_string)
• [list_data_access_roles](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_data_access_roles)
• sempy_labs.admin
• [remove_all_sharing_links](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.remove_all_sharing_links)
• [remove_sharing_links](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.remove_sharing_links)
• sempy_labs.graph
• [create_user](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.graph.html#sempy_labs.graph.create_user)
• + 7 more

🐛 Bug Fixes

• #383
• #800
• #839
• #843
• #855
• #859
• #861

🐛 Bug Fixes

• #841
• Fixed typo in [sempy_labs.report.report_rebind_all](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.report_rebind_all)

✨ New Functions

• sempy_labs
• [get_item_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_item_definition)
• [get_workspace_network_communication_policy](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_workspace_network_communication_policy)
• [set_workspace_network_communication_policy](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.set_workspace_network_communication_policy)
• sempy_labs.admin
• [list_tenant_keys](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_tenant_keys)
• [rotate_tenant_key](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.rotate_tenant_key)
• sempy_labs.lakehouse
• + 1 more

📦 Updated Functions

• sempy_labs
• [copy_item](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.copy_item) Added the optional 'keep_existing_bindings' parameter which allows reports to be kept bound to their original semantic model (if the target item already exists).
• [list_item_connections](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_item_connections) Parameters have changed to 'item' and 'type' (item_name & item_type still work but please use item & type). The 'item' parameter now supports either name or ID.
• sempy_labs.tom
• [convert_direct_lake_to_import](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.convert_direct_lake_to_import) Updated the syntax of the newly created import partition.
• sempy_labs.admin
• [list_capacities](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_capacities) Added the 'include_tenant_key' parameter.

🐛 Bug Fixes

• #485
• #769
• #797 (also added the 'data_source_object_ids' parameter to this function).
• #800
• #808
• #811
• #815
• #821
• + 3 more

✨ New Functions

• sempy_labs
• [delete_external_data_share](https://semantic-link-labs.readthedocs.io/en/latest/sempy_labs.html#sempy_labs.delete_external_data_share) Deletes an external data share item.
• [list_item_labels](https://semantic-link-labs.readthedocs.io/en/latest/sempy_labs.html#sempy_labs.list_item_labels) Shows all items within a workspace and their sensitivity label.
• [list_notebooks](https://semantic-link-labs.readthedocs.io/en/latest/sempy_labs.html#sempy_labs.list_notebooks)
• [search_notebooks](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#search-notebooks) Search notebooks for a given string (to identify which notebooks contain that string).
• [copy_item](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#copy-an-item-to-a-new-location) Copies an item (with a definition) to another (specified) location.
• sempy_labs.ml_model
• [activate_ml_model_endpoint_version](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.ml_model.html#sempy_labs.ml_model.activate_ml_model_endpoint_version)
• + 13 more

📦 Updated Functions

• sempy_labs
• All external data share functions now support service principal authentication.
• [is_default_semantic_model](https://semantic-link-labs.readthedocs.io/en/latest/sempy_labs.html#sempy_labs.is_default_semantic_model) now supports dataset name or ID.
• sempy_labs.graph
• [send_mail](https://semantic-link-labs.readthedocs.io/en/latest/sempy_labs.graph.html#sempy_labs.graph.send_mail) Updated the content types to support .geojson files (#520).
• sempy_labs.migration
• [Direct Lake Migration](https://github.com/microsoft/semantic-link-labs/blob/main/notebooks/Migration%20to%20Direct%20Lake.ipynb) now defaults to migrating to Direct Lake over OneLake (previously defaulted to Direct Lake over the SQL Endpoint).

🗑️ Removed Functions

• The 'generate_dax_query_view_url' function is no longer supported by the Power BI product team.

🐛 Bug Fixes

• #781
• #786
• #789

📦 Updated Functions

• sempy_labs.graph
• [send_mail](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#send-an-email) The following parameters have been added: priority, follow_up_flag, attachments (#520).

🐛 Bug Fixes

• #732
• #736
• #742
• #746
• #751
• #752
• #757 (thanks @erlendoeien!)
• [is_v_ordered](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.is_v_ordered) fixed edge case scenario.

🐛 Bug Fixes

• #732
• #734

✨ New Functions

• sempy_labs
• Dataflows
• [get_dataflow_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_dataflow_definition) Gets the definition of a dataflow (Gen1 / Gen2 / Gen2 CI/CD) (#727). Thanks @itsnotaboutthecell!
• [upgrade_dataflow](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#upgrade-a-dataflow-to-gen2-cicd) Upgrades a dataflow Gen1 or Gen2 -> Gen2 CI/CD. Thanks @itsnotaboutthecell!
• sempy_labs.admin
• [list_orphaned_workspaces](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_orphaned_workspaces) Easily view only orphaned workspaces. Thanks @pawarbi!
• sempy_labs.theme
• [list_org_themes](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#list-organizational-themes) Lists all [organizational themes](https://www.linkedin.com/pulse/organizational-themes-preview-pbicorevisuals-j7jxe/).
• + 4 more

📦 Updated Functions

• sempy_labs
• [list_dataflows](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#list-dataflows) Now lists all dataflow generations (Gen1, Gen2, Gen 2 CI/CD). Thanks @itsnotaboutthecell!
• sempy_labs.lakehouse
• [get_lakehouse_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.get_lakehouse_tables) Now supports schema-enabled lakehouses. Thanks @tarente!
• [run_table_maintenance](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.run_table_maintenance)Now waits for the table maintenance job to complete. Also returns a dataframe showing the job stats upon completion/failure (#709).
• sempy_labs.report
• [ReportWrapper.list_visuals](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.ReportWrapper.list_visuals) Added the 'URL' column which provides a link to a focused view of the particular visual (#713).
• [run_report_bpa](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.run_report_bpa) The 'URL' output now provides direct links to the relevant item (report, page or visual). The new part here is direct links to visuals (same as in list_visuals).
• + 3 more

🐛 Bug Fixes

• #718
• #719 thanks @vytautas9!
• #730

✨ New Functions

• sempy_labs
• [list_semantic_model_datasources](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_semantic_model_datasources)
• [refresh_sql_endpoint_metadata](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#refresh-sql-endpoint-metadata)
• sempy_labs.mirrored_azure_databricks_catalog
• [refresh_catalog_metadata](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.mirrored_azure_databricks_catalog.html#sempy_labs.mirrored_azure_databricks_catalog.refresh_catalog_metadata)
• [discover_catalogs](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.mirrored_azure_databricks_catalog.html#sempy_labs.mirrored_azure_databricks_catalog.discover_catalogs)
• [discover_schemas](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.mirrored_azure_databricks_catalog.html#sempy_labs.mirrored_azure_databricks_catalog.discover_schemas)
• [discover_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.mirrored_azure_databricks_catalog.html#sempy_labs.mirrored_azure_databricks_catalog.discover_tables)
• + 2 more

🐛 Bug Fixes

• #699
• #700
• Fixed issue with [create_notebook](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.create_notebook)

✨ New Functions

• sempy_labs.report
• [ReportWrapper](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.ReportWrapper) (Huge thanks to @ruiromano for his partnership in creating and testing the new capabilities within the ReportWrapper)!
• [get](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#get-filesjson-within-the-report) Allows you to get the definition of a particular file within a report definition. This also supports specifying a [JSONPath](https://jsonpath.com/).
• [add](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#add-a-file-to-a-report-definition) Allows you to add a file to the definition of a report.
• [update](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.ReportWrapper.update) Allows you to update a file's definition within a report.
• [remove](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#remove-a-file-from-a-report-definition) Allows you to remove a file from the report definition. This also supports specifying a [JSONPath](https://jsonpath.com/).
• [set_json](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.ReportWrapper.set_json) Allows you to add/update json content for a particular file and [JSONPath](https://jsonpath.com/).
• [connect_report](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.connect_report) Similar to [connect_semantic_model](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#connecting-to-the-tabular-object-model-tom) only for reports. Not only has the readonly parameter (setting to False allows you to make changes to the report) but has a 'show_diffs' parameter which shows you a CI/CD color-coded code comparison between the existing json files and what has changed (if changes were made to the report within this function).
• + 1 more

📦 Updated Functions

• [get_user_delegation_key](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_user_delegation_key) has been moved to the sempy_labs package (previously it was in the sempy_labs.lakehouse package)

✨ New Functions

• sempy_labs
• Semantic Models
• [create_vpax](https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#create-a-vpax-file) Creates a .vpax file a la Vertipaq Analyzer. Thanks @marcosqlbi & @dgosbell!
• [update_semantic_model_refresh_schedule](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.update_semantic_model_refresh_schedule) (#679)
• Environments
• [list_environments](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_environments)
• Tags
• [list_tags](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_tags)
• + 19 more

📦 Updated Functions

• sempy_labs
• [query_kusto](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.query_kusto) Removed logic which caused DateTime columns to display as integers instead of as dates.
• [get_notebook_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_notebook_definition), [create_notebook](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.create_notebook), [update_notebook_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.update_notebook_definition) Added the 'format' parameter. Thanks @lBilali!
• sempy_labs.directlake
• [update_direct_lake_model_connection](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.update_direct_lake_model_connection) Added the 'tables' parameter to support updating the Direct Lake connection for specific tables in a model (#659).

🐛 Bug Fixes

• #462
• #630 ([list_blobs](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.list_blobs) now supports pagination)
• #641
• #663
• #668
• #669
• #671
• #675

✨ New Functions

• sempy_labs
• [query_kusto](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.query_kusto) Query a KQL database using either KQL or SQL. Thanks @pawarbi!
• [query_workspace_monitoring](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.query_workspace_monitoring) View [workspace monitoring](https://learn.microsoft.com/fabric/fundamentals/workspace-monitoring-overview) stats by running either a KQL or SQL query.
• sempy_labs.admin
• [get_refreshables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.get_refreshables) Thanks @ecotte!
• [export_dataflow](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.export_dataflow) Thanks @ecotte!

📦 Updated Functions

• sempy_labs
• [backup_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.backup_semantic_model) Added the optional 'password' parameter. Thanks @MitchSS!
• [restore_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.restore_semantic_model) Added the optional 'password' parameter. Thanks @MitchSS!
• [save_as_delta_table](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.save_as_delta_table) This function can now be executed in either a PySpark or pure python notebook. (#623)
• sempy_labs.lakehouse
• [optimize_lakehouse_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.optimize_lakehouse_tables) This function can be executed in either a PySpark or pure python notebook (#542)
• [vacuum_lakehouse_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.vacuum_lakehouse_tables) This function can be executed in either a PySpark or pure python notebook (#542).
• [get_lakehouse_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.get_lakehouse_tables) Now supports Service Principal authentication (#609). This function can now be executed in either a PySpark or pure python notebook.
• + 1 more

🐛 Bug Fixes

• #616
• #622
• sempy_labs
• Fixed issue with Direct Lake semantic models using [vertipaq_analyzer](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.vertipaq_analyzer)
• Fixed issue with [get_semantic_model_size](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_semantic_model_size)
• sempy_labs.admin
• [list_unused_artifacts](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_unused_artifacts) Fixed reversed name and ID.
• sempy_labs.directlake
• + 1 more

📋 Changes

• Fixed issue with semantic link scopes for particular Fabric API references
• Fixed issue with [create_abfss_path](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.create_abfss_path)

📋 Changes

• Fixed bug regarding duplicated 'resolve' functions.