Power BI is one of the most popular and powerful ways to work with complex business data.
With Power BI you create highly interactive reports, clickable visualizations, and dashboards from your data-sets and share them with your audience.
Note: Power BI is available only for users who have subscribed for the Kanbanize Analytics.
To get started, download the free Microsoft Power BI Desktop application. Note that Power BI releases a new version almost every month.
Power BI is made up of two distinct parts. The first one is Power BI Desktop, which is the tool that allows you to build Power BI reports. The second part is called Power BI Service, which is the web-based platform that allows you to publish and share your reports with other members of your organization.
You can use Power BI Desktop without registering for the PowerBI.com online account. If you want to publish and share your reports, you must log in to your online account. Sign up for free here.
Take advantage of the powerful, two-way Kanbanize integration with Microsoft Power BI that allows you to:
- Bring your Kanbanize data to life with interactive dashboards and engaging reports that you can collaborate, publish, and share.
- Embed the Power BI reports directly on your Kanbanize dashboard.
2. Get your Kanbanize data and create a Power BI dataset
Step 1: Use the Advanced Search functionality in Kanbanize to get data and export custom reports. You can use filters to narrow down your data as well as to configure it to hide/show certain properties and thus focus on a specific portion of data.
Note: when configuring your results you can select "Description" to get displayed relevant content per card. The number of characters with spaces depends on the number of results you get in your report.
- If you get from 1 to 10 results (cards), the system displays 100000 characters from the description.
- if you get from 11 to 30 results (cards), the system displays up to 30000 characters.
from 31 to 100 cards - up to 10000 characters.
from 101 to 300 - up to 3000 characters.
from 301 to 1000 - up to 1000 characters.
from 1001 to 3000 - up to 300 characters.
above 3000 - up to 100 characters.
Step 2. Once you generate your report, proceed further and Save it. Give it a name, checkmark the Power BI query, and select "Save Filter".
Step 3. You will see the generated script from your search results. Copy the script to use it in the advanced query editor in Power BI.
Step 4: Go to your Power BI Desktop and select Get Data. Scroll through the list and select Blank Query.
Step 5: Open the Advanced query editor where you can paste the script.
When you paste the script in the Advanced Editor, click Done.
Note: If the software requests further authentication, please click on Edit Credentials and Connect.
Power Query Editor launches, with a representative view of the table. You will get the same data from your Kanbanize search to create your dataset. You can further shape and combine data.
3. Build your reports
In the Power BI Desktop Report view, you can build numerous visualizations and reports.
The Report view has six main areas:
(1) The ribbon at the top, which displays common tasks associated with reports and visualizations.
(2) The canvas area in the middle, where visualizations are created and arranged.
(3) The pages tab area at the bottom, which lets you select or add report pages.
(4) The Filters pane, where you can filter data visualizations.
(5) The Visualizations pane, where you can add, change, or customize visualizations, and apply drill-through.
(6) The Fields pane, which shows the available fields in your queries. You can drag these fields onto the canvas, the Filters pane, or the Visualizations pane to create or modify visualizations.
To create a visualization, you have to select a chart/graph. The options available in the Fields area depend on the type of data you have in your dataset.
For example, let's create a report using a visualization that shows the Assignees (names) and the total time they have logged against the tasks in the "Design Board".
Select the Donut/Pie chart from the Visualization pane. In the Fields pane, select Assignee, Board name, Logged time. Power BI instantly creates the visuals in the dedicated area.
With Power BI you can create a variety of appealing and functional reports with advanced calculations in order to bring out important metrics and insights from your data sets.
4. Publish your work
Now that you have a Power BI Desktop report, you can share it with other members of your organization.
First, you have to Save your report and then publish it directly from Power BI Desktop to the Power BI Service (you need an account to be able to do this).
Note: there are several ways to share your report.
You’ll be prompted to sign in to Power BI. When you've signed in and the publishing process is complete, the following dialog box will appear. You can select the link below Success!, which will take you to the Power BI service, where you can see the report that you published.
Your report opens in your Power BI site under My workspace.
You can make changes to a report in the Power BI service. Moreover, you can pin your reports to design a functional dashboard, making the most important information stand out.
Note: You can Share report or Share dashboard screen to send an email or get a link to share your report or dashboard with others (Only users with Power BI Pro will have access to this report).
5. Embed your power BI report directly on your Kanbanize Dashboard
With the Power BI "Publish to web" option, you can easily embed your interactive Power BI report directly on your Kanbanize Dashboard.
Step 1: Select File and then click "Publish to web".
Step 2: Create an embed code and publish a live version that will remain synchronized with the source report in Power BI. Any changes you make to the report will be reflected in the published public version.
Note: Go to the Datasets Settings and make sure that you keep your data up to date (Scheduled Refresh). Configure your Refresh frequency.
Step 3: Copy the generated link.
Step 4: Now open your Kanbanize account and go to any of your custom Dashboards where you want to visualize the BI Report. Click Add Widget and select the predefined Power BI Reports widget.
Step 5: Paste the link that you copied in Step 3 in the dedicated field and Save the Widget.
When you go to your Kanbanize Dashboard, you will see your BI report to the right side of the screen.
Power BI comes with various out-of-the-box visualizations and integrates easily with your existing business environment. The solution allows businesses of all sizes to analyze data, share insights, and saves your time building multiple reports for each stakeholder.