Sign in Subscribe

Power BI Tutorials

How to connect to data sources in Power BI Desktop?

When you want to analyze and visualize your data in Power BI, the first thing you need is to connect to a data source.

The data you will use in Power BI is taken from a dataset. The source of these datasets is called the data source.

There are numerous data sources that Power BI Desktop may connect to.

Power BI Desktop should be launched. Use the top input panel to enter data. The frequently used data sources window will open when you click Get data.

Get data

Let's open the window with all data sources by clicking more from the window that opens.

Get data>All

Connect to a data source by selecting it and clicking the connect button.

Using the example of loading CSV data, I'll show you the next steps.

CSV is one of the data sources in the file category. Select Text/CSV from the file category and click the connect button.

Get data>File

When you click the Connect button, a window will open in which you can select your CSV file from your computer. Following your file selection, a screen like the one below will appear.

Data Load Pane

File Origin is automatically identified. You can edit if needed.

CSV data is usually comma-separated but can sometimes be separated by other separators such as semicolons, spaces, etc. Usually, the delimiter of your data is defined automatically.

You can edit it from the delimiter field according to your data if it is not defined or defined incorrectly.

Then, You can load your data directly by clicking the Load button.

If you need to change your data, click the Transform data button. By doing so, the Power Query window will open, allowing you to edit your data. Bring your data into the desired edit on the Power Query Editor's using various queries, and then load the edited data.

For more information about Power Query, You can read this article.

After your data has been loaded, you can find it in the Fields field. From here, you can examine and visualize your data selectively.

Which data sources are supported by Power BI Desktop?

The Get Data dialog categorizes data types as follows:

All
File
Database
Power Platform
Azure
Online Services
Other

The category All includes all data connection types.

File Data Sources

In the file category, the following data connections are available:

Get data>File

Database Data Sources

Below are some examples of data connections from the database category: ‌

Get data>Database

Power Platform Data Sources

The following data connections are part of the Power Platform category: ‌

Get data>Power Platform

Azure Data Sources

Following data connections are part of the Azure category: ‌

Get data>Azure

Online Services Data Sources

The following data connections are available under the Other category: ‌

Get data>Online Services

Other Data Sources

In the Other category, the following data connections are available:

Get data>Other

Read next

How to Format and Configure Visualizations in Power BI?

You may choose from a variety of customization choices in Power BI Desktop to alter the color and format of the text that appears in the visualizations you select. To understand how each selection will affect the final image, you'll need to spend some time investigating your possibilities. To open

What are Power BI data visualization tools and which visualization should we choose to according to our data?

Table and Matrix visualizations A table is a grid with linked information organized logically into rows and columns. The table can include headers and rows for totals, and it supports two dimensions. Similar to a table visualization, a matrix visualization shows data. Nevertheless, it gives you the option to pick

How to conditional formatting in Power BI?

One of the formatting kinds is conditional formatting. Any fields you provide in the Values box of the Visualizations pane of PowerBI can conditional formatting applied to them. You can provide icons, URLs, cell background colors, and font colors based on cell values using conditional formatting for tables, including gradient

How to filter in Power BI?

Data that you don't want to focus on is removed using filters. Highlighting is typically not a filtering technique. Typically, highlighting doesn't get rid of extraneous information from images. It emphasizes relevant information in its place. Although faded, the remaining info is still discernible. Filters can be applied in the

How do we group interaction between visualizations in Power BI?

You can use Image interactions to modify how images on a report page interact with one another if you have edit access to the report. By default, other visualizations on a report page can be cross-filtered and cross-highlighted using the visuals on that page. For instance, when a state is

How to create an R or Python visual with Power BI?

Power BI has features that allow you to add your own visuals in addition to various visualizations. You can use R or Python to programmatically visualize your data in Power BI Desktop if you are a programmer. Power BI Desktop has ready-to-use visualization options for both R and Python, which

How do we visualize data with Power BI?

Data visualization enables you to transform any complicated data into easily digestible, aesthetically pleasing, and practical business information. Your data may include significant insights that can help you advance your business. However, the issue is that by simply looking at the numbers alone, we are unable to make connections. When

How to create Measures in Power BI Desktop?

How to create Measures in Power BI Desktop?

In Power BI Desktop, Measure may be utilized to build some of the most powerful data analytics solutions. Using measures, you can engage with your reports by running computations on your data. Calculations in calculated columns appear in the column but not at the Measure. We snapshot data in Measure

How to create and manage relationships in Power BI Desktop?

How to create and manage relationships in Power BI Desktop?

When you import multiple tables, you will most likely use data from all of them when analyzing them. Relationships between these tables are required to calculate results correctly and display accurate data in your reports. Power BI Desktop makes it simple to establish these connections. You won't have to do

How to anaylze the performance of data models in Power BI?

How to anaylze the performance of data models in Power BI?

You may discover that your report performs fine in test and development environments but has performance concerns when it is sent to production for widespread use. Poor performance implies that it takes longer to load report pages and update visuals for report users. This subpar performance degrades the user experience.