PowerBI.tips

Three New Time-Saving Scripts for Tabular Editor

September 23, 2021 By Mike Carlo
Sharing And Administration
Three New Time-Saving Scripts for Tabular Editor

Howdy folks!

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.

  1. 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.
  2. 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
  3. 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!

James

#power-bi

Previous

Copy Power BI Desktop Server:Port Connection String to Clipboard

Next

A better way to Mobile

More Posts

Mar 25, 2026

Git Best Practices Diff Noise & Naming - Ep. 513

Mike and Tommy break down the Git habits that make pull requests easier to review, cleaner to merge, and less painful to maintain over time. If your team fights diff noise, inconsistent naming, and mystery changes buried in commits, this episode gives you a practical framework for cleaning that up.

Mar 20, 2026

Publish to Web vs. Embedded - Ep. 512

Mike and Tommy break down the real difference between Publish to Web and Power BI Embedded, and why mixing them up creates security and governance headaches fast. If you need to share reports outside your organization, this episode gives you the practical framework for choosing the right option without accidentally turning convenience into a data leak.

Mar 18, 2026

Scaling a Power BI Side Hustle - Ep. 511

Mike and Tommy break down what it actually takes to grow a Power BI side hustle from occasional freelance work into a repeatable consulting engine. If you're balancing client delivery, productized offers, and the reality of limited time, this episode gives you a sharper playbook for scaling without creating chaos.