Looking at dbatools github with Power BI

First of all! Really, really thanks dbatools team for this. I don’t have words to describe the impact that you guys have in my job. I use it every single day!

Now… back to the subject..

Those days I was preparing myself for a presentation and started to play around with Online Services Content Packs and decided to use the GitHub App Connector that is available.

In the left bottom of the Power BI area you have the Get Data option.

image

Once the page is opened you should choose Services and click on GET.

image

In the search bar just type Github. In the Github connector click on Get it now

image

Now the fun begins. What about if you want to have a look at your favorite DBA Powershell  Gallery? Off course I am talking about dbatools.io.

To play with it, the first thing that you need is a Power BI account (can be free Power BI) and a free GitHub account. After you have both things created, go to the dbatools github page.

https://github.com/sqlcollaborative/dbatools

In their page, click it in fork.

image
PS: Fork means that you are only creating a copy of that repository in your own account. Fork also allows you to make changes in the project without affecting the original.

After you have forked the project you will see your Github account like that.

image

Now, if you go back to your Power BI, there will be a page where you have to input data that in fact it will be used to connect to a repository.

image

Now, pay attention to the information that you have to fill up in those two above fields.

Repository Owner: sqlcollaborative
Respository: dbatools

Click next!

What can happen after that is that you will be displayed the login page of your Github account. So, login into your account and wait the data import to happen. This process can take something between 5 to 20 minutes, so be patient!

Now you have the GitHub Dashboard and Report.

image

Let’s try to open the Dashboard?

image

Do you want to see in average the time/effort they put into this?

image

For sure it is way more than that! This is only what Github is tracking, but imagine in fact how much time/effort they put on it, and everything is FREE!

If you want to take a closer look you can open this link below, or try by yourself.

https://app.powerbi.com/view?r=eyJrIjoiMjUyZDYxNjctZDlhNS00MTJjLWI1MzQtMDE0ZDM3OWQ5NWYwIiwidCI6ImM3NTJmYmNiLTU0MzItNDI1My04ZTI3LWY0ZWQzYTc1ZTNjYiIsImMiOjR9

One thing that you might ask to yourself is why the need of forking the project? I’ve tried to do and if you don’t fork it, it will give an error saying that your user is not in the User’s table. So, somehow the GitHub Infrastructure has to maintain a link in between to give you access to the data.

I hope you guys liked!

Advertisements

About Marcos Freccia

MVP em SQL Server (Data Plataform) , especialista em SQL Server, e atualmente trabalhando com Microsoft Azure!

Posted on November 17, 2017, in Comunidade, GitHub, power bi, VirtualPass and tagged , , , , , . Bookmark the permalink. 1 Comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: