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

Need to build an application around your data? Learn more about dataflow programming for rapid development and greater creativity. 

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.

Check out the Exaptive data application Studio. Technology agnostic. No glue code. Use what you know and rely on the community for what you don't. Try the community version.

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

Published at DZone with permission of Thiruppathi Rengasamy, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

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

{{ parent.tldr }}

{{ parent.urlSource.name }}