{"id":35,"date":"2019-01-19T14:29:26","date_gmt":"2019-01-19T14:29:26","guid":{"rendered":"https:\/\/didier-terrien.000webhostapp.com\/?page_id=7"},"modified":"2021-03-25T15:32:57","modified_gmt":"2021-03-25T14:32:57","slug":"power-bi-assistant","status":"publish","type":"page","link":"https:\/\/thebipower.fr\/index.php\/power-bi-assistant\/","title":{"rendered":"Power BI assistant"},"content":{"rendered":"\n<p>Power BI assistant project is meant to help Power BI desktop developpers providing functions which are not included natively.<\/p>\n\n\n\n<p>A Power BI report is provided to connect and analyze another Power BI report.<br><\/p>\n\n\n\n<h2 class=\"styled-heading-3-syhj wp-block-heading\">Some features included in Power BI assistant<\/h2>\n\n\n\n<ul><li>List all DAX formulas and allow to search text within or export to Excel<\/li><li>List links between measures\/columns (ie measures used by other measures)<\/li><li>Compare measures between different versions of the same report<\/li><li>Get the memory used by tables\/columns<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Bonuses<\/h2>\n\n\n\n<ul><li>Automatic export to Excel<\/li><li>Get source files names and folder<\/li><li>Pass parameters to R script<\/li><\/ul>\n\n\n\n<p>Download the report :   <a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/didierterrien\/Power-BI-assistant\/\" target=\"_blank\">Power BI assistant in GitHub<\/a><\/p>\n\n\n\n<p>Very good tutorial of some functions by Ruth Pozuelo (Curbal) :   <a rel=\"noreferrer noopener\" href=\"https:\/\/www.youtube.com\/watch?v=Jg7n_cLjtTw&amp;feature=youtu.be\" target=\"_blank\">Compare two Power BI reports in YouTube<\/a><\/p>\n\n\n\n<p>In case you need some troubleshooting :  <a href=\"https:\/\/thebipower.fr\/index.php\/2019\/02\/18\/power-bi-assistant-troubleshooting\/\" class=\"rank-math-link\">Power BI assistant troubleshooting<\/a><\/p>\n\n\n\n<p>You may have a look at this other project :  <a href=\"https:\/\/thebipower.fr\/index.php\/power-bi-sidetools\/\" class=\"rank-math-link\">Power BI Sidetools<\/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-b4d81b5c     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=\"6\" 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 assistant project is meant to help Power BI desktop developpers providing functions which are not included natively. A Power BI report is provided to connect and analyze another Power BI report. Some features included in Power BI assistant List all DAX formulas and allow to search text within or export to Excel List&#8230;<\/p>\n","protected":false},"author":1,"featured_media":3605,"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":"","_kad_post_layout":"right","_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\/2020\/11\/Power-BI-assistant-large.png",502,206,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/11\/Power-BI-assistant-large-150x150.png",150,150,true],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/11\/Power-BI-assistant-large-300x123.png",300,123,true],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/11\/Power-BI-assistant-large.png",502,206,false],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/11\/Power-BI-assistant-large.png",502,206,false],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/11\/Power-BI-assistant-large.png",502,206,false],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/11\/Power-BI-assistant-large.png",502,206,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/11\/Power-BI-assistant-large.png",502,206,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 assistant project is meant to help Power BI desktop developpers providing functions which are not included natively. A Power BI report is provided to connect and analyze another Power BI report. Some features included in Power BI assistant List all DAX formulas and allow to search text within or export to Excel List...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/35"}],"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=35"}],"version-history":[{"count":14,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/35\/revisions"}],"predecessor-version":[{"id":3696,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/35\/revisions\/3696"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/3605"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}