semantic-link-labs 0.8.11

Improvements

• New Functions

  • sempy_labs
    • Job Scheduler
      • list_item_job_instances (per request)
    • Git (the following functions replace the 'connect_workspace_to_git' function.
      • connect_workspace_to_azure_dev_ops
      • connect_workspace_to_github
  • sempy_labs.tom
    • remove_role_member

• Updated Functions

  • sempy_labs
    • Most (relevant) functions now accept dataset ID or Name; workspace ID or Name.
  • sempy_labs.directlake
    • Cache warming functions leverage updated DAX which yields better performance.

Bug Fixes

• #363
• #370
• Fixed list_dataflows
• Fixed get_capacity_id
• Fixed get_model_calc_dependencies issue which could result in an infinite loop.
• Fixed unqualified_columns logic.
• Fixed qualified_measures logic.

semantic-link-labs 0.8.10

Improvements

• New Functions

  • sempy_labs
    • list_server_properties Shows the server properties for a given workspace.
    • list_semantic_model_errors Shows if the model has any errors and their error messages.
    • get_tenant_id
    • bind_semantic_model_to_gateway
  • sempy_labs.tom
    • add_role_member
  • sempy_labs.admin
    • scan_workspaces Wrapper function for the Scanner API.

• Updated Functions

  • sempy_labs
    • run_model_bpa Setting 'extended=True' no longer requires annotations to be saved to the model.
    • list_dashboards Bug fixed in resolving the workspace.
    • run_model_bpa, get_model_calc_dependencies, refresh_semantic_model The 'dataset' parameter now takes either the name or ID of the semantic model.
    • get_notebook_definition now works for any type of notebook (.py, .sql etc.)
    • create_notebook Added the 'type' parameter so you can create other types of notebooks ('py, 'sql').
  • sempy_labs.admin
    • list_activity_events Additional columns added (#340).
  • sempy_labs.directlake
    • check_fallback_reason The 'dataset' parameter now takes either the name or ID of the semantic model.
  • sempy_labs.tom
    • TOMWrapper The 'dataset' parameter now takes either the name or ID of the semantic model. Same for connect_semantic_model.

Bug Fixes

• #331
• #335

semantic-link-labs 0.8.9

Improvements

• New Functions
  • sempy_labs
    • get_semantic_model_definition (#300)
  • sempy_labs
    • get_capacity_assignment_status
• Updated Functions
  • sempy_labs
    • get_dax_query_dependencies Added the 'show_vertipaq_stats' parameter. The 'dax_string' parameter now accepts either a single DAX query or a list of DAX queries.
  • sempy_labs.report.ReportWrapper
    • list_visual_objects now shows the Object Display Name (if it was customized within the visual).

Bug Fixes

• sempy_labs.admin
  • assign_workspaces_to_capacity Fixed issue where the function didn't resolve if workspace was set to None.
• #186
• #314
• #317
• #326

semantic-link-labs 0.8.8

Bug Fixes

• #254
• #280

semantic-link-labs 0.8.7

Improvements

• New Functions

  • sempy_labs
    • Connections
      • create_cloud_connection
      • create_vnet_connection
      • create_on_prem_connection
      • list_connection_role_assignments
      • delete_connection_role_assignment
      • delete_connection
    • Gateways
      • list_gateways
      • delete_gateway
      • list_gateway_role_assigments
      • delete_gateway_role_assignment
      • list_gateway_members
      • create_vnet_gateway
      • delete_gateway_member
      • update_on_premises_gateway
      • update_vnet_gateway
    • Authentication
      • ServicePrincipalTokenProvider Class which generates a token provider via Azure Key Vault or Service Principal keys. This is the foundation for authenticating relevant functions via Service Principal. Thanks @ecotte!
      • ServicePrincipalTokenProvider.from_azure_key_vault Obtains a token provider using Azure Key Vault credentials.
      • ServicePrincipalTokenProvider.from_aad_application_key_authentication Obtains a token provider using Service Principal keys.
  • sempy_labs.admin
    • list_git_connections
    • list_reports

• Updated Functions

  • sempy_labs
    • list_connections Now supports pagination.
    • initialize_git_connection Now returns commit hash. Thanks @hurtn!
    • refresh_semantic_model Added 'commit_mode' parameter. Thanks @gbrueckl!
  • sempy_labs.report
    • get_report_definition Added the 'return_dataframe' parameter which defaults to True. If set to False, the function returns the json dictionary output.
  • sempy_labs.report.ReportWrapper
    • list_visuals Title, SubTitle, AltText now support non-literal values (#218) Thanks @stephbruno!
  • sempy_labs.admin Thanks @ecotte!
    • list_workspaces Now uses the Fabric API and defaults to returning all workspaces. 'filter' parameter is no longer supported. New parameters available: capacity, workspace, workspace_state, workspace_type.
    • list_capacities Now supports capacity name or Id.
    • assign_workspaces_to_capacity Now supports workspace name or Ids.
    • unassign_workspaces_from_capacity Now supports capacity name or Id.
    • revoke_external_data_share Supports workspace name or Id.
    • list_items Supports capacity name or Id, workspace name or Id.
    • list_item_access_details Supports Item Id or name & type. Supports workspace Id or Name.
    • list_activity_events Added the 'return_dataframe' parameter, allowing for returning the json dictionary output (if set to False).

Bug Fixes

• sempy_labs
  • update_from_git
  • update_semantic_model_from_bim
  • #288
  • #290

semantic-link-labs 0.8.6

Bug Fixes

• #274
• #277
• sempy_labs.migration
  • create_pqt_file Fixed the file naming convention when multiple pqt files are generated.

semantic-link-labs 0.8.5

Improvements

• New Functions
  • sempy_labs
    • DAX
      • get_dax_query_dependencies Obtains the columns on which a DAX query depends, including model dependencies (inspired by Chris Webb's blog post).
      • 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).
    • Dataflows
      • list_upstream_dataflows Thanks to Alex Powers, this shows all dataflows upstream of a given dataflow.
    • Mirroring
      • list_mirrored_databases
      • start_mirroring
      • stop_mirroring
      • create_mirrored_database
      • delete_mirrored_database
      • get_mirroring_status
      • get_tables_mirroring_status
      • get_mirrored_database_definition
      • update_mirrored_database_definition
  • sempy_labs.admin
    • list_modified_workspaces
  • 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 (learn more here)
• Updated Functions
  • sempy_labs.tom
    • 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.

semantic-link-labs 0.8.4

Improvements in 0.8.4

• New Functions
  • sempy_labs
    • Semantic Models
      • get_semantic_model_refresh_history
    • Warehouses
      • get_warehouse_tables
      • get_warehouse_columns
    • Notebooks
      • create_notebook
      • update_notebook_definition
    • Workloads
      • get_workloads
      • patch_workload
    • Managed Private Endpoints
      • create_managed_private_endpoint
      • delete_managed_private_endpoint
      • list_managed_private_endpoints
  • sempy_labs.report
    • get_report_datasources
  • sempy_labs.directlake
    • update_direct_lake_model_connection
• Updated Functions
  • 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.
    • import_notebook_from_web Added the 'overwrite' parameter.
    • model_bpa_rules Ensure all rules have descriptions.
  • sempy_labs.admin
    • list_activity_events Updated 'Creation Time' column to be of datatype 'DateTime'.
    • 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
  • sempy_labs.tom
    • set_sort_by_column
    • mark_as_date_table

Notebook updates

• SQL Added the get_warehouse_tables, get_warehouse_columns functions.
• Semantic Model Refresh Added cells for visualizing a refresh and getting the refresh history for a semantic model.

semantic-link-labs 0.8.3

Improvements in 0.8.3

• New Functions
  • sempy_labs
    • migrate_fabric_trial_capacity
    • create_resource_group
    • get_data_pipeline_definition
    • create_external_data_share
    • revoke_external_data_share
    • list_external_data_shares_in_item
  • sempy_labs.admin
    • list_activity_events
  • sempy_labs.tom
    • add_changed_property
    • remove_changed_property
• Updated Functions
  • sempy_labs
    • create_warehouse added a parameter for creating a warehouse with case-insensitive collation.
    • Capacity migration functions have been updated to use the admin APIs.
  • sempy_labs.tom
    • connect_semantic_model Adds lineage tags, source lineage tags and ChangedProperty accordingly to ensure that models (especially Direct Lake) work between making changes in XMLA clients and the Fabric service.
• sempy_labs.report
  • export_report Updated per PR #65.

Bug Fixes in 0.8.3

• #184
• #185
• #198
• sempy_labs
  • deploy_semantic_model Fixed issue with inaccurate subfunction parameter call.
  • run_model_bpa The function showed a warning in some environments which has been resolved.
• sempy_labs.tom
  • 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 Fixed bug.

Notebooks

• Updated the Capacity Migration notebook to incorporate migrating a Fabric Trial capacity to a Fabric paid capacity.

semantic-link-labs 0.8.2

Bug fixes in 0.8.2

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