TabularEditor VS PowerQueryNet

If you want to try it out, the easiest option is to get Tabular Editor 2: https://github.com/TabularEditor/TabularEditor/releases/tag/2.18.1

You can define object-level security (OLS) to secure columns or tables in a similar manner to RLS. This will require using Tabular Editor (also [available as Tabular Editor 3, a commercially supported product) or some other external tool, as PBID does not yet support editing OLS.

If you actually have 300+ measures in your model, you should really try using Tabular Editor to replace some of those measures with a Calculation Group.

Look into using Perspectives to handle different views of the same single Golden dataset for different departments. You'll need to use Tabular Editor to create them, but you need to use it for so many other things too like applying best practices.

Use Power BI Premium Per User if you can afford. This allows you to use the Tabular Editor tool . There some posts from Reddit users who aggressively support this approach for GIT controlling the "Dataset only PBIX". You work with the underlying model file directly.

There are two versions. Tabular Editor 2 is free, Tabular Editor 3 is commercial:

One of the things that I really like about the "M" formula language used in Power Query is the ability to functionally express such mappings, and a graphical environment for creating the expressions. Because your post got me curious about using M from C#, I did some Googling and found this: https://github.com/gsimardnet/PowerQueryNet. I sure the project would benefit from other developers/contributors.