Power BI SQL Server Integration
4.3 (37 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,174 students enrolled

Power BI SQL Server Integration

Connecting Power BI to Microsoft SQL Server | G Com Solutions
New
4.3 (37 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,174 students enrolled
Created by Grant Gamble
Last updated 5/2020
English
English [Auto-generated]
Current price: $41.99 Original price: $59.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 7 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Connecting Power BI to Microsoft SQL Server using both DirectQuery and Import modes
Requirements
  • Knowledge of the basics of Power BI Desktop
Description

In this Power BI training course by G Com Solutions, we will focus on connecting Power BI to Microsoft SQL Server using both DirectQuery and Import modes.

This hands-on course is aimed at beginner and intermediate users of Power BI, especially those with limited prior experience of working with SQL Server. All the materials used in these video tutorials can be downloaded, so that you can follow along as you watch. And during the course, you will get practice on connecting to both the on-premises and cloud-based versions of SQL Server.

The course starts with a walk through of installing the required software and exercise files and an overview of connecting to SQL Server databases.

We then discuss different strategies for connecting to data held in SQL Server databases: connecting to SQL views, executing SQL commands from within Power BI, as well using Power BI’s relationship columns feature to navigate and collate relational database tables.

We also compare the experience of importing data with that of working in DirectQuery mode and the different roles played by on-premises data gateways in each of those modes.

In addition, we will look at creating a live connection to an Analysis Services cube, parameterizing your SQL Server connections to facilitate switching from a testing to a production server, as well as the use of dataflows to centralize your data connection and data cleansing operations.

Who this course is for:
  • Existing users of Power BI looking to extend their knowledge
Course content
Expand all 27 lectures 02:40:11
+ 3. Leveraging SQL
4 lectures 26:46
1. Query Folding and Native Queries
08:26
2. Using SQL Statements
04:36
3. Include Relationship Columns
07:13
Summary of 3. Leveraging SQL
06:31
+ 4. DirectQuery Mode
4 lectures 28:50
1. Working in DirectQuery Mode
14:28
2. Composite Models
04:53
3. Storage Modes
04:31
Summary of 4. DirectQuery Mode
04:58
+ 5. Additional Functionality
6 lectures 42:59
1. SQL Server and Dataflows
08:14
2. Parameterizing SQL Server Connections
05:44
3. Analysis Services Databases
08:48
4. Creating a SQL Azure Database
05:55
5. Connecting to a SQL Azure Database
05:36
Summary of 5. Additional Functionality
08:42
+ 6. On Premises Data Gateway
4 lectures 21:09
1. On Premises Gateway Configuration
06:13
2. Adding a Gateway to an Existing Cluster
03:45
Adding A SQL Server Data Source
07:59
Summary of 6. On Premises Data Gateway
03:12