{"id":4244,"date":"2022-10-22T13:10:51","date_gmt":"2022-10-22T11:10:51","guid":{"rendered":"https:\/\/thebipower.fr\/?p=4244"},"modified":"2022-12-08T13:08:15","modified_gmt":"2022-12-08T12:08:15","slug":"custom-analyser","status":"publish","type":"post","link":"https:\/\/thebipower.fr\/index.php\/2022\/10\/22\/custom-analyser\/","title":{"rendered":"Custom analyser"},"content":{"rendered":"\n<p>With &#8216;Custom analyser&#8217; feature, Power BI Sidetools users can use external tools built by the community.They may create their own Power BI external tool. The process is incredibly quick and simple. An icon can be added in the desktop ribbon so your brand new tool can be run in one click. Tools can be built in Pbit or Excel files. You will be able to share these files freely. Examples are provided so you start immediately with a result. Possibilities are infinite ; I can&#8217;t wait to see what you will do with it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Custom analyser concept<\/h2>\n\n\n\n<p>Everything starts from an opened Pbix report you want to analyse. Any custom analyser must be run from this report.<\/p>\n\n\n\n<p>Running the &#8216;Custom analyser&#8217;, Power BI Sidetools simply exports a bunch of files describing the opened Pbix report. Most of files are already familiar to experimented users but we also added simplified files exposing very obvious items.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"930\" height=\"220\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Tables-summary.png\" alt=\"custom analyser\" class=\"wp-image-4247\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Tables-summary.png 930w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Tables-summary-300x71.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Tables-summary-768x182.png 768w\" sizes=\"(max-width: 930px) 100vw, 930px\" \/><\/figure><\/div>\n\n\n<p>Then, Sidetools opens an available custom analyser which uses exported files. The refresh is automatic.   <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Your first steps<\/h2>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 28%\"><div class=\"wp-block-media-text__content\">\n<p>In the &#8216;More&#8217; menu, select &#8216;Custom analyser&#8217;<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"408\" height=\"285\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Run-Custom-analyser.png\" alt=\"\" class=\"wp-image-4253 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Run-Custom-analyser.png 408w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Run-Custom-analyser-300x210.png 300w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 39%\"><div class=\"wp-block-media-text__content\">\n<p>Select a custom analyser in the drop down list and click the &#8216;Process&#8217; button<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"417\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-window.png\" alt=\"\" class=\"wp-image-4254 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-window.png 631w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-window-300x198.png 300w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 73%\"><div class=\"wp-block-media-text__content\">\n<p>The Pbit file is loaded and refreshed automatically<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"598\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-example-Pbit-1024x598.png\" alt=\"\" class=\"wp-image-4259 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-example-Pbit-1024x598.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-example-Pbit-300x175.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-example-Pbit-768x449.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-example-Pbit.png 1299w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Create an icon in desktop&#8217;s &#8216;External tools&#8217; ribbon<\/h2>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 27%\"><div class=\"wp-block-media-text__content\">\n<p>In the &#8216;More&#8217; menu, select &#8216;External tools manager&#8217;<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"408\" height=\"286\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Run-External-tools-manager.png\" alt=\"\" class=\"wp-image-4262 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Run-External-tools-manager.png 408w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Run-External-tools-manager-300x210.png 300w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Click on &#8216;Wizard&#8217; button<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-Wizard-button.png\" alt=\"\" class=\"wp-image-4263 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-Wizard-button.png 811w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-Wizard-button-300x183.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-Wizard-button-768x469.png 768w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<ul>\n<li>Type in a file name which will be used to sort icons in &#8216;External tools&#8217; ribbon<\/li>\n\n\n\n<li>Type in a tool name which will be displayed under the icon<\/li>\n\n\n\n<li>Click on the right arrow to go to next step<\/li>\n<\/ul>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-identification.png\" alt=\"\" class=\"wp-image-4264 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-identification.png 811w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-identification-300x183.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-identification-768x469.png 768w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Optionally fill in description and version<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-documentation.png\" alt=\"\" class=\"wp-image-4267 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-documentation.png 811w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-documentation-300x183.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-documentation-768x469.png 768w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Optionally, click on the image and select the image file you want. Otherwise, a default image will be used <\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-image.png\" alt=\"\" class=\"wp-image-4266 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-image.png 811w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-image-300x183.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-image-768x469.png 768w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Select &#8216;an individual Sidetool&#8217;<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-action.png\" alt=\"\" class=\"wp-image-4271 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-action.png 811w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-action-300x183.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-action-768x469.png 768w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Select &#8216;Custom analyser&#8217;<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-select-individual-Sidetool.png\" alt=\"\" class=\"wp-image-4273 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-select-individual-Sidetool.png 811w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-select-individual-Sidetool-300x183.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-select-individual-Sidetool-768x469.png 768w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Select a custom analyser file<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"763\" height=\"540\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-select-custom-analyser-file.png\" alt=\"\" class=\"wp-image-4278 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-select-custom-analyser-file.png 763w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-select-custom-analyser-file-300x212.png 300w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Review the settings and save<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-review-and-save.png\" alt=\"\" class=\"wp-image-4281 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-review-and-save.png 811w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-review-and-save-300x183.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-review-and-save-768x469.png 768w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<ul>\n<li>Close Power BI Sidetools<\/li>\n\n\n\n<li>Close the Pbix file<\/li>\n\n\n\n<li>Reopen the Pbix file<\/li>\n\n\n\n<li>You are ready to open the custom analyser with only one click<\/li>\n<\/ul>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"507\" height=\"203\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-new-icon.png\" alt=\"\" class=\"wp-image-4283 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-new-icon.png 507w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/External-tools-manager-new-icon-300x120.png 300w\" sizes=\"(max-width: 507px) 100vw, 507px\" \/><\/figure><\/div>\n\n\n\n<p>More details about External tools manager :   <a href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" data-type=\"post\" data-id=\"3706\" target=\"_blank\" rel=\"noreferrer noopener\">Click here<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Get more custom analysers or share yours<\/h2>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Custom analysers are Pbit or Xlsm files. You reach them clicking on the folder icon. You can move and share these files as you want<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"417\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-folder-icon.png\" alt=\"\" class=\"wp-image-4286 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-folder-icon.png 631w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-folder-icon-300x198.png 300w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Featured external tools<\/h2>\n\n\n\n<p>Power BI Sidetools natively includes a set of expert tools built by advanced users: <\/p>\n\n\n\n<ul>\n<li>&#8216;Power BI cleaner&#8217; by Imke Feldmann<\/li>\n\n\n\n<li>&#8216;Data God Model Auto Docs&#8217; by Chris Wagner<\/li>\n\n\n\n<li>&#8216;Bookmark Documenter&#8217; by Reid Havens<\/li>\n<\/ul>\n\n\n\n<p>Big up to these valuable people who share their tools for free with the community !!!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create your own custom analyser<\/h2>\n\n\n\n<p>The easiest way to create a custom analyser is modifying an existing one.<\/p>\n\n\n\n<ul>\n<li>Open a custom analyser with Sidetools<\/li>\n\n\n\n<li>Modify it\n<ul>\n<li>A best practice is to reference existing queries so it will be easier for you to update them with copy\/paste<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>In order to save it: \n<ul>\n<li>select &#8216;File \/ Export \/ Power BI template&#8217;<\/li>\n\n\n\n<li>in &#8216;Export a template&#8217; window, fill in the template description and click &#8216;Ok&#8217; button<\/li>\n\n\n\n<li>name your Pbit file and click on &#8216;Save&#8217; button. Please be aware files published by Sidetools are overwritten each time a custom analyser is run. So use different names to save your own custom analyser <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>It&#8217;s not necessary to save the &#8216;Untitled&#8217; report<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Use more resource files<\/h3>\n\n\n\n<p>Some resource files  are not loaded in the published example but you can see the list of available files in the &#8216;PBI Sidetools resource files&#8217; query. For example, if you want to load the theme used by the Pbix, follow these steps in Power Query:<\/p>\n\n\n\n<ul>\n<li>Select the &#8216;Source folder&#8217; query<\/li>\n\n\n\n<li>Copy the source folder path in the clipboard<\/li>\n\n\n\n<li>In the &#8216;Home&#8217; ribbon of the desktop, click on the &#8216;New source&#8217; button<\/li>\n\n\n\n<li>Select a source type (&#8216;Json&#8217; for our example)<\/li>\n\n\n\n<li>When the file explorer window appears, paste the source folder path into the path selector at the top of the window and type &#8216;Enter&#8217; key<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Look-for-resource-files.png\" alt=\"\" class=\"wp-image-4295\" width=\"513\" height=\"71\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Look-for-resource-files.png 711w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Look-for-resource-files-300x41.png 300w\" sizes=\"(max-width: 513px) 100vw, 513px\" \/><\/figure><\/div>\n\n\n<ul>\n<li>Navigate to this sub folder : &#8216;Unzipped report\\Report\\StaticResources\\SharedResources\\BaseThemes&#8217; <\/li>\n\n\n\n<li>Select the Json file<\/li>\n\n\n\n<li>Modify the &#8216;Source&#8217; step replacing the hard coded path with the &#8216;Source folder&#8217; query:\n<ul>\n<li><code>= Json.Document(File.Contents(#\"Source folder\" &amp; \"Unzipped report\\Report\\StaticResources\\SharedResources\\BaseThemes<\/code>\\&#8230;<code>\"))<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Then you can parse the Json<\/li>\n\n\n\n<li>I recommend opening the Json file in &#8216;VS Code&#8217; in order to understand its structure. The extension &#8216;<a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ChaunceyKiwi.json-tree-view\" data-type=\"URL\" data-id=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ChaunceyKiwi.json-tree-view\" target=\"_blank\" rel=\"noreferrer noopener\">JSON Tree View<\/a>&#8216; from ChaunceyKiwi is highly recommended also<\/li>\n<\/ul>\n\n\n\n<p>When opening a csv file, don&#8217;t forget to use a relative path and to set the &#8216;QuoteStyle&#8217; parameter to csv :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DMV_Columns = Csv.Document(File.Contents(<strong>#\"Source folder\"<\/strong> &amp; \"DMVs\\TMSCHEMA_COLUMNS.csv\"),\n                                        &#91;Delimiter=\"#(tab)\", Encoding=1200, <strong>QuoteStyle=QuoteStyle.Csv<\/strong>]),<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Exported files<\/h2>\n\n\n\n<p>Exported files can be grouped in several categories:<\/p>\n\n\n\n<ul>\n<li><strong>General information<\/strong> like Pbix file size and path, your Power BI version and the one available for download. Some information is provided with the help of the fantastic <a href=\"https:\/\/pbi.tools\/\" data-type=\"URL\" data-id=\"https:\/\/pbi.tools\/\" target=\"_blank\" rel=\"noreferrer noopener\">PBI Tools<\/a> from Mathias Thierbach.<\/li>\n\n\n\n<li><strong>Model<\/strong> like the &#8216;Model.bim&#8217; file ready to be parsed. &#8216;M expressions.csv&#8217; contains all queries.<\/li>\n\n\n\n<li><strong>Layout <\/strong>like the visualisation layer within &#8216;layout&#8217; Json file or even a more readable version. But there is also a simplistic list of visuals with their visibility status plus their coordinates, sizes and page. <\/li>\n\n\n\n<li><strong>DMVs <\/strong>like &#8216;TMSCHEMA_MEASURES.csv&#8217; containing measures defined within the Pbix with their description, expression, display folder, visibility status, format string, &#8230; More DMVs will be added on request.<\/li>\n\n\n\n<li><strong>Unzipped report<\/strong> files. Sidetools unzips the Pbix and exposes its files. This way, for example, you may calculate how many bytes are used by images or custom visuals. You can also parse theme, metadata or settings. The &#8216;DataModel&#8217; file is not exposed because it might be huge as it contains data <\/li>\n<\/ul>\n\n\n\n<p>If you need more files, please submit an issue in <a href=\"https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\/issues\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\/issues\" rel=\"noreferrer noopener\">GitHub<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Test version<\/h2>\n\n\n\n<p>The test version is available here :   <a href=\"https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\/releases\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\/releases<\/a><\/p>\n\n\n\n<p>Select the first asset and unzip it any folder you want. You may have different versions in different folders. Each version has it&#8217;s own settings.<\/p>\n\n\n\n<p>Open the report you want to analyse in Power BI desktop.<\/p>\n\n\n\n<p>Execute &#8216;Power BI Sidetools.exe&#8217; from the unzipped folder. Sidetools will connect automatically to the opened Pbix. If multiple Pbix are opened, Sidetools will let you select the one you want to connect.<\/p>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>In case the test version doesn&#8217;t come with the updated version of a custom analyser you want to test, you can drop the new version in &#8216;C:\\Users\\<em>username<\/em>\\Documents\\Power BI Sidetools\\Other tools\\Custom analyser&#8217; folder<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"417\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-folder-icon-1.png\" alt=\"\" class=\"wp-image-4287 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-folder-icon-1.png 631w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-folder-icon-1-300x198.png 300w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/figure><\/div>\n\n\n\n<p>If you create an icon in desktop&#8217;s &#8216;External tools&#8217; ribbon from the test version, be aware they will only open the test version you are testing. A good practice is to set an icon name beginning by &#8216;Test&#8217;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Under the hood<\/h2>\n\n\n\n<p>What is happening when you run a custom analyser ?<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pbit custom analyser<\/h3>\n\n\n\n<p>When you click on &#8216;Process&#8217; button while a Pbit is selected, Power BI Sidetools follows these steps :<\/p>\n\n\n\n<ul>\n<li>create resource files from the Pbix using  <a href=\"https:\/\/pbi.tools\/\" data-type=\"URL\" data-id=\"https:\/\/pbi.tools\/\" target=\"_blank\" rel=\"noreferrer noopener\">PBI Tools<\/a> from Mathias Thierbach <\/li>\n\n\n\n<li>create resource files from the Pbix :\n<ul>\n<li>unzip the Pbix file<\/li>\n\n\n\n<li>run several DMVs and export them to csv files<\/li>\n\n\n\n<li>export the Model.bim file and &#8216;M expressions.csv&#8217; file<\/li>\n\n\n\n<li>export the &#8216;Layout&#8217; file and more readable versions of the layout (&#8216;Readable layout.json&#8217; and &#8216;Visuals visibility.csv&#8217;)<\/li>\n\n\n\n<li>create resource files from the Pbix using Sidetools&#8217; internal features<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>create a file listing all available resource files (&#8216;Files and folders.csv&#8217;)<\/li>\n<\/ul>\n\n\n\n<ul>\n<li>extract the selected custom analyser Pbit with PBI Tools<\/li>\n\n\n\n<li>modify the custom analyser Pbit file in order to update the &#8216;Source folder&#8217; query<\/li>\n\n\n\n<li>compile the selected custom analyser Pbit with PBI Tools<\/li>\n\n\n\n<li>open the selected custom analyser<\/li>\n\n\n\n<li>wait for selected custom analyser refresh<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Xlsm custom analyser<\/h3>\n\n\n\n<p>The Xlsm custom analyser example is available if you prefer to create an Excel custom analyser<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\t\t\t<div class=\"wp-block-uagb-post-carousel uagb-post-grid  uagb-post__image-position-top uagb-post__image-enabled uagb-block-0218724d     uagb-post__arrow-outside uagb-slick-carousel uagb-post__items uagb-post__columns-3 is-carousel uagb-post__columns-tablet-2 uagb-post__columns-mobile-1\" data-total=\"1\" style=\"\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"592\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1024x592.png\" class=\"attachment-large size-large\" alt=\"DAX debugger\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1024x592.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-300x173.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-768x444.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1320x763.png 1320w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger.png 1452w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">DAX debugger in Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>DAX debugger is meant to help Power BI report developers displaying sample data from a&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"817\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager.png\" class=\"attachment-large size-large\" alt=\"External tools manager\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager.png 817w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager-300x182.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager-768x465.png 768w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Manage your external tools easily with Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Since the Power BI team allowed to launch external tools from the Power BI desktop&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"414\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1024x414.png\" class=\"attachment-large size-large\" alt=\"Export to Excel\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1024x414.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-300x121.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-768x311.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1536x621.png 1536w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1320x534.png 1320w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel.png 1854w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Easily export to Excel with Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>While working in Power BI desktop, we often need to export to Excel some data&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"209\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-1024x209.png\" class=\"attachment-large size-large\" alt=\"search\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-1024x209.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-300x61.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-768x156.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6.png 1286w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Powerful text and file search in Visual Studio Code<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>As Power BI Sidetools creates files from your report, you are able to search through&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"294\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-1024x294.png\" class=\"attachment-large size-large\" alt=\"Visual Studio Code\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-1024x294.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-300x86.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-768x220.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5.png 1269w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Compare DAX and M formulas in Visual Studio Code<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Compare DAX and M formulas in Visual Studio Code is really easy with the help&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t","protected":false},"excerpt":{"rendered":"<p>With &#8216;Custom analyser&#8217; feature, Power BI Sidetools users can use external tools built by the community.They may create their own Power BI external tool. The process is incredibly quick and simple. An icon can be added in the desktop ribbon so your brand new tool can be run in one click. Tools can be built&#8230;<\/p>\n","protected":false},"author":2,"featured_media":4338,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[81,75],"tags":[82,74,73],"uagb_featured_image_src":{"full":["https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png",674,193,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-150x150.png",150,150,true],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-300x86.png",300,86,true],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png",674,193,false],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png",674,193,false],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png",674,193,false],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png",674,193,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png",674,193,false]},"uagb_author_info":{"display_name":"Didier TERRIEN","author_link":"https:\/\/thebipower.fr\/index.php\/author\/masterpower\/"},"uagb_comment_info":0,"uagb_excerpt":"With &#8216;Custom analyser&#8217; feature, Power BI Sidetools users can use external tools built by the community.They may create their own Power BI external tool. The process is incredibly quick and simple. An icon can be added in the desktop ribbon so your brand new tool can be run in one click. Tools can be built...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/4244"}],"collection":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/comments?post=4244"}],"version-history":[{"count":40,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/4244\/revisions"}],"predecessor-version":[{"id":4343,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/4244\/revisions\/4343"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/4338"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=4244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/categories?post=4244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/tags?post=4244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}