Windows authentication while loading the data Default location is listed in the template. Here again, the location for the dumped file needs to be entered. A new Power BI Desktop instance will open and the.By default this is C:\temp but you might have changed this to your own preference. At execution of the script, a json file is dumped in the defined location.This is the process that triggers all other actions to happen. After the click, you might see a PowerShell window appear and disappear quickly.In the Top Ribbon under External Tools, click Document Model.Open a Power BI solution that you want to document.I want to shortly describes how the approach works and what you can expect. Please know that the below description might not 100% match the current way of working, as I’m continuously updating the tool based on your feedback! This applies for the way of working as well as installing the tool! I advise to check the Change log as well. But first, let’s have a quick look on how it works and what the end-result will be. Below I describe in a few steps how you can integrate the Model Documentation External Tool yourself.
External Tool IntegrationĪs mentioned, in a few steps we can integrate a new External Tool in Power BI. By providing an External Tool in Power BI Desktop, I hope that I can make it easier for a lot of people to deliver at least some basic documentation with their solutions.
Fellow MVP, Ásgeir Gunnarsson posted a nice comment on my tweet stating that documentation is often not prioritized by the customer.Īlthough the sentiment around documentation is not very positive, I believe that we as Data Analytics professionals should continue advising our customers to care about documentation. Does it come with proper documentation?- Marc Lelijveld July 27, 2020Īs we live in a busy era, we do not have that much time to document our solutions. If you deliver or use a #PowerBI solution which results in a shared dataset. I was a bit shocked, but not surprised at the same time by the results. I also posted a poll on Twitter to measure the sentiment around documenting Power BI solutions. Maybe you even promote or certify this dataset in the future, which implicates that the model matches certain quality metrics and best practices. Especially if you want to share the dataset for reuse, I believe it is important to deliver some documentation as well. I know, documentation is not a very famous topic, but I believe a very important one! Lead time from data to insights is very short with Power BI, but often we forget to look back on what kind of monster we created. Yes, really! I build and External Tool to document your Power BI Model. Please check the latest information on the product page. This version of the Power BI Model Documenter is outdated. In this blog I describe how I created my external tool to document your Power BI model and how you can start using this! Inspired by all the great content that was already created by David Eldersveld for Phyton integration and Erik Svensen with Excel Integration, I decided to build my own External tool as well. Tools such as ALM Toolkit, DAX Studio and Tabular Editor integrate nicely with Power BI Desktop and are capable of writing data in your Power BI model (if new meta data preview is enabled).Įxternal Tools capabilities are open source, so everyone can create his own tools to integrate with Power BI. With that 3rd party tooling integration is now possible. In the Power BI Desktop July release, the External Tools capability was released (in preview).