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,480 points • 891 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,770 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 • 2,896 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
 • 33,030 points • 4,719 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,520 points
edited May 17, 2019 by Omkar • 7,526 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,520 points • 1,104 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
 • 33,030 points • 1,303 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,480 points • 78,961 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
 • 19,199 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
 • 1,380 points • 883 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,770 points • 992 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,770 points • 1,040 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.