Re-use and Collaborate EASIER using Power BI Templates (PBIT) // Beginners Guide to Power BI in 2021

Get Demo Files here

In this video we go through how to use parameters and Power BI Templates files to make report recycling easier and secure when collaborating with other report developers.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[rahulsingh-pjbh]

I appreciate the way you have put in deatil and step by step .

[carolinemotsatsi]

Thank you for these explanations. Can I convert an existing Power BI report to a pbi template and then keep everything as is but change the connectivity mode from import to direct query?

[lulumarcano]

Thank you! like your videos, the content and the tempo is neat

[Timwoodworks]

Is there no option to browse to the new file location as the value for the parameter when you open the template?

[don]

Thanks man. Great video. Solved my problem

[mndp]

Can I add multiple data sources while creating a template??

[sapnaa]

I tried to create template and then it opened with all the data. I could not understand why. You have made it very clear in this video. Thanks

[anaisrossetto]

Hi Fernan, thank you for this nice video. I have created my template and now I want to insert it in an existing report. The problem is when I clic on import a template, power bi open a new project. I could not figure out how to open my template inside my existing report. Can you help me with this please?

[frederickzoreta]

Greetings Fernan. Thanks for this video.
I've sent you and email regarding an issue that is very similar to this video.

[prabhathg]

Thanks for the video Fernan. Can you please add UK file in the demo files.

[ahsaaah]

Hi Thanks for this, but should the data follow the same structure? And what if the US data includes more columns than the template data? Assuming the data set contains headers are identical to the templates but had those in different order and mixed with other columns which are not interested to the report? Please help?

[agelee]

I do not understand what benefits come from having a template. We do not have there any pre-defined placeholders. If we want to have a pre-set font, header colors, visualization settings and so on then we need to place whole visualizations themselves. So in fact we copy one whole report to serve as a template. If would be better if we could pre-set all settings to what we want without placing visualizations. PowerBI should replace visualizations with kind of "placeholders" like [title], [logo] etc.

[shuhuiyeo]

Hi. Thanks for sharing this method. I have followed step by step.
However, there is an error stating 'The key didn't match any rows in the table.'

The 2 different dataset that I have is of different data, but have the same number of column with exact naming. The difference is: the responses in values are different for the columns. Example in:
Dataset1: column 1 is filled with responses like "potato"
Dataset2: column 1 is filled with responses like "egg"

Could this lead to the error if I used this method?

Any other method that I can use for the kind of dataset that I have?

I would love to receive feedback, appreciate much in advance! :)

[ronlieuw]

Hi Fernan, on which e-mail can I reach you?
Keep up the good work

[HarshadChavan]

At first sight a though this guy is bihari