Transcript Power BI Embedded accelerator offer

30 updates in 30 minutes with Power BI
November 2016
Get started now at www.powerbi.com
What is Power BI Desktop ?
Create Power BI Content
Connect to data and build reports for Power BI
Power BI Enterprise
Architecture
Power BI Overview
Power BI service
Data sources
SaaS solutions
e.g. Marketo, Salesforce, GitHub,
Google analytics
Content packs
Natural language query
Sharing & collaboration
On-premises data
e.g. Analysis Services
Live dashboards
Organizational content packs
Corporate data sources or external data
services
Visualizations
Azure services
Azure SQL, Stream Analytics…
Reports
Excel files
Workbook data / data models
01001
10101
Power BI Desktop files
Data from files, databases, Azure, and
other sources
Datasets
Data refresh
Power BI Desktop
Prepare
Power BI REST APIs & Power BI Embedded
Explore
Report
Share
Integration with Azure services
• Real-time dashboards with Azure Stream Analytics
• Use Azure Stream Analytics to push live, streaming data to Power BI
• Enables real-time dashboards at scale, over data from devices and applications
• Can stream millions of events per second
• Can perform aggregation over time windows
Integration with Azure services
• Advanced analytics
• Blend Azure services together to
drive advanced analytics:
• Azure HDInsight:
Big Data processing
• Azure Machine Learning: Predictive
analytics
• Azure Data Factory: Orchestration at
scale
Data sources
Expand with Azure Services and Power BI
Feature
SaaS solutions
e.g. Marketo, Salesforce,
GitHub, Google Analytics
Event
Hubs
Stream
Analytics
HDInsight
SQL Server
On-premises Data
Organizational
Corporate data sources
or external data services
Storage
Machine Learning
Power BI
Azure services
Azure SQL, Stream
Analytics…
Excel files
Power BI Desktop files
Data from files,
databases, Azure, and
other sources
Data Factory
MICROSOFT POWER TEAM
https://powerapps.microsoft.com
https://flow.microsoft.com
https://stream.microsoft.com
http://www.pbieaccelerator.com/
Power BI Embedded
accelerator offer
Accelerate time-to-value for your intelligent apps
with Power BI Embedded
Power BI for
Developers
Develop exactly what your organization needs
Feature
011001010
0001010
Visuals
“name”:[string],
“columns”:[String]
“daType”:[String]
Integration
Push data
{
"name":{String},
"tables":[
...
]
}
{
"name":{String},
"columns":[
{
"name":{String},
"dataType":{String}
},
Realtime
Power BI for
Developers
Client app
Web
Feature
Client app development
 Using console app, cloud app, mobile
app, cloud app we can push real time
data to Power BI
 Register a client app
REST API
 Get client app id
Extensibility
 Power BI REST API calls are made on
behalf of an authenticated user by
passing a token in the “Authorization”
header that is acquired through Azure
Active Directory
Samples
 http://dev.powerbi.com
Power BI for
Developers
Feature
Web development
Client app
 Using web application, web app role you
can push real time data to Power BI
Web
 Register your web app
REST API
Extensibility
Samples
 Configure Power BI settings to authenticate
with Azure AD
 Create a query string to get authorization
code from Azure AD
 Acquire an Azure AD access token using
authorization code
 Use Azure AD access token to call a Power
BI operation
 http://dev.powerbi.com
Power BI for
Developers
Client app
Feature
Open API for integration
 Programmatically access Power BI
resources (datasets, tables)
Web
 Use the REST API to push data directly
from your application into Power BI
REST API
 Azure Active Directory and OAuth 2.0 for
user authentication
Extensibility
 Max rows per single push 10,000
Samples
 Used JSON to describe objects
 5 million row max per table
 Max of 5 pending request at one time
 http://dev.powerbi.com
Power BI SaaS Service
Power BI User Account
Datasets
Reports
Dashboards
Your Service or Application
Push Data Component
Push Content Component
Test the Power BI REST API @ www.apiary.com
If time do a live
Power BI for
Developers
Feature
Extend Power BI
 Extend Power BI with custom visuals
Client app
Web
 Enabling developers to easily add custom
visuals into Power BI for use in dashboard,
reports and content packs
REST API

Extensibility
 http://dev.powerbi.com
Samples
https://github.com/Microsoft/PowerBI-Visuals
• Global admin adds PBI superuser as
o365 global admin (MS has 8 !! only)
• New admin is then ‘Power BI admin’
• Log in @ COG see logs & security
• Don’t want them to Global Admin ?
See
• Power BI Auditing for a Non-Admin
https://www.youtube.com/watch?v=i
bPi4aF_-9I
• Power Bi Admin o365 role is coming
soon
•
•
•
•
•
Power BI Gateway is now the ‘On-Premises Gateway’
What is : Gateway is the powerbi.com access (gateway) to datasource
Critical keep recovery key when installing : the enterprise depends on it.
Multiple gateways for data intensive data sources
Gateway now for all Power family
Resource : https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-indepth/
Moving from the Personal to the On-Premises Data Gateway in Power BI
https://www.youtube.com/watch?v=KDeidwm6Xr8
• Admin adds data source with an authorised access in manage gateway so “connected”.
• When developer schedules refresh in dataset in powerbi.com see gateway Ok in Data
Source Settings.
Not finished just a 10 second break.
Feedback:
Attendees goto : http://aka.ms/pugsurvey
PUG ID : 350
PBI community
Join Group
http://community.powerbi.com/t5/London-Power-BI-User-Group/gp-p/PUG350
Get your badge too……….