{"id":1224,"date":"2020-06-14T20:14:03","date_gmt":"2020-06-14T20:14:03","guid":{"rendered":"http:\/\/bi.unija.com\/en\/?p=1224"},"modified":"2020-08-17T13:50:10","modified_gmt":"2020-08-17T13:50:10","slug":"preparing-work-environment-in-power-bi-desktop","status":"publish","type":"post","link":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/","title":{"rendered":"Preparing Work Environment in Power BI Desktop"},"content":{"rendered":"

This article covers best practices for setting Power BI Desktop version 2.76.5678.782 (January\u00a02020).<\/em><\/p>\n

Power BI consists of Power BI Desktop and PowerBI.com. Every Power Bi project starts in Power BI Desktop. Properly setting up our work environment is crucial. In this article we’ll cover all the important settings in Power BI Desktop. Settings are managed in File > Options\u00a0and\u00a0settings > Options<\/strong>.\u00a0This opens a new window. Settings are ordered in two groups: Global <\/strong>and Current file<\/strong>. Some Global<\/strong> settings are repeated in Current file<\/strong>, since they can also be applied for current file only. We’ll mark there settings throughout the article.<\/p>\n

\"C:\\Users\\brankat\\AppData\\Local\\Microsoft\\Windows\\INetCache\\Content.MSO\\1C85E6B8.tmp\"Settings come in two groups: Global and Current file.<\/em><\/p>\n

Data\u00a0Load\u00a0(Global)<\/h1>\n

Auto\u00a0date\/time\u00a0for\u00a0new\u00a0files<\/h2>\n

We turn this setting off. If left turned on, Power BI will create hidden calendar table for every date and time filed in our data. For example: we have a table with three date columns called Date, OrderDate and PaymentDate. Power BI will create three separate hidden calendar tables, which will slow down our model and user experience.<\/p>\n

Data\u00a0Load (Current\u00a0file)<\/h1>\n

Auto\u00a0date\/time<\/h2>\n

We also turn off the setting here. We don’t want any redundant calendar tables that would slow down our model.<\/p>\n

Autodetect\u00a0new\u00a0relationships\u00a0after\u00a0data is\u00a0loaded<\/h2>\n

We turn this setting off. Automatically generated relationships are often incorrect. We want full control over building relationships in our data model.<\/p>\n

Power\u00a0Query\u00a0Editor<\/h1>\n

Display\u00a0the\u00a0formula bar<\/h2>\n

We turn this setting on. This way, we can see, enter and edit formulas. Every transformation in Power Query Editor is stored as a step in the Applied Steps<\/em> window. Steps are written in M language. We can see and edit the M formulas in the formula bar. We could also edit the formula in Advanced Editor<\/em> by clicking View\u00a0>\u00a0Advanced\u00a0Editor<\/strong>.<\/p>\n

Enable\u00a0M\u00a0Intellisense<\/h2>\n

We turn this setting on. This will provide us with helpful suggestions while writing formulas or table names.<\/p>\n

Privacy<\/h1>\n

We always set this to Always\u00a0ignore\u00a0Privacy\u00a0Level\u00a0Settings<\/strong>. Default setting Combine data\u00a0according\u00a0to\u00a0file’s\u00a0Privacy\u00a0Level\u00a0Settings <\/strong>could cause a problem. If we have data in files with different privacy settings, we can end up with queries that don’t see each other, hence we can’t merge or append them.<\/p>\n

“”<\/strong>\u00a0Microsoft recommends using the default setting Combine data according to file’s Privacy Level Settings<\/strong>, but this can cause difficulties in practice.<\/p>\n

Regional\u00a0Settings<\/h1>\n

Model\u00a0language<\/h2>\n

Here we can set the language or region that Power BI uses for reading data. Selected language will affect the date and the decimal separator. In case of working with data stored in European format, we have to be cautious to set the correct language or region even before starting the project.<\/p>\n

Updates<\/h1>\n

Power BI comes in two versions, that differ in the way the update. Power BI application, which we find on the homepage of Power BI, will update automatically. We can’t turn the automatic updates off in this version, we can only choose not to be notified about the updates. Updates are usually released on a monthly basis and are occasionally followed by an update fix. New updates are often not production ready and can cause problems in active Power BI projects. This is why we usually don’t want automatic updates. We can avoid them by using the second version of Power BI: instead of choosing the app on the Power BI homepage, we opt for installation file. We can recognize it by the filename extension .exe<\/em>. We decide when we want to update in this version of the tool, which gives us greater control.<\/p>\n

Preview\u00a0features<\/h1>\n

Here we find latest functionalities, added to Power BI. We usually want to use all the added functionalities, except for regionally specific ones. Options in this section will depend on version of Power BI Desktop and will change with time.<\/p>\n

\"C:\\Users\\brankat\\AppData\\Local\\Microsoft\\Windows\\INetCache\\Content.MSO\\C43DA832.tmp\"<\/p>\n

Preview\u00a0features setting: we select all the functionalities, except for regionally specific. This list of options will change with time, as new functionalities are added. (Functionalities in the image above are from January 2020, version 2.76.5678.782).<\/em><\/p>\n

Auto\u00a0recovery\u00a0(Global)<\/h1>\n

We keep the default setting on, so our work is saved and can be restored in the case of technical issues or power outage. Default setting is 10 minutes but can be changed to any other value.<\/p>\n

Auto\u00a0recovery\u00a0(Current file)<\/h1>\n

Disable\u00a0auto\u00a0recovery\u00a0for\u00a0this\u00a0file<\/h2>\n

We turn this on when we’re working with large files. Auto recovery would slow down the performance.<\/p>\n

Report\u00a0settings\u00a0(Current file)<\/p>\n

Export\u00a0data<\/h2>\n

Power\u00a0BI allows users to extract data from reports and save it to a file. For example, they can export data from a chart to a table and save it locally. This is why we disable the option to export data from reports when we’re working with sensitive data.<\/p>\n

Saving Settings as a Template<\/h1>\n

Good practice is to create a template and use it for every new Power BI project. This way we save time and make sure our model works optimally, without redundant functionalities that would slow down our workflow or user experience.<\/p>\n","protected":false},"excerpt":{"rendered":"

This article covers best practices for setting Power BI Desktop version 2.76.5678.782 (January\u00a02020). Power BI consists of Power BI Desktop and PowerBI.com. Every Power Bi project starts in Power BI Desktop. Properly setting up our work environment is crucial. In<\/p>\n","protected":false},"author":5,"featured_media":1214,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[8],"class_list":["post-1224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-basic","tag-power-bi"],"acf":[],"yoast_head":"\nPreparing Work Environment in Power BI Desktop - Unija Smart<\/title>\n<meta name=\"description\" content=\"Properly setting up our work environment is crucial. In this article we'll cover all the important settings in Power BI Desktop.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Preparing Work Environment in Power BI Desktop - Unija Smart\" \/>\n<meta property=\"og:description\" content=\"Properly setting up our work environment is crucial. In this article we'll cover all the important settings in Power BI Desktop.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"Bi Unija\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-14T20:14:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-17T13:50:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/06\/ENG2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Branka Trifunovi\u0107\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Branka Trifunovi\u0107\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/\",\"url\":\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/\",\"name\":\"Preparing Work Environment in Power BI Desktop - Unija Smart\",\"isPartOf\":{\"@id\":\"https:\/\/bi.unija.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/06\/ENG2.jpg\",\"datePublished\":\"2020-06-14T20:14:03+00:00\",\"dateModified\":\"2020-08-17T13:50:10+00:00\",\"author\":{\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10\"},\"description\":\"Properly setting up our work environment is crucial. In this article we'll cover all the important settings in Power BI Desktop.\",\"breadcrumb\":{\"@id\":\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#primaryimage\",\"url\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/06\/ENG2.jpg\",\"contentUrl\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/06\/ENG2.jpg\",\"width\":720,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bi.unija.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Preparing Work Environment in Power BI Desktop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bi.unija.com\/en\/#website\",\"url\":\"https:\/\/bi.unija.com\/en\/\",\"name\":\"Bi Unija\",\"description\":\"Just another Bi site\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bi.unija.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10\",\"name\":\"Branka Trifunovi\u0107\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g\",\"caption\":\"Branka Trifunovi\u0107\"},\"url\":\"https:\/\/bi.unija.com\/en\/author\/branka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Preparing Work Environment in Power BI Desktop - Unija Smart","description":"Properly setting up our work environment is crucial. In this article we'll cover all the important settings in Power BI Desktop.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Preparing Work Environment in Power BI Desktop - Unija Smart","og_description":"Properly setting up our work environment is crucial. In this article we'll cover all the important settings in Power BI Desktop.","og_url":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/","og_site_name":"Bi Unija","article_published_time":"2020-06-14T20:14:03+00:00","article_modified_time":"2020-08-17T13:50:10+00:00","og_image":[{"width":720,"height":480,"url":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/06\/ENG2.jpg","type":"image\/jpeg"}],"author":"Branka Trifunovi\u0107","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Branka Trifunovi\u0107","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/","url":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/","name":"Preparing Work Environment in Power BI Desktop - Unija Smart","isPartOf":{"@id":"https:\/\/bi.unija.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#primaryimage"},"image":{"@id":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#primaryimage"},"thumbnailUrl":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/06\/ENG2.jpg","datePublished":"2020-06-14T20:14:03+00:00","dateModified":"2020-08-17T13:50:10+00:00","author":{"@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10"},"description":"Properly setting up our work environment is crucial. In this article we'll cover all the important settings in Power BI Desktop.","breadcrumb":{"@id":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#primaryimage","url":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/06\/ENG2.jpg","contentUrl":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/06\/ENG2.jpg","width":720,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/bi.unija.com\/en\/preparing-work-environment-in-power-bi-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bi.unija.com\/en\/"},{"@type":"ListItem","position":2,"name":"Preparing Work Environment in Power BI Desktop"}]},{"@type":"WebSite","@id":"https:\/\/bi.unija.com\/en\/#website","url":"https:\/\/bi.unija.com\/en\/","name":"Bi Unija","description":"Just another Bi site","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bi.unija.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10","name":"Branka Trifunovi\u0107","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g","caption":"Branka Trifunovi\u0107"},"url":"https:\/\/bi.unija.com\/en\/author\/branka\/"}]}},"_links":{"self":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1224"}],"collection":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/comments?post=1224"}],"version-history":[{"count":4,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1224\/revisions"}],"predecessor-version":[{"id":1601,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1224\/revisions\/1601"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/media\/1214"}],"wp:attachment":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/media?parent=1224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/categories?post=1224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/tags?post=1224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}