Transcript immersive data experiences connecting with worlds data Self-Service Collaboration Corporate Apps Combine Discover Devices Refine any data, any size, anywhere Relational Non-relational Analytical Streaming Self-service BI with the familiarity of Office and the power of the.

immersive data
experiences
connecting with
worlds data
Self-Service
Collaboration
Corporate Apps
Combine
Discover
Devices
Refine
any data, any
size, anywhere
Relational
Non-relational
Analytical
Streaming
Self-service BI with the familiarity of Office and the power of the service
1 Billion Office Users
Discover
Analyze
1 in 4 enterprise customers on Office 365
Visualize
Share
Find
Q&A
Scalable | Manageable | Trusted
Mobile
Extend with Hybrid Cloud Solutions
Extend with Hybrid Cloud Solutions
Extend with Hybrid Cloud Solutions
Index
Public Cloud
Data Sources
O365 Power BI
Data Refresh
Data Management SPO team sites,
Power BI
Corporate
Data Catalog Admin Center Portal
BI Sites, Q&A
Import Data
Public
Data Catalog
Cloud Data
Sources
Import Data
Data Refresh
Publish queries
Data Management
Gateway
Configure
Corporate
Data Sources
IT Admin
Import Data
Publish raw
data
sources or
expose
them as
OData
feeds
Import data,
Publish queries
Manage Data
Data Steward
Publish reports &
create featured
questions,
configure
scheduled refresh
IW
(Author)
Import Data
Consume interactive
reports, ask
questions
Power Query
Power Pivot
Power View
Power Map
Excel,
Tablet/Mobile
,
IW
Browser –
(Consumer) Silverlight,
HTML5
Data Management Gateway
Power BI Admin Center
capabilities
Enabling Corporate
OData Feeds
Enabling
Discovery in
Power Query
Enabling Excel Workbook
Data Refresh using
SharePoint Online
Data Management Gateway
Connects to corporate data sources
and sends data to Microsoft cloud
services through a secure channel
(Service Bus).
Secure Credential Store
All credentials used by the
gateway are stored onpremises. Encrypted backup of
credentials can also be stored
in the cloud to enable business
continuity scenarios.
Power BI Admin Center
Allows IT to configure, manage
and monitor access to
corporate data sources.
Corporate Data Sources
The Gateway can connect to
a variety of data sources.
9350-9354
443/80
8050
8051
Power BI Cloud
Services
Power Query
Data Management
Gateway
Excel Workbook in
Sharepoint Online
(2) Connects to Gateway
Cloud Service
(8) Returns data to
Excel Workbook
(3) Checks whether
user is authorized to
perform a refresh
(4) Sends command
(SQL statement,
connection string) to
on-premise Gateway
(5) Sends SQL to
SQL Server
Gateway
Cloud Service
(7) Compress,
chunk and return
the data
Data Management
Gateway
(6) Return Results
Data Management Gateway
Power BI Admin Center
capabilities
Enabling Corporate
OData Feeds
Enabling
Discovery in
Power Query
Enabling Excel Workbook
Data Refresh using
SharePoint Online
http://office.microsoft.com/en-us/excel/power-bi-download-add-inFX104087144.aspx
http://blogs.msdn.com/b/powerbi/
Introduction to Power BI Admin Center
Power BI Admin Center Help
Restore a Data Management Gateway
Monitor System Health using the System Health OData Feed
Publish SSIS Packages as OData Feed Sources
Supported Data Sources and Data Types
Sponsored by