{"id":170,"date":"2018-09-07T17:56:00","date_gmt":"2018-09-07T17:56:00","guid":{"rendered":"https:\/\/www.powerbitutorial.org\/?p=170"},"modified":"2019-07-03T21:42:27","modified_gmt":"2019-07-03T21:42:27","slug":"power-bi-templates","status":"publish","type":"post","link":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/","title":{"rendered":"Power BI Templates"},"content":{"rendered":"

Power BI Templates are a huge topic, partially because different people will give you different definitions of what they consider to be a Power BI template. A Power BI Developer would say that a Power BI template is a Power BI file which contains all meta-data for a report but doesn\u2019t contain the data itself. Then, the developer could add that you can also use theme templates in Power BI to apply colour schemes to your Power BI reports.<\/p>\n

On the other hand, a Power BI business user would say that a Power BI template is an example of a Power BI application. An example of a report which you might use to start not from scratch when trying to think of a sales or financial forecast dashboard. You can change, improve and tailor such a template to the needs of your business.<\/p>\n

Below, we will discuss all the 3 definitions of Power BI templates.<\/p>\n

Creating Templates in Power BI Desktop<\/h3>\n

Firstly, let\u2019s consider Power BI template files from a BI developer perspective. We will go through a short tutorial to explain the concept. To follow the steps below, you may use any of your Power BI Desktop files. A better choice would be a file which uses parameters, or a file connected to an SQL data source. You may also use the file attached to this article: \u201cAdventureWorks.pbix\u201d. This file has one data source connected to a popular Microsoft SQL Server database \u201cAdventure Works\u201d which is often used for demo purposes.<\/p>\n

Before we start, please look attentively at the tab \u201cReport\u201d in Power BI Desktop:<\/p>\n

\"\"<\/p>\n

The tab contains some visuals which you may have created before. In my case, it is only one scatter plot.<\/p>\n

Then, go to the \u201cData\u201d tab and note that your tables contain some data:<\/p>\n

\"\"<\/p>\n

Now, we will create a template file. To create a Power BI template file in Power BI Desktop, please, go to \u201cFile\u201d \u2013> \u201cSave As\u201d:<\/p>\n

\"\"<\/p>\n

Enter the name of the file, choose the same location where you store the original file and click \u201cSave\u201d. In my case, I kept the file name \u201cAdventureWorks\u201d as I knew that the new file would have a different file extension, so the full file name which consisted from the visible name and the file extension would finally be different.<\/p>\n

If you look at the files in your location directory, you will see that they have different file extensions:<\/p>\n

\"\"<\/p>\n

The newly created file has the \u201cpbit\u201d extension which stands for \u201cPower BI Template\u201d. An original Power BI workbook has an extension of \u201cpbix\u201d. If you do not see the file extensions, in Windows 10, go to Control Panel -> Appearance and Personalization -> File Explorer Option -> View tab -> Advance Settings -> Hide extensions for known file types. The path is similar for other versions of Windows. For Mac OS, you may Google the way to show the file extensions.<\/p>\n

Now, please, close your Power BI Desktop and reopen it again. Then, choose \u201cOpen other reports\u201d:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

If you navigate to the location where you have just saved the template file and choose the file type \u201cPower BI template files\u201d in the bottom-right corner:<\/p>\n

\"\"<\/p>\n

you will see your template file:<\/p>\n

\"\"<\/p>\n

Please, open it.<\/p>\n

You will see that you must enter database credentials (in case you use a data source with an authentication) to connect to data:<\/p>\n

\"\"<\/p>\n

If you do not know the credentials, you will have to click \u201ccancel\u201d as it is the only way to continue viewing the file:<\/p>\n

\"\"<\/p>\n

The message above shows that you cannot connect to the data source associated with this template file.<\/p>\n

Let\u2019s click on \u201cclose\u201d and check what it means for us:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

We do not see any data on the canvas. Let\u2019s also check the data tab:<\/p>\n

\"\"<\/p>\n

And there\u2019s no data on this tab as well.<\/p>\n

If you look at the very first screenshots that we made for these tabs of the original \u201cpbix\u201d file you will see that they contained data. Data is the key distinction between a standard Power BI file and a Power BI Template file: in a Power BI file, the imported data goes as a part of the data model, whereas in a Power BI template file you have only the report definitions and the data model description rather than the data itself.<\/p>\n

Why Create Templates in Power BI Desktop?<\/h3>\n

One of the major reasons for sharing such a file without data is security: if you are unsure about who can access the file, it is a good practice to share it without data. In this case, only the users with an authorized access to the data source will be able to view the reports.<\/p>\n

Another scenario of using Power BI templates is when you want a user to enter parameters in the file each time he or she launches the report. This might be useful if you have one file connected to several databases each having exactly the same data structure. In this case, you\u2019d like users to enter the database name before viewing the report content: if they enter the database name before viewing the reports, they will keep in mind what data source they will be using.<\/p>\n

One more reason for saving files in a Power BI Template format is their size \u2013 having only metadata associated with the file, the \u201cpbit\u201d file has a smaller size than the \u201cpbix\u201d file:<\/p>\n

\"\"<\/p>\n

And there is also an explicit confirmation for this. Not many Power BI users know about the trick I am going to showcase you now. Please, copy both files to a separate folder and change the file name of the template file to \u201cAdventureWorksTemplate.pbit\u201d:<\/p>\n

\"\"<\/p>\n

and then, the extensions of both files from \u201cpbix\u201d \/ \u201cpbit\u201d to \u201czip\u201d:<\/p>\n

\"\"<\/p>\n

\u201cZip\u201d is one of the most popular file extensions for the archived files.<\/p>\n

Now, double click on both files to open them:<\/p>\n

\"\"<\/p>\n

The most amazing thing here is that each power bi file is actually an archived collection of files rather than an individual binary file. Then, you may notice that the standard Power BI file contains a file \u201cDataModel\u201d which is 10 times bigger than the file \u201cDataModelSchema\u201d, a part of the template file. It is natural owing to pbix-file storing all the data for the report while \u201cpbit\u201d having only metadata for reports.<\/p>\n

Power BI Theme Templates<\/h3>\n

A completely different concept of using templates in Power BI is applying colour themes to your reports. The Power BI Community portal contains a whole gallery of themes which you can access via the following link: http:\/\/community.powerbi.com\/t5\/Themes-Gallery\/bd-p\/ThemesGallery<\/a><\/p>\n

\"\"<\/p>\n

Please, click on any theme from the gallery:<\/p>\n

\"\"<\/p>\n

You will be navigated to the example interactive report where you can play around before finally choosing a theme for your report. Scroll down a little bit and click on the icon near the \u201cJSON\u201d file to download it:<\/p>\n

\"\"<\/p>\n

Now, please close your Power BI Desktop and open it again, then choose the original \u201cAdventureWorks.pbix\u201d file coming with this tutorial:<\/p>\n

\"\"<\/p>\n

Click on the \u201cnew page\u201d on the bottom:<\/p>\n

\"\"<\/p>\n

Then, create a couple of simple visuals on the canvas. For a better color representation, it would be good to bring some categories under the \u201clegend\u201d placeholder of a visual:<\/p>\n

\"\"<\/p>\n

Now, please go to the \u201cFile\u201d -> \u201cOptions and Settings\u201d -> \u201cOptions\u201d:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

On the \u201cPreview features\u201d tab, click the \u201cCustom report themes\u201d checkbox:<\/p>\n

\"\"<\/p>\n

Close the \u201cOptions\u201d window. For the changes to take place, you will need to restart your Power BI Desktop. Please, do not forget to save your file before restarting.<\/p>\n

Once restarted, click on the \u201cSwitch themes\u201d button on the main ribbon and choose \u201cimport theme\u201d:<\/p>\n

\"\"<\/p>\n

Then, open the \u201cJSON\u201d file you\u2019ve downloaded from the Power BI Theme Gallery webpage:<\/p>\n

\"\"<\/p>\n

Boom! You\u2019ll see that all your visuals will have changed their color schemes in your Power BI report:<\/p>\n

\"\"<\/p>\n

You may switch back to a default theme at any time by clicking on \u201cdefault theme\u201d:<\/p>\n

\"\"<\/p>\n

This is a very powerful feature of Power BI: by choosing a theme, you may adopt your Power BI reports to your corporate colours quickly and easily.<\/p>\n

Power BI Example Reports AKA Templates<\/h3>\n

Finally, let\u2019s consider what could be a Power BI template from a business user\u2019s point of view. When you start creating a new report, you might want to search for inspiration by looking at reports created by experienced Power BI users. In this case, Power BI Data Stories Gallery comes to help: http:\/\/community.powerbi.com\/t5\/Data-Stories-Gallery\/bd-p\/DataStoriesGallery<\/a><\/p>\n

\"\"<\/p>\n

You will find all the standard reports and a plenty of creative ones there. For instance, you might have a look at Product Sales Scenarios or a P&L report:<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Or, if you are interested in the client analysis, you should check out this one:<\/p>\n

\"\"<\/p>\n

Of course, all those examples look perfect and have required a lot of effort for their creation. Nevertheless, they may give you an idea of what visual type would be good in your business case, or what numbers\/dimensions you are missing in your analysis.<\/p>\n

Conclusion<\/h3>\n

To sum up, we have considered the 3 definitions for Power BI templates most commonly met in a Power BI world. While, officially, a Power BI template is only a Power BI report without data, some users would say that Power BI colour themes and example reports are also examples of templates in Power BI. It is for you to choose what kind of templates are useful for your day-to-day work.<\/p>\n

References<\/h3>\n

EnterpriseDNA. (2017). Product Discounting Sales Scenarios – ‘What If’ analysis. Retrieved from https:\/\/community.powerbi.com\/t5\/Data-Stories-Gallery\/Product-Discounting-Sales-Scenarios-What-If-analysis\/m-p\/237514<\/a><\/p>\n

Eugene. (2016). Profit and Loss Report. Retrieved from https:\/\/community.powerbi.com\/t5\/Data-Stories-Gallery\/Profit-and-Loss-Report\/m-p\/52252<\/a><\/p>\n

Microsoft. (2017). Autumn. Retrieved from https:\/\/community.powerbi.com\/t5\/Themes-Gallery\/Autumn\/m-p\/140746<\/a><\/p>\n

Rafalk. (2017). Client Gain and Income Analysis. Retrieved from https:\/\/community.powerbi.com\/t5\/Data-Stories-Gallery\/Client-Gain-and-Income-Analysis\/m-p\/263391<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Power BI Templates are a huge topic, partially because different people will give you different definitions of what they consider to be a Power BI template. A Power BI Developer would say that a Power BI template is a Power BI file which contains all meta-data for a report but doesn\u2019t contain the data itself. […]<\/p>\n","protected":false},"author":2,"featured_media":205,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"series":[],"yoast_head":"\nPower BI Templates - Power BI Tutorials & How To<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI Templates - Power BI Tutorials & How To\" \/>\n<meta property=\"og:description\" content=\"Power BI Templates are a huge topic, partially because different people will give you different definitions of what they consider to be a Power BI template. A Power BI Developer would say that a Power BI template is a Power BI file which contains all meta-data for a report but doesn\u2019t contain the data itself. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/\" \/>\n<meta property=\"og:site_name\" content=\"Power BI Tutorials & How To\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-07T17:56:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-03T21:42:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/09\/Power-BI-Templates.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1440\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Power BI Tutorials\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Power BI Tutorials\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/\",\"url\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/\",\"name\":\"Power BI Templates - Power BI Tutorials & How To\",\"isPartOf\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/09\/Power-BI-Templates.png\",\"datePublished\":\"2018-09-07T17:56:00+00:00\",\"dateModified\":\"2019-07-03T21:42:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/#\/schema\/person\/67f71ab1cdea5656bf7109e3d515913f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#primaryimage\",\"url\":\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/09\/Power-BI-Templates.png\",\"contentUrl\":\"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/09\/Power-BI-Templates.png\",\"width\":2560,\"height\":1440},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.powerbitutorial.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI Templates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.powerbitutorial.org\/#website\",\"url\":\"https:\/\/www.powerbitutorial.org\/\",\"name\":\"Power BI Tutorials & How To\",\"description\":\"Your leading resource for Microsoft Power BI tutorials\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.powerbitutorial.org\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.powerbitutorial.org\/#\/schema\/person\/67f71ab1cdea5656bf7109e3d515913f\",\"name\":\"Power BI Tutorials\",\"description\":\"Learn how to better use Power BI to accomplish your business objectives.\",\"url\":\"https:\/\/www.powerbitutorial.org\/author\/powerbitutoria\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI Templates - Power BI Tutorials & How To","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:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/","og_locale":"en_US","og_type":"article","og_title":"Power BI Templates - Power BI Tutorials & How To","og_description":"Power BI Templates are a huge topic, partially because different people will give you different definitions of what they consider to be a Power BI template. A Power BI Developer would say that a Power BI template is a Power BI file which contains all meta-data for a report but doesn\u2019t contain the data itself. […]","og_url":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/","og_site_name":"Power BI Tutorials & How To","article_published_time":"2018-09-07T17:56:00+00:00","article_modified_time":"2019-07-03T21:42:27+00:00","og_image":[{"width":2560,"height":1440,"url":"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/09\/Power-BI-Templates.png","type":"image\/png"}],"author":"Power BI Tutorials","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Power BI Tutorials","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/","url":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/","name":"Power BI Templates - Power BI Tutorials & How To","isPartOf":{"@id":"https:\/\/www.powerbitutorial.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#primaryimage"},"image":{"@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#primaryimage"},"thumbnailUrl":"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/09\/Power-BI-Templates.png","datePublished":"2018-09-07T17:56:00+00:00","dateModified":"2019-07-03T21:42:27+00:00","author":{"@id":"https:\/\/www.powerbitutorial.org\/#\/schema\/person\/67f71ab1cdea5656bf7109e3d515913f"},"breadcrumb":{"@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#primaryimage","url":"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/09\/Power-BI-Templates.png","contentUrl":"https:\/\/www.powerbitutorial.org\/wp-content\/uploads\/2018\/09\/Power-BI-Templates.png","width":2560,"height":1440},{"@type":"BreadcrumbList","@id":"https:\/\/www.powerbitutorial.org\/tutorials\/power-bi-templates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.powerbitutorial.org\/"},{"@type":"ListItem","position":2,"name":"Power BI Templates"}]},{"@type":"WebSite","@id":"https:\/\/www.powerbitutorial.org\/#website","url":"https:\/\/www.powerbitutorial.org\/","name":"Power BI Tutorials & How To","description":"Your leading resource for Microsoft Power BI tutorials","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.powerbitutorial.org\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.powerbitutorial.org\/#\/schema\/person\/67f71ab1cdea5656bf7109e3d515913f","name":"Power BI Tutorials","description":"Learn how to better use Power BI to accomplish your business objectives.","url":"https:\/\/www.powerbitutorial.org\/author\/powerbitutoria\/"}]}},"_links":{"self":[{"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/posts\/170"}],"collection":[{"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/comments?post=170"}],"version-history":[{"count":0,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/posts\/170\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/media\/205"}],"wp:attachment":[{"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/media?parent=170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/categories?post=170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/tags?post=170"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/www.powerbitutorial.org\/wp-json\/wp\/v2\/series?post=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}