I just published three new scripts for Tabular Editor to the PowerBI.tips “TabularEditor-Scripts” repository on GitHub yesterday. So, I wanted to take a moment to explain what they do, and why you should have them in your Tabular Editor Scripts arsenal.
- Replace String Across All Power Queries
- Replaces a string in Power Query on all partitions in the model
- Useful for automating updates to connection strings, filter conditions, etc.
- Replace Dataset Source Dataflow IDs
- Replaces the source DataflowID & WorkspaceID on all Power Query partitions in the model
- Similar to the previous script, this one is specialized for automatically replacing old DataflowID and WorkspaceID references in Power Query with new ones. Helpful in situations where you need to re-deploy an existing Dataflow and Dataset to a new workspace, and then re-link the new Dataset to the new Dataflow
- Exclude Selected Tables From Model Refresh
- Excludes the selected tables from model refresh
- Useful for quickly excluding specific tables from the model refresh, which you may need to do for any number of reasons, including troubleshooting, performance, etc.
This repo has lots of other useful Tabular Editor Scripts, and we add more every day, so check it out! Also, if you have some handy scripts of your own, you can Fork the repo and submit a Pull Request. Then, we will add your scripts to the collection.
Happy scripting, everyone!