PBI-Tools Part 1 - Introduction and Setup (with Mathias Thierbach)

This tutorial describes the setup of a simple automated deployment pipeline for Power BI reports using pbi.tools. It assumes that reports have a live connection to a Power BI dataset and that the PBIX files containing the reports are held in a git repository in either Azure DevOps or GitHub.
The first part of the tutorial explains the setup necessary in the Power BI tenant. Since a service principal is going to be used for the deployment, the necessary steps to get this set up are covered.
Furthermore, the configuration of the pbi-tools deployment manifest is explained, and the deployment is tested locally.
GUEST BIO 👤
In 2015, after having spent over ten years as a Software Developer and Architect with Microsoft technologies, Mathias Thierbach moved into the Microsoft BI space. He soon landed on Power BI, but also realized quickly that the development and engineering tools and practices were nothing like the ones well established in software development. This is how pbi-tools started as a project, filling this gap in tooling. Today, leading a growing data management team at YouGov, he experiences the benefits of those efforts every day. Having open sourced the project in fall of 2021, Mathias spends a lot of his free time bringing those practices to the wider Power BI community now.
RELATED CONTENT 🔗
PBI Tools -- pbi.tools/
PBI Tools Azure -- dev.azure.com/pbi-tools/Sampl...
PBI Tools GitHub -- github.com/pbi-tools/tutorial...
Mathias Notes/Articles -- notes.mthierba.net/
Mathias's Twitter -- / mthierba
Mathias's LinkedIn -- / mthierba
Mathias's GitHub -- github.com/mthierba
BECOME A CHANNEL MEMBER 🎉
-- / @havensconsulting
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Courses -- www.havensconsulting.net/onli...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #pbitools

[@seamushand8439]

I need this for my PBI releases. Thank you

[@HavensConsulting]

Happy you found it useful! You're very welcome.

[@joelsherman2434]

how to set up a service principal in AAD? Or can I simply enable allow service principals to use APIs across organization?

[@TheSeebaer1986]

You can follow the instructions here: docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal#step-1---create-an-azure-ad-app

[@picious]

firstly , Thank you for the videos , really nice way to add version control ,, now some questions: all worked fine except the part of the secret,, how can i create a PBI_CLIENT_SECRET variable and where? ,, I create a service principal that part was ok,, also tenantId i shall use from Azure the Directory (tenant) ID ? or the Power BI Tenant Id? ---

[@TheSeebaer1986]

To create the environment variable:
1.) On the Windows taskbar, right-click the Windows icon and select System.
2.) In the Settings window, under Related Settings, click Advanced system settings.
3.) On the Advanced tab, click Environment Variables.
4.) Click New in the upper part to create a new environment variable for your user.
5.) Name it "PBI_CLIENT_SECRET" and paste in your actual client secret from your service principal.
After you restart Visual Studio Code it should pick up on the variable.
The tenant ID comes also from your service principal, its the "Directory (tenant) ID.