Power BI Analytics - Connect to DBMS and Card

access_time 3 years ago visibility520 comment 0

Power BI supports connecting to most of the DBMS databases such as SQL Server, Oracle, Teradata, MySQL, DB2, Sybase, Snowflake, Google BigQuery, Impala and etc.

This page summarizes the steps to connect to SQL Azure and to create the following part of the sample dashboard of this series:

image

Step-by-step guide

Open Power BI Desktop and Get Data

Click the following button in the menu:

image

In the Get Data windows, choose tab Azure and then select Azure SQL database in the panel.

image

You can also select the databases you want to connect instead of SQL Azure.

Click Connect button.

Input database connection details

Input server address and database. Choose Import as Data Connectivity mode. Ensure Include relationship columns option is checked.

image

Click OK button to continue.

Input credentials to connect. For SQL Azure, ensure firewall rule is configured to allow the database connection from your current IP address.

Select data tables

In the Navigator window, select the tables you want to include into this model:

image

In my case, I’ve selected all the tables that are required for this dashboard.

Click Load button to load data into the model.

View relationships

Click view relationships button image on the left side of the workspace.  The relationships of the tables are shown in a diagram:

image

You can add more relationships based on requirement. The following relationships are supported:

  • One to many: 1:*
  • Many to one: *:1
  • One to one: 1:1

Create a Card chart

Card is one of the simple visualizations you can create in Power BI. It is usually used to show a single number such as total sales, total views and etc.

For more details about Card, visit the following page:

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-card

Click the following highlighted icon to drag a Card visualization into the report.

image

Drag one of the field from one of the table into the Fields placeholder:

image

Change the aggregation method to Count:

image

And then click Rename in the above context menu, and change it to the name you want it to be.

You can further customize the format through the Format panel:

image

Once it is done, you will have a similar Card visualization like the following:

image

Create other Card visualizations

Follow the same steps to create all the Card visualizations you need. For example, the sample dashboard contains four cards of different metrics.

image

info Last modified by Raymond 10 months ago copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn or Twitter.

Want to publish your article on Kontext?

Learn more

More from Kontext

Pandas DataFrame Plot - Pie Chart
visibility 9840
thumb_up 0
access_time 10 months ago

This article provides examples about plotting pie chart using  pandas.DataFrame.plot  function. The data I'm going to use is the same as the other article  Pandas DataFrame Plot - Bar Chart . I'm also using Jupyter Notebook to plot them. The DataFrame has 9 records: DATE TYPE ...

visibility 4299
thumb_up 0
access_time 3 years ago

Power BI is my favourite BI and visualization tool as it is very simple yet powerful. It doesn’t only support traditional data sources like databases, CSV, JSON, XML and etc., but also supports emerging sources that are available in HDFS, Spark, R, Salesforce, Google Analytics and cloud platforms ...

[QlikView教程]T0 安装环境以及简单的例子
visibility 1592
thumb_up 0
access_time 8 years ago

QlikView是一款在数据可视化展示方面有很大特长的BI工具,可以提供比较全面的Dashboard的制作。本文将简单阐述此工具的安装使用,并介绍一个简单的例子。在本系列中会陆续介绍QlikView的各种功能。 QlikView官网下载地址: Downloads 。下载后按照向导安装应用程序;建议选择全部安装所有功能。 以下为Windows64位版本的初始界面: 在菜单栏有以下子菜单: File:可新建QV报表,打开远程报表,源代码控制等 View: 重置窗口大小,工具栏选择,窗口选择等 ...