Project Botticelli

Data Import Concepts Purchase this course

21 December 2018 · 83 views

Power BI Course

Data Import Concepts

Importing data into Power BI happens inside the Query Editor. A task to import data from one or more data sources into Power BI is called a Query, and a Query consists of one or more Steps, each of which either connect to a data source or transform the data in some way. All of the data sources supported by Power BI Desktop are listed in the Get Data dialog and include text files such as csv files and Excel, relational databases, web pages, Azure services, third-party cloud services, OData feeds and many more. You can also enter your own data by typing it into a freeform grid.

When loading data from different data sources, you must take into account issues such as the locale of the data source, which could affect date and number formats used, and also how Power BI should authenticate when connecting to the data source. There are also many other configurable options on the Options dialog.

Log in or purchase access below to the premium version of this content.

Purchase This Course or Full Access Subscription

Single Course

$250/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses