Where to use Power Query
PRODUCT NAME OVERVIEW
Microsoft Power BI Power Query enables data analysts and report authors to
connect and transform data as part of creating Power BI
reports using Power BI Desktop.
Microsoft Excel Power Query enables Excel users to import data from a wide
range of data sources into Excel for analytics and
Starting with Excel 2016, Power Query capabilities are natively
integrated and can be found under the “Get & Transform”
section of the Data tab in the Excel Desktop ribbon.
Excel 2010 and 2013 users can also leverage Power Query by
installing the Microsoft Power Query for Excel add
Microsoft SQL Server Data Tools for Visual Studio Business Intelligence Developers can create Azure Analysis
Services and SQL Server Analysis Services tabular models using
SQL Server Data Tools for Visual Studio. Within this experience,
users can leverage Power Query to access and reshape data as
part of defining tabular models.
Microsoft Common Data Service for Apps Common Data Service
for Apps lets you securely store
and manage data that's used by business applications. Data
within CDS for Apps is stored within a set of entities. An entity
is a set of records used to store data, similar to how a table
stores data within a database.
CDS for Apps includes a base set of standard entities that
cover typical scenarios, but you can also create custom entities
specific to your organization and populate them with data
using Power Query. App makers can then use PowerApps to
build rich applications using this data.
How Power Query helps with data acquisition
Power Query is natively integrated in several Microsoft products, including the following.