Semantic-link-labs

Bug Fixes
* 274
* 277
* sempy_labs.migration
* [create_pqt_file](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.migration.html#sempy_labs.migration.create_pqt_file) Fixed the file naming convention when multiple pqt files are generated.

Improvements

* New Functions
* sempy_labs
* [get_dax_query_dependencies](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_dax_query_dependencies) Obtains the columns on which a DAX query depends, including model dependencies (inspired by [Chris Webb's blog post](https://blog.crossjoin.co.uk/2024/10/20/finding-the-columns-touched-by-a-dax-query/)).
* [get_dax_query_memory_size](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_dax_query_memory_size) Obtains the total size, in bytes, used by all columns that a DAX query depends on (inspired by [Chris Webb's blog post](https://blog.crossjoin.co.uk/2024/10/20/finding-the-columns-touched-by-a-dax-query/)).
* [list_upstream_dataflows](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_upstream_dataflows) Thanks to Alex Powers, this shows all dataflows upstream of a given dataflow.
* [list_mirrored_databases](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_mirrored_databases)
* [start_mirroring](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.start_mirroring)
* [stop_mirroring](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.stop_mirroring)
* [create_mirrored_database](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.create_mirrored_database)
* [delete_mirrored_database](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.delete_mirrored_database)
* [get_mirroring_status](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_mirroring_status)
* [get_tables_mirroring_status](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_tables_mirroring_status)
* [get_mirrored_database_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_mirrored_database_definition)
* [update_mirrored_database_definition](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.update_mirrored_database_definition)
* sempy_labs.admin
* [list_modified_workspaces](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_modified_workspaces)
* sempy_labs.report
* [download_report](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.download_report) Downloads a Power BI report and saves it as a .pbix file in the Files within the Lakehouse attached to the notebook.
* sempy_labs.tom
* [set_value_filter_behavior](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.set_value_filter_behavior) ([learn more here](https://learn.microsoft.com/en-us/power-bi/transform-model/value-filter-behavior))
* Updated Functions
* sempy_labs.tom
* [add_calculation_group](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.add_calculation_group) Added the 'column_name' parameter (261).

Bug Fixes
* 163
* 235
* 244
* 246
* 259
* 260
* 261
* 266
* 267
* 273
* 275
* 276

Notebooks
* Embedded videos within notebooks for easier learning.

* New Functions
* sempy_labs
* [get_semantic_model_refresh_history](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_semantic_model_refresh_history)
* [get_warehouse_tables](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_warehouse_tables)
* [get_warehouse_columns](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_warehouse_columns)
* [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)
* [get_workloads](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_workloads)
* [patch_workload](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.patch_workload)
* [create_managed_private_endpoint](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.create_managed_private_endpoint)
* [delete_managed_private_endpoint](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.delete_managed_private_endpoint)
* [list_managed_private_endpoints](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.list_managed_private_endpoints)
* sempy_labs.report
* [get_report_datasources](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.get_report_datasources)
* 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)
* Updated Functions
* sempy_labs
* [refresh_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.refresh_semantic_model) If the refresh fails, this function now prints out the failure message(s). Added the 'visualize' parameter which if set to True shows a real-time visual of the refresh statistics per [Phil Seamark's blog](https://dax.tips/2023/12/05/visualize-power-bi-refresh-using-sempy/).
* [import_notebook_from_web](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.import_notebook_from_web) Added the 'overwrite' parameter.
* [model_bpa_rules](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.model_bpa_rules) Ensure all rules have descriptions.
* sempy_labs.admin
* [list_activity_events](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_activity_events) Updated 'Creation Time' column to be of datatype 'DateTime'.
* [list_workspaces](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.admin.html#sempy_labs.admin.list_workspaces) Added the 'filter' parameter (204).
* Updated the 'admin' functions which reference workspaces to leverage the admin version of list_workspaces.

General updates
* Direct Lake migration now supports relationships based on datetime (243).

* Bug fixes
* 86
* 212
* 225
* 226
* 229
* 232
* 239
* sempy_labs
* [update_fabric_capacity](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.update_fabric_capacity)
* sempy_labs.tom
* [set_sort_by_column](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.set_sort_by_column)
* [mark_as_date_table](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.mark_as_date_table)

Notebook updates
* [SQL](https://github.com/microsoft/semantic-link-labs/blob/main/notebooks/SQL.ipynb) Added the get_warehouse_tables, get_warehouse_columns functions.
* [Semantic Model Refresh](https://github.com/microsoft/semantic-link-labs/blob/main/notebooks/Semantic%20Model%20Refresh.ipynb) Added cells for visualizing a refresh and getting the refresh history for a semantic model.

* 184
* 185
* 198
* sempy_labs
* [deploy_semantic_model](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.deploy_semantic_model) Fixed issue with inaccurate subfunction parameter call.
* [run_model_bpa](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.run_model_bpa) The function showed a warning in some environments which has been resolved.
* sempy_labs.tom
* [generate_measure_descriptions](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.generate_measure_descriptions) Fixed for when 'measure_name' is None. The output is now a pandas dataframe showing the auto-generated measure descriptions. Note that this function is only viable if your capacity is a paid F64 or higher (trials not included).
* [update_lineage_tags](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.tom.html#sempy_labs.tom.TOMWrapper.update_lineage_tags) Fixed bug.

Notebooks
* Updated the [Capacity Migration](https://github.com/microsoft/semantic-link-labs/blob/main/notebooks/Capacity%20Migration.ipynb) notebook to incorporate migrating a Fabric Trial capacity to a Fabric paid capacity.

* Fixed library loading issue related to deltalake & pyarrow by reverting back to spark for now.

* 172
* 174
* Edit Tables functionality in the web browser not working after creating/modifying a semantic model using TOM. This is resolved by properly setting the LineageTag, SourceLineageTag for required objects as well as the 'SchemaName' property for partitions in Direct Lake mode.
* Fixed [get_model_calc_dependencies](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_model_calc_dependencies) and [get_measure_dependencies](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html#sempy_labs.get_measure_dependencies) so that the warning previously shown is resolved and no longer shows.
* Fixed bug in [run_report_bpa](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.report.html#sempy_labs.report.run_report_bpa)
* Site containing documentation for the Direct Lake guardrails changed. Fixed [get_direct_lake_guardrails](https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.get_direct_lake_guardrails)

Misc
* Added [Featured Scenarios](https://github.com/microsoft/semantic-link-labs#featured-scenarios) section to README.md