TOC : Tabular Editor 2/3 : Custom c# Scriptas and bestPracticeAnalyzer

TOC : Tabular Editor 2 and 3 : Custom c# Scriptas and bestPracticeAnalyzer.2023.04.md

BestPracticeAnalyzer and CSharp using Tabular models (generated on: 2023-03)

Note, some things tagged as TabularEditor2 vs 3 have a decent level of overlap, that it's worth checking out the other

Invoking from a pipeline

• command line arguments introduction
• te2: Command line Options
• Azure DevOps integration

onboarding / intro

• Tabular Editor 3 with Daniel Otykier from 2 years ago, there's newer versions on youtube
• Tabular3
• TOP / TOC links to start with
• https://docs.tabulareditor.com/onboarding/optimizing-workflow-workspace-mode.html

elegantbi.com

• Rectifying the Misconceptions of XMLA Read/Write, power-bi/enterprise/service-premium-connect-tools

maybe duplicate links

• te2: Useful snippets
• new in 2.7: CustomActions
• best practice analyzer v2
• https://github.com/microsoft/azure-pipelines-tasks/blob/master/docs/authoring/commands.md
• https://github.com/microsoft/Analysis-Services/tree/master/BestPracticeRules

Docs on Types

• introducing core LINQ methods
• TabularEditor
  • top level Tabular Editor API
  • .Shared
  • [ScriptHost] TabularEditor.Shared.Scripting
• Latest script helper methods
• learn: Introduction to tabular object model in AS

Any

• github: m-kovalsky/Tabular
• github: PowerBI-tips/TabularEditor-Scripts
• github: TabularEditor/Scripts
• scripting: add PowerQuery M parameters
• dynamic filters using LINQ expressions
• latest release notes for tabularEditor
• https://docs.tabulareditor.com/te2/Importing-Tables.html#manually-importing-schemametadata
• related tools: BISM, BIDS, etc

Tutorials

• "hi world" of using the UI and page 2 of the introduction
• Tabular2 "hi world" introduction csharp
  • then beginner scripts
  • and advanced scripts Both have a bunch of nested links.

Unsorted

• latest:microsoft/Analysis-Services/master/BestPracticeRules/BPARules.json
• C# Helper functions
• Using the Best Practice Analyzer
• https://docs.tabulareditor.com/te2/Useful-script-snippets.html
• https://docs.tabulareditor.com/common/using-bpa-sample-rules-expressions.html#finding-unused-objects
• dax lexical grammar
• per-model or per-user profile config
• tut: Incremental Refresh
• Table Groups

TabularEditor3

• BPA example rules expression: Find unused objects

TabularEditor2

• github.com/TabularEditor2
• advanced scripting tutorials
  • set object properties, modify current object, helper script methods , latest helper methods

Config filepaths

Powershell example

gci "$Env:ProgramData\TabularEditor"
gci "$Env:LocalAppData\TabularEditor"

%ProgramData%\TabularEditor

BPARules.json Best Practice Analyzer rules that are available to all users.
    TOMWrapper.dll This file is used when executing scripts inside Tabular Editor. You can also reference the .dll in your own .NET projects, to utilise the wrapper code. If you are having issues executing advanced scripts after upgrading Tabular Editor, please delete this file and restart Tabular Editor.
    Preferences.json This file stores all preferences set in the File > Preferences dialog.

%AppData%\Local\TabularEditor

BPARules.json Best Practice Analyzer rules that are available only to the current user.

CustomActions.json Custom script actions that can be invoked from the right-click menu or the Tools-menu of the Explorer Tree. These actions can be created on the Advanced Script Editor tab.

RecentFiles.json Stores a list of recently opened .bim files. The last most 10 items in this list is displayed in the File > Recent Files menu.

RecentServers.json Stores a list of recently accessed server names. These are displayed in the dropdown portion of the "Connect to Database" dialog box and in the Deployment Wizard.