Power BI

Create Power BI Connection to Azure SQL Database

• by Additional Articles

• MSSQLTips.com

• Power BI

• Article

Learn how to use Power BI to retrieve data from an Azure SQL Database.

2019-03-15

2,461 reads

Getting Started with Power BI - Part 1

• by Additional Articles

• MSSQLTips.com

• Power BI

• Article

In this tip we will show how Power BI works and how to create a simple report from scratch and the options available for creating reports.

2019-03-01

5,579 reads

Visualise SQL Server IO Stats

• by Philip Robinson

• SQLServerCentral.com

• Power BI

• Article

Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.58 (12)

Log in or register to rate

You rated this post out of 5. Change rating

2020-08-07 (first published: 2018-12-18)

5,840 reads

• Discuss

Power BI Introduction: Visualizing SQL Server Audit Data — Part 9

• by Additional Articles

• SimpleTalk

• Power BI

• Article

SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.

2018-12-17

3,047 reads

Creating Calculated Columns Using DAX

• by Additional Articles

• SimpleTalk

• Power BI

• Article

In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX.

2018-11-22

2,396 reads

Power BI Introduction: Publishing Reports to the Power BI Service — Part 8

• by Additional Articles

• SimpleTalk

• Power BI

• Article

Power BI Desktop is typically used to create reports that will eventually be published to Power BI Services where dashboards can be built. Robert Sheldon demonstrates how to publish reports from Power BI Desktop to the Power BI Service. Once published, the visualizations can be filtered, drilled into, or pinned to a dashboard.

2018-10-08

3,198 reads

Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6

• by Additional Articles

• SimpleTalk

• Power BI

• Article

In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language to import and transform data.

2018-08-20

2,844 reads

Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5

• by Additional Articles

• SimpleTalk

• Power BI

• Article

Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert Sheldon demonstrates how to work with SQL Server data in Power BI Desktop, including relationships between tables.

2018-07-30

3,913 reads

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4

• by Additional Articles

• SimpleTalk

• Power BI

• Article

Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.

2018-07-19

3,727 reads

Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3

• by Additional Articles

• SimpleTalk

• Power BI

• Article

R is a powerful language for manipulating data and creating visualizations. In this article in the series, Robert Sheldon demonstrates how R can be used within Power BI Desktop to import data and to create visualizations.

2018-07-02

2,546 reads