没有合适的资源?快使用搜索试试~ 我知道了~
首页Power Query教程英文版.pdf
Power Query英文版教程 Overview What is Power Query? Quick Starts Using Power Query in Power BI Combining Data Installing the PowerQuery SDK Starting to Develop Custom Connectors Creating your first connector - Hello World Tutorials Shape and combine data using Power Query Editor
资源详情
资源评论
资源推荐
ContentsContents
Overview
What is Power Query?
Quick Starts
Using Power Query in Power BI
Combining Data
Installing the PowerQuery SDK
Starting to Develop Custom Connectors
Creating your first connector
-
Hello World
Tutorials
Shape and combine data using Power Query Editor
Connector Development
TripPin Walkthrough
Overview
1. OData
2. REST API
3. Navigation Tables
4. Paths
5. Paging
6. Schemas
7. Advanced Schemas
8. Diagnostics
9. Test Connection
10. Folding
OAuth Tutorials
Github
MyGraph
Samples
Functional Samples
ODBC Samples
TripPin Samples
Concepts
Certification
How To
Reference
Connector Development Reference
Handling Authentication
Handling Data Access
ODBC Development
Overview
ODBC Extensibility Functions
Parameters for your Data Source Function
Parameters for Odbc.DataSource
Creating Your Connector
Troubleshooting and Testing
Common Problems
Handling Resource Path
Handling Paging
Handling Transformations
Static
Dynamic
Handling Schemas
Handling Status Codes
Default Behavior
Wait Retry Pattern
Handling Unit Testing
Helper Functions
Handling Documentation
Handling Navigation Tables
Handling Gateway Support
Handling Connector Signing
Resources
Power BI Documentation
What is Power Query?
3/5/2019 • 3 minutes to read
Power Query is the Microsoft Data Connectivity and Data Preparation technology that enables business users to
seamlessly access data stored in hundreds of data sources and reshape it to fit their needs, with an easy to use,
engaging and no
-
code user experience.
Supported data sources include a wide range of file types, databases, Microsoft Azure services and many other
third
-
party online services. Power Query also provides a Custom Connectors SDK so that third parties can
create their own data connectors and seamlessly plug them into Power Query.
The Power Query Editor is the primary data preparation experience, allowing users to apply over 300 different
data transformations by previewing data and selecting transformations in the user experience. These data
transformation capabilities are common across all data sources, regardless of the underlying data source
limitations.
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
visualizations.
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
-
in.
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
(
CDS
)
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.
剩余318页未读,继续阅读
up0056
- 粉丝: 0
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- stc12c5a60s2 例程
- Android通过全局变量传递数据
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0