How to connect to data in Power BI Desktop

0 votes
How to connect to data in Power BI Desktop
Nov 18, 2020 in Power BI by anonymous
• 10,420 points
94 views

1 answer to this question.

0 votes

With Power BI Desktop, you can connect to many different types of data. These sources include basic data sources, such as a Microsoft Excel file. You can connect to online services that contain all sorts of data, such as Salesforce, Microsoft Dynamics, Azure Blob Storage, and many more.

  • To connect to data, from the Home ribbon select Get Data.

The Get Data window appears. You can choose from the many different data sources to which Power BI Desktop can connect.

Since this data source is an Excel file, select Excel from the Get Data window, then select the Connect button.

Power BI prompts you to provide the location of the Excel file to which to connect. The downloaded file is called Financial Sample. Select that file, and then select Open.

Once you've made your selections, select Load to import the data into Power BI Desktop.

answered Nov 18, 2020 by Gitika
• 65,870 points

Related Questions In Power BI

0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
856 views
0 votes
1 answer

How to show filtered vs total data in power BI?

Hi sindhu, Follow below steps to show filtered ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 32,910 points
965 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17, 2019 in Power BI by avantika
• 1,500 points

edited May 17, 2019 by Omkar 4,024 views
0 votes
1 answer

How to Export data in Power BI online version?

Hi, You can export your data from any ...READ MORE

answered May 27, 2019 in Power BI by avantika
• 1,500 points
283 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 32,910 points
211 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,420 points
15,700 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
6,345 views
0 votes
0 answers

How to Split Columns in Power BI?

Can anyone demonstrate how to split columns ...READ MORE

Feb 4, 2020 in Power BI by Roshni
• 10,420 points
129 views
0 votes
1 answer

How to connect webpage data by using Power BI Desktop?

Web connections are only established using basic ...READ MORE

answered Nov 18, 2020 in Power BI by Gitika
• 65,870 points
65 views
0 votes
1 answer

How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

answered Sep 14, 2020 in Power BI by Gitika
• 65,870 points
84 views