Transcript Get your LOB application data into Microsoft Power BI

Integrate
APIs for Power BI, including
publishing content
Integrate tiles and reports
into applications
Push datasets to Power BI
Azure Stream Analytics for
real-time insights at any
scale.
Extend
Content Packs enable instant
insights over application
data.
Custom visualizations enable
data experience tailored to
each use case.
Embed
Embed Power BI into your
application
Azure provisioning of Power
BI
Power BI Desktop
Query Language
let
Source = Web.Page(Web.Contents("http://www.bing.com/blogs/site_blogs/b/search/archive/2013/12/01/eoy.aspx")),
WebTable = Source{index}[Data],
RenamedColumns = Table.RenameColumns(WebTable,{{"Column1", "Rank"}, {"Column2", "2013"}})
in
RenamedColumns
let
Source = Sql.Database("localhost", "AdventureWorksDW2012"),
DimCat = Source{[Schema="dbo",Item="DimProductCategory"]}[Data],
DimSubCat = Source{[Schema="dbo",Item="DimProductSubcategory"]}[Data],
DimCustomer = Source{[Schema="dbo",Item="DimCustomer"]}[Data],
Joined = Table.NestedJoin(DimSubCat,{"CategoryKey"},DimCat,{"CategoryKey"},"Category",JoinKind.Inner)
in
Joined
Power BI Content Packs
What is a content pack?
Building a content pack
Submit a content pack!
https://azure.microsoft.com/enus/marketplace/programs/certified/apply/
https://publish.windowsazure.com/
Submit a content pack!
https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-content-pack-overview/
Power BI Applications
Power BI Applications
Power BI Applications
http://dev.powerbi.com/apps
Push Data
here
Push Data New Features
https://powerbi.microsoft.com/en-us/blog/newdatasets/
Import Desktop Files
Integrate into your App
Try
Power BI Embedded
Your app
Data + Analytics
PREVIEW
Developer resources
Home page
http://azure.com/powerbiembedded
Developer center
http://dev.powerbi.com
Developer blog
http://blogs.msdn.com/powerbidev
Samples
http://github.com/PowerBI
Open source visuals
http://github.com/Microsoft/PowerBI-visuals
Visuals gallery
http://visuals.powerbi.com
Ask us questions
http://stackoverflow.com/questions/tagged/powerbi
http://myignite.microsoft.com
https://aka.ms/ignite.mobileapp