fabric_cat_tools 0.4.1

Bug fixes

• Fixed bug in the is_direct_lake function (not returning value).
• run_model_bpa was not showing severity icons.
• Direct Lake Migration will not fail if an object cannot be created (#15).

New features

• Added the 'exclude_characters' parameter to the translate_semantic_model function. Any character put into this parameter will be replaced with a space and thus excluded from the translation. As an example, exclude_characters = '_-' will translate 'Dim Account Sales' instead of 'DimAccount - Sales'. (#12)
• Updated the show_unsupported_direct_lake_objects function to output the 3 dataframes instead of displaying them (#14). See the Migration to Direct Lake notebook for the updated syntax for viewing the dataframes.
• Added the migration_validation function (#16).
• Added the list_semantic_model_objects function (#16).
• Added the save_as_delta_table function. This function facilitates saving a dataframe as a delta table in your lakehouse.

fabric_cat_tools 0.4.0

Bug fixes

• Fixed issue with migrate_model_objects_to_semantic_model function.

New Features

• Added the TOM package which contains 60+ functions to ease the accessibility of the Tabular Object Model for semantic models. Each function is documented with an example.
• Added the Tabular Object Model notebook with additional examples and context for using the TOM package.
• Added the following parameters to the refresh_semantic_model function: tables, partitions, retry_count. With these parameters you can now easily process individual tables or partitions. See the examples in the documentation to learn how to use these new parameters.
• Added the translate_semantic_model function.
• Added the list_warehouses function.
• Added the get_model_calc_dependencies function.
• Calculated tables which use the 'Calendar' function and contain calculated columns are now supported in the Direct Lake Migration process (#8).

Function retirement

• The add/remove functions have been retired in favor of the new ones available in the TOM package.
• The control_fallback function has been retired in favor of the set_direct_lake_behavior function in the TOM package.

fabric_cat_tools 0.3.3

• Fixed a bug in the create_pqt_file function.
• Fixed a bug in the migrate_calc_tables_to_lakehouse function.
• Added the run_dax function. This function allows you to run a DAX query against a semantic model and impersonate a user (with row level security) using the 'user_name' parameter.
• Added the generate_embedded_filter function.
• Added the list_dataflow_storage_accounts function.
• Added the get_object_level_security function.

fabric_cat_tools 0.3.2

• Fixed a bug in run_model_bpa function (#6).
• Added a parameter 'read_stats_from_data' to the vertipaq_analyzer function which allows the user to specify if they want to obtain statistics which use DAX or Spark to query the lakehouse (for Column Cardinality and Missing Rows) (#7).
• Added the option to specify a list of pages in the export_report function. See the examples within the function documentation.
• Added the option to specify a list of visuals (with their corresponding page) in the export_report function. See the examples within the function documentation.
• Added the 'export' parameter to the get_lakehouse_tables function which saves the resulting dataframe to a delta table in your lakehouse.

fabric_cat_tools 0.3.1

• Microsoft updated the column names in the table showing Direct Lake's guardrails. Updated dependent functions (#4).
• The vertipaq_analyzer function now supports executing against semantic models in different workspaces and if the lakehouse used for Direct Lake is hosted in a different workspace (by using the lakehouse_workspace parameter).
• Added the create_warehouse function which, as expected, creates a new Fabric warehouse.
• Added the update_item function. This allows you to update the name/description of any of the following Fabric items: 'DataPipeline', 'Eventstream', 'KQLDatabase', 'KQLQueryset', 'Lakehouse', 'MLExperiment', 'MLModel', 'Notebook', 'Warehouse'.
• Updated export_report to check that a lakehouse is attached to the notebook.
• Added the report_filter parameter to the export_report function, enabling a report filter to be specified upon exporting the report to a file. See the examples here as the syntax has been made user friendly.
• Added the 'return_dataframe' parameter to the run_model_bpa function which returns a simple pandas dataframe with the BPA results instead of the standard visualization.
• Added the 'export' parameter to the run_model_bpa function which allows for exporting the model BPA results to a table in your lakehouse.
• The export capability in the vertipaq_analyzer function and the run_model_bpa function exports columns for 'Timestamp' and 'RunId' (RunId increments with each export run so it is easy to track and filter.

fabric_cat_tools 0.3.0

• BREAKING CHANGE: Updated parameter names in all functions to conform to the PEP8 style guide
  • Updated the Direct Lake Migration notebook accordingly
• #2 Added new_dataset_workspace parameters to Direct Lake migration functions, enabling migration of a Direct Lake semantic model to be to a different workspace than the original semantic model.
• #2 Updated workspace parameters in the report_rebind function to be: report_workspace, dataset_workspace
  • This allows for rebinding of reports to semantic models in different workspaces.
• #2 Updated workspace parameters in the report_rebind_all function to be: dataset_workspace, new_dataset_workspace, report_workspace
  • This allows for rebinding of reports to semantic models in different workspaces.
• The get_lakehouse_details function has been retired in favor of the new list_lakehouses function. The list_lakehouses function shows the same information only for all lakehouses within a workspace.
• Added the launch_report function
• Added the cancel_dataset_refresh function
• Added the optimize_lakehouse_tables function
• Added the model_bpa_rules function which shows the default rules used by the run_model_bpa function
• Added the Model Optimization notebook which shows example uses of the model optimization functions in this library

fabric_cat_tools 0.2.5

• Fixed bug #1 in run_model_bpa regarding models with no hierarchies
• Added the list_shortcuts function
• Added the list_dashboards function
• Added a new rule to run_model_bpa: 'Set dimensions tables to dual mode instead of import when using DirectQuery on fact tables'
• Added the 'saveToFileName' parameter to get_semantic_model_bim
• Added the 'saveToFileName' parameter to get_report_json

fabric_cat_tools 0.2.4

• Added the create_shortcut_onelake function
• Added the export_model_to_onelake function
• Added the delete_shortcut function
• Removed the 'extend' paramter from the run_model_bpa function
• Fixed a bug in the run_model_bpa function which duplicated violations on hierarchy objects

fabric_cat_tools 0.2.3

• Added the export_report function
• Added the clone_report function
• Added the get_report_json function

fabric_cat_tools 0.2.2

• Fixed bug regarding how Field Parameters are created (add_field_parameter, migrate_field_parameters)
• Added escape clause for get_shared_expression if the SQL Endpoint has not yet been provisioned
• Added functionality to vertipaq_analzyer so that the column cardinality for Direct Lake semantic models is obtained by querying the lakehouse