Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

How to Use Power BI to Get GitHub Reports

DZone's Guide to

How to Use Power BI to Get GitHub Reports

Power BI provides interactive visualizations and self-service business intelligence capability. Learn how to use it to get GitHub reports.

Free Resource

Are you looking for ways to manage your open source risk? We can help. Learn more.

In this article, we will learn about Power BI. This article is most helpful for source maintaining as far as GitHub users are concerned.

Power BI

Requirements

  • Download Power BI desktop here.
  • Have the Windows 10 operating system.
  • Publish repository in GitHub.

What Is Power BI?

Power BI is a business analytical tool powered by Microsoft. This tool provides interactive visualizations and self-service business intelligence capability. The end user can create reports and dashboards themselves without needing help from an admin.

Features

  • Report review.
  • Analytics.
  • Data connectivity.
  • Query editor.

Let's see about getting the same GitHub reports. If you have no GitHub login, click here.

After installation, open Power BI in Windows 10.

Power BI

It will take some time to launch the application first time.

Power BI

Now, the main Window appears. Select Get data.

Power BI

Again, one popup Window appears with the Get data button. Go to Online Services, select GitHub (Beta), and click the Connect button.

Power BI

It will ask some details about your GitHub login.

Power BI

Once you click OK, it will ask you to log into your GitHub account for authorizing purposes. After logging in, it takes your permission to access your personal user data and repositories.

Power BI

If you click Authorize PowerBI, the page will automatically redirect to get the data.

Power BI

The Navigator window will appear and display the repository we've entered, which is based on repository information tables. Depending on the information you know, select the tables on the display list. Afterwards, click Load.

Power BI

Once the data is loaded, selected tables are shows in the right Fields slider.

Power BI

Start getting the report in the Report window, as per your desire, as shown below. I have shown sample reports as:

  • Table view.
  • Matrix view.
  • Multirow view.

Power BI

You can use filtering and sorting, and then export the data in the Report header.

Power BI

If you select the table icon on the left-hand side, you can see the actual table data.

Power BI

If there is any relationship in our selected table, we can see in a Relationship icon in the side menu.

Power BI

If we make any changes in these linked repertories, there is no need to log in again and again. Just click Apply changes on the notification message.

Power BI

It will be getting the latest data for your reports.

Power BI

Conclusion

In this article, we have learned about Power BI. If you have any queries, please tell me in the comments section — your comments are very valuable.

Software composition Analysis for DevSecOps. Start finding vulnerabilities in your open source components today.

Topics:
github ,power bi ,data analytics ,data visualization ,business intelligence ,big data ,tutorial

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}