{"id":3283,"date":"2020-08-17T17:36:39","date_gmt":"2020-08-17T15:36:39","guid":{"rendered":"https:\/\/thebipower.fr\/?page_id=3283"},"modified":"2023-04-15T12:12:55","modified_gmt":"2023-04-15T10:12:55","slug":"power-bi-sidetools","status":"publish","type":"page","link":"https:\/\/thebipower.fr\/index.php\/power-bi-sidetools\/","title":{"rendered":"Power BI Sidetools, a free external tool"},"content":{"rendered":"\n<p>Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop. <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Power BI Sidetools - All Kinds of AWESOME (with Didier Terrien)\" width=\"720\" height=\"405\" src=\"https:\/\/www.youtube.com\/embed\/z04v4vy7T50?start=3526&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\">Many thanks to Reid Havens for helping me to showcase Power BI Sidetools<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">DAX generator<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"668\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/09\/DAX-generator-1024x668.png\" alt=\"Power BI Sidetools\" class=\"wp-image-4175\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/09\/DAX-generator-1024x668.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/09\/DAX-generator-300x196.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/09\/DAX-generator-768x501.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/09\/DAX-generator.png 1041w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You can use a DAX template created by an expert, adapt it to your model using the model browser and then generate a DAX expression. This expression can be formatted and created by the tool into your model. Then you may even debug your DAX expression with DAX debugger.<br>     <a href=\"https:\/\/thebipower.fr\/index.php\/dax-generator\/\" data-type=\"URL\" data-id=\"https:\/\/thebipower.fr\/index.php\/dax-generator\/\">DAX generator documentation page<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">DAX debugger<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"592\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1024x592.png\" alt=\"DAX debugger\" class=\"wp-image-3834\" 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\" \/><\/figure>\n\n\n\n<p>DAX debugger is meant to help Power BI report developers displaying sample data from a DAX formula. Measures, calculated columns and calculated tables can be debugged very easily without impact on calculation performance. An advanced mode allows user to fine tune how data is displayed :<br>   <a href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" class=\"rank-math-link\">https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"DAX-parser\">DAX parser<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"606\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image-2-1024x606.png\" alt=\"\" class=\"wp-image-3950\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image-2-1024x606.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image-2-300x178.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image-2-768x454.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image-2-1320x781.png 1320w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image-2.png 1362w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:17px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Visualise your DAX expressions in a tree. Expand \/ collapse nodes and get help clicking on functions.<br>I can share the library to be used in your tools.<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 30%\"><div class=\"wp-block-media-text__content\">\n<p>Type measure, calculated column, calculated table name in DAX debugger field and select DAX parser in the menu.<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"488\" height=\"201\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image.png\" alt=\"\" class=\"wp-image-3945 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image.png 488w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/06\/image-300x124.png 300w\" sizes=\"(max-width: 488px) 100vw, 488px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Easily export data to Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"414\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1024x414.png\" alt=\"Export to Excel\" class=\"wp-image-3532\" 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\" \/><\/figure>\n\n\n\n<p>Export your Power BI desktop data into Excel with only one click. Then you can setup pivot tables, add theme &amp; graphics, macros and do whatever you want. You can even generate a paginated report. Next time you will open this file from Power BI Sidetools, it will be refreshed and you will keep all the setup you did previously. Super quick and super efficient in few steps :<br>   <a href=\"https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\">https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-theme-palette-2-color has-css-opacity has-theme-palette-2-background-color has-background is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"pbi-to-files\">Transfer DAX and M formulas to files <\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"207\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/Transfer-DAX-and-M-formulas-to-files-1.png\" alt=\"Power BI Toolbox\" class=\"wp-image-3288\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/Transfer-DAX-and-M-formulas-to-files-1.png 771w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/Transfer-DAX-and-M-formulas-to-files-1-300x81.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/Transfer-DAX-and-M-formulas-to-files-1-768x206.png 768w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/figure><\/div>\n\n\n<p>With just one click, you can transfer M and DAX formulas in a folder named like your report. The very first use case will be probably to save your different versions in backups. Right click on your report name and select &#8220;Send to\/Compressed folder&#8221;.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">View your DAX and M formulas in Visual Studio Code<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"333\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/View-your-DAX-and-M-formulas-in-Visual-Studio-Code-1024x333.png\" alt=\"Power BI Toolbox\" class=\"wp-image-3292\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/View-your-DAX-and-M-formulas-in-Visual-Studio-Code-1024x333.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/View-your-DAX-and-M-formulas-in-Visual-Studio-Code-300x98.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/View-your-DAX-and-M-formulas-in-Visual-Studio-Code-768x250.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/08\/View-your-DAX-and-M-formulas-in-Visual-Studio-Code.png 1276w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>With just one click, you open Visual Studio code to view your DAX and M formulas.<\/p>\n\n\n\n<p>Visual Studio Code is a lightweight but very powerful free source code editor created by Microsoft. Its functionalities are really amazing :<\/p>\n\n\n\n<ul>\n<li>Powerful editing capabilities including advanced search and replace across multiple files, compare files, &#8230;<\/li>\n\n\n\n<li>Flexibility splitting the editor to display multiple files simultaneously<\/li>\n\n\n\n<li>Themes<\/li>\n\n\n\n<li>Snippets (reuseable pieces of code)<\/li>\n\n\n\n<li>Plugins\n<ul>\n<li>syntax highlighting and\/or intellisense (DAX, M , R, Python, SQL, Json &#8230; )<\/li>\n\n\n\n<li>GIT functionalities<\/li>\n\n\n\n<li>ChatGPT<\/li>\n\n\n\n<li>Collaboration<\/li>\n\n\n\n<li>Azure management <\/li>\n\n\n\n<li>Color picker<\/li>\n\n\n\n<li>Translator<\/li>\n\n\n\n<li>Script editor<\/li>\n\n\n\n<li>File viewer (csv, binary, &#8230;)<\/li>\n\n\n\n<li>And much more &#8230; <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>Discover VSCode with videos :<\/p>\n\n\n\n<p>Visual Studio Code docs :  <a aria-label=\"Introductory Videos (opens in a new tab)\" rel=\"noreferrer noopener\" href=\"https:\/\/code.visualstudio.com\/docs\/getstarted\/introvideos#VSCode\" target=\"_blank\" class=\"rank-math-link\">Introductory Videos<\/a>   <\/p>\n\n\n\n<p>Microsoft ignite :   <a href=\"https:\/\/www.youtube.com\/watch?v=bh3Xor9Ojd4\" target=\"_blank\" aria-label=\"Empowering Ops with VS Code    (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\">Empowering Ops with VS Code   <\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-theme-palette-2-color has-css-opacity has-theme-palette-2-background-color has-background is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Setup<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Installer version<\/h3>\n\n\n\n<div class=\"wp-block-uagb-call-to-action uagb-block-e3bbcd07 wp-block-button uagb-cta__outer-wrap\"><div class=\"uagb-cta__wrap\"><p class=\"uagb-cta__desc\">Download Power BI Sidetools from it&#8217;s GitHub repository<\/p><\/div><div class=\"uagb-cta__buttons\"><a href=\"https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\" class=\"uagb-cta__button-link-wrapper wp-block-button__link\" target=\"_blank\" rel=\"noopener noreferrer\"><svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\"><path d=\"M480 352h-133.5l-45.25 45.25C289.2 409.3 273.1 416 256 416s-33.16-6.656-45.25-18.75L165.5 352H32c-17.67 0-32 14.33-32 32v96c0 17.67 14.33 32 32 32h448c17.67 0 32-14.33 32-32v-96C512 366.3 497.7 352 480 352zM432 456c-13.2 0-24-10.8-24-24c0-13.2 10.8-24 24-24s24 10.8 24 24C456 445.2 445.2 456 432 456zM233.4 374.6C239.6 380.9 247.8 384 256 384s16.38-3.125 22.62-9.375l128-128c12.49-12.5 12.49-32.75 0-45.25c-12.5-12.5-32.76-12.5-45.25 0L288 274.8V32c0-17.67-14.33-32-32-32C238.3 0 224 14.33 224 32v242.8L150.6 201.4c-12.49-12.5-32.75-12.5-45.25 0c-12.49 12.5-12.49 32.75 0 45.25L233.4 374.6z\"><\/path><\/svg>Download  <\/a><\/div><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul>\n<li>Extract files from the downloaded ZIP file and launch Setup.exe. As the software is not signed, you will get a warning window. So click on the link and click on &#8220;Execute&#8221;<\/li>\n\n\n\n<li>Download Visual Studio Code from Microsoft website :  <a aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\" href=\"https:\/\/code.visualstudio.com\/download\" target=\"_blank\">https:\/\/code.visualstudio.com\/download<\/a><\/li>\n\n\n\n<li>Install plugins in Visual Studio Code :\n<ul>\n<li>Power Query \/ M language :   <a rel=\"noreferrer noopener\" href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=PowerQuery.vscode-powerquery\" target=\"_blank\">https:\/\/marketplace.visualstudio.com\/items?itemName=PowerQuery.vscode-powerquery<\/a><\/li>\n\n\n\n<li>DAX for Power BI :   <a rel=\"noreferrer noopener\" href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=jianfajun.dax-language\" target=\"_blank\">https:\/\/marketplace.visualstudio.com\/items?itemName=jianfajun.dax-language<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Portable version<\/h3>\n\n\n\n<p>Power BI Sidetools is now portable meaning you can store it&#8217;s folder on a USB key or anywhere in your hard drive. No installation is needed. Just run &#8216;Power BI Sidetools.exe&#8217; from this folder.<\/p>\n\n\n\n<p>Sidetools is available as a portable package in Business Ops from <a href=\"https:\/\/powerbi.tips\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/powerbi.tips\/\" rel=\"noreferrer noopener\">PowerBI tips<\/a>. That&#8217;s the best user experience for installing a portable external tool :   <br>     <a href=\"https:\/\/powerbi.tips\/product\/business-ops\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/powerbi.tips\/product\/business-ops\/\" rel=\"noreferrer noopener\">https:\/\/powerbi.tips\/product\/business-ops\/<\/a> <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Contribution<\/h2>\n\n\n\n<p>Do you have comments, propositions for new functionalities, bug report ? <br>Please create an issue for problems in GitHub :  <a aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\" href=\"https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\/issues\" target=\"_blank\">https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\/issues<\/a><br>or a discussion for ideas :    <a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\/discussions\" target=\"_blank\">https:\/\/github.com\/didierterrien\/Power-BI-Sidetools\/discussions<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">It&#8217;s just a beginning &#8230;<\/h2>\n\n\n\n<p>You probably have a question right now : will it be possible to modify DAX and M formulas within Visual Studio Code ? The reply is &#8230; yes &#8230; most probably.<br>Please stay tuned to discover more functionalities coming soon. You may subscribe to to be aware of new content clicking <a aria-label=\"here (opens in a new tab)\" rel=\"noreferrer noopener\" href=\"https:\/\/thebipower.fr\/index.php\/subscribe\/\" target=\"_blank\" class=\"rank-math-link\">here<\/a>.<\/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-a2c84ad8     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\/2022\/10\/22\/custom-analyser\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"674\" height=\"193\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png\" class=\"attachment-large size-large\" alt=\"Custom analyser\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png 674w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-300x86.png 300w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/>\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\/2022\/10\/22\/custom-analyser\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Custom analyser<\/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>With &#8216;Custom analyser&#8217; feature, Power BI Sidetools users can use external tools built by the&#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\/2022\/10\/22\/custom-analyser\/\" 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\/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>Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop. DAX generator You can use a DAX template created by an expert, adapt it to your model using the model browser and then generate a DAX expression. This expression can be formatted and created&#8230;<\/p>\n","protected":false},"author":1,"featured_media":3798,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","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":"default","_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":""},"uagb_featured_image_src":{"full":["https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/03\/Power-BI-Sidetools.png",656,189,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/03\/Power-BI-Sidetools-150x150.png",150,150,true],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/03\/Power-BI-Sidetools-300x86.png",300,86,true],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/03\/Power-BI-Sidetools.png",656,189,false],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/03\/Power-BI-Sidetools.png",656,189,false],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/03\/Power-BI-Sidetools.png",656,189,false],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/03\/Power-BI-Sidetools.png",656,189,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/03\/Power-BI-Sidetools.png",656,189,false]},"uagb_author_info":{"display_name":"Didier Terrien","author_link":"https:\/\/thebipower.fr\/index.php\/author\/ensemble54\/"},"uagb_comment_info":0,"uagb_excerpt":"Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop. DAX generator You can use a DAX template created by an expert, adapt it to your model using the model browser and then generate a DAX expression. This expression can be formatted and created...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/3283"}],"collection":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/comments?post=3283"}],"version-history":[{"count":68,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/3283\/revisions"}],"predecessor-version":[{"id":4469,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/3283\/revisions\/4469"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/3798"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=3283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}