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.
Join the DZone community and get the full member experience.Join For Free
in this article, we will learn about power bi. this article is most helpful for source maintaining as far as github users are concerned.
- 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.
- report review.
- 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.
it will take some time to launch the application first time.
now, the main window appears. select get data .
again, one popup window appears with the get data button. go to online services , select github (beta) , and click the connect button.
it will ask some details about your github login.
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.
if you click authorize powerbi , the page will automatically redirect to get the data.
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 .
once the data is loaded, selected tables are shows in the right fields slider.
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.
you can use filtering and sorting, and then export the data in the report header.
if you select the table icon on the left-hand side, you can see the actual table data.
if there is any relationship in our selected table, we can see in a relationship icon in the side menu.
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.
it will be getting the latest data for your reports.
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.
Published at DZone with permission of Thiruppathi Rengasamy, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.