C# Script Library: Advanced Scripts

• 2023-02-27

Applies to:

• ✔Tabular Editor 2.x
• ✔Tabular Editor 3.x

These are more advanced scripts with sophisticated functionalities requiring a more advanced understanding of the C# language and TOM. They are more difficult to modify and thus recommended only once you have become comfortable with the foundations of C# Scripting in Tabular Editor.

Script Name	Purpose	Use-case
Create Date Table	Creates a formatted Date table based on selected Date columns in the model.	When you need to create a new date table based on a template.
Create M Parameter (Auto-Replace)	Creates a new M Parameter and automatically adds it to M Partitions.	When you want to replace strings in multiple partitions (i.e. connection strings) with a dynamic M Parameter.
Format Power Query	Formats the Power Query of a selected M Partition by using the powerqueryformatter.com API.	When you have complex Power Query and need to make it more readable for reading or making changes.
Implement Incremental Refresh	Configures Incremental Refresh automatically using parameters from a UI dialogue box.	When you need to implement incremental refresh but aren't comfortable with the configuration in the table settings.
Remove Measures with Errors	Creates a new M Parameter and automatically adds it to M Partitions.	When you want to replace strings in multiple partitions (i.e. connection strings) with a dynamic M Parameter.