Whenever using Power BI, a data connection is required. In this chapter, you'll be introduced to commonly used data connections for Power BI. You'll also get an insight into the data connection features of Power BI Serice while finally having the chance to carry out your own database connection. 

Data connections in Power BI

The data flow process

Power BI Desktop connections

Which connection?

Welcome to Power BI Service

Desktop vs. Service

First connections

Desktop or Service data connections?

Add a database connection

Data Connections in Power BI

It's time to take the next step in your data connections journey! Through hands-on exercises, you will interact with a new database connection and learn how different settings can be changed. You'll also learn about the different storage modes offered by Power BI and how you can use coding to alter the import process.

Database connections

Storage modes

Exploring connections

Power BI languages

Controlling the import process

Changing data source settings

Databases and More

In this chapter, you'll learn how to create parameters that can be used for incremental refreshes. You will also implement an incremental refresh on your data connection. Finally, you'll understand how M Language can be utilized to tackle issues with your data import processes.

Data source settings

Incremental refresh

Parameters and incremental refresh

Options

True

False

Parameters: true or false?

Query parameters

Discovering M Language

M Language examined

Using M Language on connections

Congratulations

Data Source Settings

Exercises and Datasets

Data connections are an essential part of Power BI. In this course, you will be introduced to the many different options for connecting to data. You’ll learn the differences between Power BI Desktop and Power BI Service when it comes to data connections. You’ll also learn about the different ways that Power BI stores data when connecting to a source, and how you are able to amend connections after they have been made. Finally, you’ll learn how you can use parameters and M Language in Power BI Desktop to level up your handling of data import processes.

<h2>Building Connections</h2>
Data connections are an essential part of Power BI. In this course, you will be introduced to the many different options for connecting to data. 
<br><br>
<h2>Understand Power BI Desktop vs Service </h2>
You’ll learn the differences between Power BI Desktop and Power BI Service when it comes to data connections. You’ll also learn about the different ways that Power BI stores data when connecting to a source, and how you are able to amend connections after they have been made. 
<br><br>
<h2>Utilize Parameters and M Language</h2>
Finally, you’ll learn how you can use parameters and M Language in Power BI Desktop to level up your handling of data import processes.


Introduction to Power BI

Discover the different ways you can enhance your Power BI data importing skills.

Data Analyst in Power BI

You can create a list of values in a parameter.

Parameter values can be edited after being created.

Parameters can be used to make dynamic data connections.

In order to set up an incremental refresh process, you need to create parameters.

Parameters cannot be created in Power Query Editor

Date/Time is not an available data type for a parameter.

Parameters: true or false?

Data Connections in Power BI

Praktische interactieve oefening