Learn Power BI- Getting GitHub Report

Introduction

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

Requirements

  • Download Power BI desktop here.
  • Window 10 operating system.
  • Publish repository in GitHub.

What is Power BI?

Power BI is a business analytical tool, which is powered by Microsoft. This tool provides interactive visualizations & self-service business intelligence capability. The end user can create reports & dashboards themselves without the need of admin’s help.

Features

  • Report review
  • Analytics
  • Data connectivity
  • Query editor

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

After installation, open Power BI in Windows 10.

Power BI

It is take some time to launch the Application first time.

Power BI

Now, main Window appears and select GetData.

Power BI

Again, one popup Window appears as Get Data. You can choose the online Services, select GitHub (Beta) and click connect button.

Power BI

It will ask some details from your GitHub login.

Power BI

Once you click the OK button, it will ask you to login to your GitHub account for authorizing propose. After logging in, it takes your permission to access your personal user data & repositories.

Power BI

If you click Authorize Power BI button, the page will automatically redirect to get the data.

Power BI

Navigator Window will appear & display the repository, which we have entered, which is based on repository information tables. Whatever information, if you know, select the tables on the display list. Afterwards, click Load button.

Power BI

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

Power BI

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

  • Table view
  • Matrix view
  • Multi Row view

Power BI

You can use filtering and  sorting & then export the data in report header.

Power BI

As far as left side menu is concerned, if you select table icon, we can see the actual table data.

Power BI

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

Power BI

If we made any changes in this linked repertories, there is no need to login again & again. Just click Apply button 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 through the comments section, since your comments are very valuable.