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:
Click the following button in the menu:
In the Get Data windows, choose tab Azure and then select Azure SQL database in the panel.
You can also select the databases you want to connect instead of SQL Azure.
Click Connect button.
Input server address and database. Choose Import as Data Connectivity mode. Ensure Include relationship columns option is checked.
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.
In the Navigator window, select the tables you want to include into this model:
In my case, I’ve selected all the tables that are required for this dashboard.
Click Load button to load data into the model.
Click view relationships button on the left side of the workspace. The relationships of the tables are shown in a diagram:
You can add more relationships based on requirement. The following relationships are supported:
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.
Drag one of the field from one of the table into the Fields placeholder:
Change the aggregation method to Count:
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:
Once it is done, you will have a similar Card visualization like the following:
Follow the same steps to create all the Card visualizations you need. For example, the sample dashboard contains four cards of different metrics.
Microsoft Azure provides a number of data analytics related products and services. It allows users to tailor the solutions to meet different requirements, for example, architecture for modern data warehouse, advanced analytics with big data or real time analytics. The following diagram sho...
View detailBigQuery is Google’s serverless data warehouse in Google Cloud. Power BI can consume data from various sources including RDBMS, NoSQL, Could, Services, etc. It is also easy to get data from BigQuery in Power BI. In this article, I am going to demonstrate how to connect to BigQuery to create...
View detailDATATABLE StaticTable1 = DATATABLE("IntCol",INTEGER,"StringCol",STRING,{{1,"User1"},{2,"User2"}}) The above expression generates a table with two columns IntCol and StringCol : ...
View detailPower 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...
View detail