PowerBI.tips

Copy Power BI Desktop Server:Port Connection String to Clipboard

September 12, 2021 By Mike Carlo
Building Reports
Copy Power BI Desktop Server:Port Connection String to Clipboard

Howdy, folks!

A few months ago, I was writing and running various PowerShell scripts to manipulate the connected data models in my Power BI Desktop files. During model development, I was constantly having to open DAX Studio to copy the Server:Port connection string, and thinking, “there’s got to be a faster way to do this.”

So, I developed and released a simple External Tool for Power BI Desktop, which copies the Server:Port connection string for the currently-connected data model directly to the clipboard.

I’m a strong believer in modular design, so when I build something, I try to make it do one thing, and do it well. I believe this External Tool for Power BI Desktop is a great example of that philosophy in action.

This external tool is now in the Business Ops tool from PowerBI.tips.

Enjoy!

James

#power-bi

Previous

Power BI Bookmarks Tips, Tricks, and Best Practices

Next

Three New Time-Saving Scripts for Tabular Editor

More Posts

Aug 13, 2026

Fabric as a Backend – Ep.554

Mike has been building apps on Fabric as a backend since January, and he's coining it FAB. The case isn't that you already own Fabric — it's that the workspace identity, git integration, and SQL database remove the wiring you'd otherwise do by hand in Azure.

Aug 11, 2026

Crawl, Walk, Run with AI in PBI – Ep.553

Meagan Longoria's five-stage maturity model for agentic Power BI development gives Mike and Tommy a framework to argue with. They mostly agree — except on the crawl stage, where Mike thinks starting with an MCP server beats starting with a chatbot.

Aug 6, 2026

Power BI Desktop Bridge – Ep.552

Desktop Bridge gives agents a local server to drive Power BI Desktop — reload files, check report state, and take screenshots so the agent can verify its own work. Mike and Tommy agree on the prerequisite: don't use it without skills.