The Business Ops tool is designed to simplify your Development Experience with Power BI Desktop. There are a lot of challenges remembering where all the best power bi external tools are stored. Many MVPs contribute amazing projects to make your development experience better. The installer is intended to streamline and increase your efficiency when working in Power BI. Download this installer and you can add all the best External Tools directly into Power BI Desktop. Our release includes all the best External tools for Power BI Desktop. This will enable you to have a one stop shop for all the latest versions of External Tools.
If you like the content from PowerBI.Tips, please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials. Subscribe to our YouTube Channel. Or follow us on the social channels, Twitter and LinkedIn, where we post all the announcements for new tutorials and content.
Introducing our PowerBI.tips SWAG store! Check out all the fun PowerBI.tips clothing and products:
This past weekend, I was a man on a mission. There were two pressing reasons for a new release of Business Ops:
The authors of many popular External Tools released updates recently, so we needed to ship a new version of Business Ops with those updates included
Last week, Michael Kovalsky (ElegantBI.com) released a brand new External Tool called Report Analyzer (which we can already tell will be an instant classic), so we wanted to get it out there and into the hands of report developers ASAP
So, I toiled away most of the day on Sunday, cramming as much value as I could into the next version. And along the way, I learned some important new software development skills, including how to:
If you like the content from PowerBI.Tips, please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials. Subscribe to our YouTube Channel. Or follow us on the social channels, Twitter and LinkedIn, where we post all the announcements for new tutorials and content.
Introducing our PowerBI.tips SWAG store! Check out all the fun PowerBI.tips clothing and products:
If you have installed Business Ops 2.0 or 2.0.1, you should use the “Edit External Tools” menu to remove the External Tools you have installed, then close and uninstall Business Ops.
In previous versions of Business Ops, its installation path was C:\Users\<Username>\AppData\Local\Programs\pbi-tips-business-ops\, which could be accessed by any process running on the machine. This struck us as somewhat insecure, so we decided to beef up the security. When we released Business Ops 2.0, we changed the installation path to C:\Program Files\PowerBI.tips Business Ops\, which requires elevated permissions to modify any files inside. This change increased the security of Business Ops, but those of you who are familiar with how file paths work can probably guess how it also had some other, unintended consequences. For those who aren’t, here’s what happened:
The installation path in previous versions did not have any spaces in it, and everything was working fine. But when we changed the installation path to one that includes spaces, several of the included External Tools in Business Ops stopped working. This wasn’t immediately obvious because it only affected the handful of External Tools which launch a PowerShell script by calling its absolute path. Once we identified the cause of the issue, the fix was pretty straightforward, and we got everything working again.
Thanks for reading!
James
If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials. Subscribe to our YouTube Channel. Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.
Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:
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.
If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials. Subscribe to our YouTube Channel. Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.
Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:
Splitting models from reports has great advantages, but can make it harder to edit. When editing a model it is useful to see how you it will effect the reports. Using live connections would mean republishing the model back to the cloud and then refreshing the connection for every change you wish to test. In addition, you would probably want to make test workspaces to not overwrite a live production model while developing.
Now there is an external tool that can help solve these issues. The tool has two functions. The first will allow you to switch from a live connection to directly connecting to an open Power BI report. This will allow “Local Development” so that it can be done on your machine without needing to republish. Changes can be seen instantly and time spent on testing can be dramatically decreased. The second will removed any connections to allow to reconnect to a shared dataset or AAS model.
After installing the tool, click external tools the Hot Swap Connections to launch.
Connect Tab
This tool will remove any live connections from the selected report and connect it directly to the Power BI report it was launched from. This will only remove live connections so you cannot accidentally delete entire models.
You can choose between Overwrite and connect or Copy and connect. Selecting Overwrite will directly edit that file by removing the connections and replacing with a live connection to the current file. Selecting copy will leave your file intact and create a copy in the same directory with the suffix defined in the settings tab. It will then open the report that is connected to the model file.
Steps:
Open your Model file
Select the Connect tab
Run Hot Swap Connections
Choose to Overwrite or Copy
Select Report file to connect
Remove Tab
This tool will remove any live connections from the selected report and open the file. This is useful when you have made local edits and want to connect it back to a dataset or analysis services model. This will only remove live connections so you cannot accidentally delete entire models.
You can choose between Overwrite and remove live connections or Copy and remove live connections. Selecting Overwrite will directly edit that file by removing the connections. Selecting copy will leave your file intact and create a copy in the same directory with the suffix defined in the settings tab. It will then open the report that has no connections.
Steps:
Open any Power BI report
Select the Remove tab
Run Remove Connections
Choose to Overwrite or Copy
Select Report file to remove connections
The script will leave all visualizations and report features intact. But, all connections will be removed. When you open the report again in power bi desktop, all visuals will appear broken:
This is because you have removed all data from the report. Select a new data source to connect the report to. If the new source matches the names of the columns and measures used in the visuals, they will all repopulate.
Settings Tab
When selecting Copy and connect or Copy and remove live connections, the tool will create a copy of your report first so you do not directly edit you report file. It will place the copy in the same directory as the original and add a suffix as defined in the settings tab.
Watch the webinar below
Steve and Mike talk through the external tool and see it in action!
We are excited to announce a new tool from PowerBI.tips The Business Ops tool. To get this tool Download it here.
For the Full Story Read on..
There are many exciting features that we love to see and share when it comes to monthly Power BI releases! The continual improvements still inspire and provide a deeper and richer experience for us all to WOW our report consumers. There are some periodic major changes that come, and we think one of those has arrived with the latest announcement of 3rd party tool integration.
Add PowerBI.tips Front End tools
After the great news above, we had our heads down looking at the documentation and were very interested in how we could add our own tools to the External Tools section. After some digging, and reviewing a fantastic blog by Eric Svensen we locked in on how we could our tools even more accessible for you!
We want to help you get to your favorite PowerBI.tips tools quickly and easily. What follows is what each of these tools offers, and how to easily connect one or all into your Power BI Desktop files for quick connection and use.
I don’t see “External Tools”
The first requirement to see the External Tools section is that you must be on July 2020 Desktop. You will NOT see the External Tools section right after you open it. The reason for that is varied, but suffice to say, you need a specific JSON folder created in your Power BI folder structure and an executable to run. We’ve made this easy for you, so just read through our choices of tools and we’ll walk you through how to get these buttons created and working for you in no time!
Tool Choices
PowerBI.tips – Part of staying engaged is staying current. What better way to do that then start everyday with a link to your favorite site – Power BI.Tips
Themes – Need to take the general settings you can do in the Desktop to the next level? Adding our Themes capability into your reports gives you full control over the customization of color, font and properties.
Charts – Utilizing the amazing work from MSFT research in Charticulator, we’ve created a version called Charts. This tool lets you build no code custom visuals that work right alongside the out of the box one’s. Check out our videos if this is new to you!
Themes Gallery – Sometimes you just need to find a little inspiration. Look no further than our extensive gallery of color themes. Easily pick and download any color theme you find.
Themes Gallery
Charts Gallery – Learning how to build the custom visuals in Charts takes a little bit of time, but while you are learning that craft, or are looking for a unique visual check out the gallery of already built custom visuals you can integrate into your reports.
ChartsGallery
Layouts – Need to take your report look and feel to the next level? Our Layouts provide some of the best looking backgrounds tailored specifically to Power BI. We use pop up dialogues for contextual explanation, page navigation and hidden slicer functionality to amaze your end users.
Scrims – Backgrounds for Power BI. We take all the principles we’ve learned in visual design to create amazing visual canvases that don’t distract from the data. Using these single images reduces the need to render all the different shapes and objects on your page making it a faster/better option.
Model – Are you a data focused individual? Have you played with Power BI dataflows? Use our Model tool to create the metadata objects you want to utilize in your Common Data Model.
Connections – Streamline your report files for other report authors by pre-configuring the data source connection. Not familiar with how you create PBIDS files? Check out our tutorial.
We know our favorites, but you probably have yours as well. Throw in a dash of IT security and you might not have the best experience with a chosen browser. As we know that is the case, you can choose one of our 3 options for kicking off these tools from the Desktop and opening the right browser.
Install Your Favorites!
Featured External tool tutorials
Want to know more about the featured tools in the MSFT blog? We had the chance to welcome the creators of those tools to tell us all about them. Be sure to check out the webinars for all the details on how to get started with them and all the capabilities they offer.
ALM Toolkit – Schema compare and deployment tool. Fantastic for Application Lifecycle Management (ALM). How to use ALM Toolkit.
Tabular Editor – An amazing modeling tool that makes working with your model a breeze. 4 part series.
If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials. Subscribe to our YouTube Channel. Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.
Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:
