{"id":1509,"date":"2019-02-01T16:22:22","date_gmt":"2019-02-01T16:22:22","guid":{"rendered":"http:\/\/didierterrien.cf\/?page_id=1509"},"modified":"2023-07-05T12:08:00","modified_gmt":"2023-07-05T10:08:00","slug":"tools","status":"publish","type":"page","link":"https:\/\/thebipower.fr\/index.php\/tools\/","title":{"rendered":"Tools"},"content":{"rendered":"\n

Powerful DAX & Power Query editor<\/h2>\n\n\n\n

If you feel not very comfortable with DAX & Power Query editor, have a look at Visual studio code<\/strong>. It provides very efficient and powerful text functions including auto completion, Intellisense, advanced search & replace, …<\/p>\n\n\n\n

You will edit your code in different tabs and keywords are coloured according to the language you use.<\/p>\n\n\n\n

Much more extensions are available to edit other codes. For instance, you can edit C++, HTML, batch code. The list is long.<\/p>\n\n\n\n

How to<\/h3>\n\n\n\n
\"tools\"<\/figure>
\n
  1. First, download Visual studio code : https:\/\/code.visualstudio.com\/<\/a><\/li><\/ol>\n<\/div><\/div>\n\n\n\n
    <\/div>\n\n\n\n
    \"tools\"<\/figure>
    \n

    2. And add DAX and Power Query extensions <\/p>\n<\/div><\/div>\n\n\n\n

    <\/div>\n\n\n\n
    \"tools\"<\/figure>
    \n

    3. Then enjoy <\/p>\n<\/div><\/div>\n\n\n\n

    Additionaly, you will be able to save your favorite code and to create workspaces. <\/p>\n\n\n\n

    Though you will need to copy and paste your code from Power Query to Visual studio code and vice versa, you will save a lot of time. Above all, you will not need to close and open the advanced editor to check other pieces of code.<\/p>\n\n\n\n

    Power BI Sidetools can create files automatically and then open Visual Studio Code : https:\/\/thebipower.fr\/index.php\/power-bi-sidetools\/<\/a><\/p>\n\n\n\n

    Phil Seamark provides a powerful solution to connect Visual Studio Code to your model : https:\/\/dax.tips\/2020\/07\/09\/using-visual-studio-code-with-power-bi\/<\/a><\/p>\n\n\n\n

    In conclusion, give it a try ! It’s worthy.<\/p>\n\n\n\n

    \n\n\n\n

    Adventureworks pbix file<\/h2>\n\n\n\n

    The Adventure Works company represents a bicycle manufacturer that sells bicycles and accessories to global markets. The company has their data warehouse data stored in an Azure SQL Database.

    Download the Adventureworks pbix file from Microsoft docs :     https:\/\/learn.microsoft.com\/en-us\/dax\/dax-sample-model<\/a><\/p>\n\n\n\n

    \n\n\n\n

    Contoso pbix file<\/h2>\n\n\n\n

    The Contoso BI Demo dataset is used to demonstrate DW\/BI functionalities across the entire Microsoft Office product family. This dataset includes C-level, sales\/marketing, IT, and common finance scenarios for the retail industry and support map integration. In addition, this dataset offers large volumes of transactions from OLTP and well-structured aggregations from OLAP, along with reference and dimension data.

    Download the Contoso pbix file from Microsoft :     https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=46801<\/a><\/p>\n\n\n\n

    \n\n\n\n

    Sales & Returns sample pbix file<\/h2>\n\n\n\n

    Power BI report designers Miguel Myers and Chris Hamill created the Sales & Returns .pbix file to demonstrate many new features in Power BI, including buttons, drill through, conditional formatting, what-if, and customized tooltips.The scenario for this report is a company that sells Microsoft-themed skateboards. They want to see the state of their sales and returns, and analyze how they should modify their operations.

    Download the Sales & Returns pbix file from Microsoft :     https:\/\/docs.microsoft.com\/fr-fr\/power-bi\/create-reports\/sample-datasets#sales–returns-sample-pbix-file<\/a><\/p>\n\n\n\n

    \n\n\n\n

    Tabular editor<\/h2>\n\n\n\n

    Tabular editor website : https:\/\/github.com\/TabularEditor\/TabularEditor<\/a><\/p>\n\n\n\n

    \n\n\n\n

    Developper tools<\/h2>\n\n\n\n

    BI Developer Extensions (previously BIDS Helper) <\/h3>\n\n\n\n

    A Visual Studio extension that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT).
    https:\/\/bideveloperextensions.github.io\/<\/a><\/p>\n\n\n\n

    \n\n\n\n

    SQL Server Analysis Services Tabular Protocol<\/h3>\n\n\n\n

    Documentation of the Microsoft SSAS APIS
    https:\/\/sqlprotocoldoc.blob.core.windows.net\/productionsqlarchives\/MS-SSAS-T\/%5BMS-SSAS-T%5D.pdf<\/a><\/p>\n\n\n\n

    <\/div>\n\n\n\n\t\t\t
    \n\n\t\t\t\t\t\t\t\t\t\t\t\t
    \t\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\"Custom\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tCustom analyser<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
    \n\t\t\t\t\t

    With ‘Custom analyser’ feature, Power BI Sidetools users can use external tools built by the…\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tRead 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
    \t\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\"DAX\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tDAX debugger in Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
    \n\t\t\t\t\t

    DAX debugger is meant to help Power BI report developers displaying sample data from a…\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tRead 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
    \t\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\"External\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tManage your external tools easily with Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
    \n\t\t\t\t\t

    Since the Power BI team allowed to launch external tools from the Power BI desktop…\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tRead 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
    \t\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\"Export\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tEasily export to Excel with Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
    \n\t\t\t\t\t

    While working in Power BI desktop, we often need to export to Excel some data…\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tRead 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
    \t\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\"search\"\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tPowerful text and file search in Visual Studio Code<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
    \n\t\t\t\t\t

    As Power BI Sidetools creates files from your report, you are able to search through…\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tRead 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
    \t\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\"Visual\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tCompare DAX and M formulas in Visual Studio Code<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
    \n\t\t\t\t\t

    Compare DAX and M formulas in Visual Studio Code is really easy with the help…\t\t\t\t<\/div>\n\t\t\t\t\t\t

    \n\t\t\t\tRead 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":"

    Powerful DAX & Power Query editor If you feel not very comfortable with DAX & Power Query editor, have a look at Visual studio code. It provides very efficient and powerful text functions including auto completion, Intellisense, advanced search & replace, … You will edit your code in different tabs and keywords are coloured according to…<\/p>\n","protected":false},"author":1,"featured_media":0,"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":"","_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":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false},"uagb_author_info":{"display_name":"Didier Terrien","author_link":"https:\/\/thebipower.fr\/index.php\/author\/ensemble54\/"},"uagb_comment_info":0,"uagb_excerpt":"Powerful DAX & Power Query editor If you feel not very comfortable with DAX & Power Query editor, have a look at Visual studio code. It provides very efficient and powerful text functions including auto completion, Intellisense, advanced search & replace, … You will edit your code in different tabs and keywords are coloured according to...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/1509"}],"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=1509"}],"version-history":[{"count":14,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/1509\/revisions"}],"predecessor-version":[{"id":4477,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/pages\/1509\/revisions\/4477"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=1509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}