Welcome Power BI User Group PUG Copenhagen The

Welcome! Power BI User Group (PUG) Copenhagen

The how, why and how much of embedding Power BI into your solution David L. Bojsen Cloud Solution Architect, Advanced Analytics and AI Microsoft Denmark

Meet Your Presenter • David L. Bojsen • Previously application/integration developer • Past 11 years focus on data and BI • Past 2 years focus on Cloud, Io. T at Microsoft aka. ms/davidb

Session Agenda • Session objectives • The why • The how • Demo packed (Level 400) • The how much

The how, why and how much (embedding) At the end of this session, you should be better able to…

Nearly everyone engages with apps

Many apps have reporting capabilities 01001010 11010010 1010101

Power BI for embedded analytics Apps energized with analytics Open & extensible

Bring data to life inside your app The ISV organization &

for free in Power BI Desktop

Keep the data in your app

What data sources can I connect to?

—for any device and faster time-to-value

tenant level and capacity usage through Power BI portal

Enable app end users to with a single consistent API reports

Report + Token Defines Roles Asserts Role Membership Roles define predicates Asserts Identity Ex. 1 Role: Company Predicate: [Company] = “Fabrikam” roles: “Fabrikam” Ex. 2 Role: Company roles: “Company” Predicate: [Company] = USERNAME() username: “Fabrikam” = Query + Predicate Query executes with correct scope Select * FROM [Sales] WHERE [Company] = “Fabrikam” SELECT * FROM [Sales] WHERE [Company] = “Fabrikam”

The Power BI Embedded API surface Power BI Java. Script API • Provides bidirectional communication between Power BI reports and your app • Enables easier integration of reports and reporting functionality Embed a specific report Page navigation Load a default report page Edit or Create reports Enable/disable the filter pane Filter reports React to events, including print and reload Handle data selection events Embed dashboard • Enables programmatic interaction

The Power BI Embedded API surface Power BI REST API • Enable full automation of the provisioning flow • Programmatically keep your data fresh at all times Import Get reports Set data source connections Report clone/bind Get dashboards Refresh dataset CRUD workspaces Get dashboard tiles EGW APIs

Minimum licensing requirements

Estimate Capacity Needs for ISVs

Developer resources Developer center https: //powerbi. microsoft. com/en-us/power-bi-embedded/ Developer docs https: //powerbi. microsoft. com/en-us/documentation/powerbi-developerembedding/ Samples https: //github. com/microsoft/powerbi-developer-samples Live JS Sample https: //microsoft. github. io/Power. BI-Java. Script/demo/v 2 -demo/index. html Visuals gallery https: //store. office. com/en-us/appshome. aspx? productgroup=Power. BI Ask us questions http: //stackoverflow. com/questions/tagged/powerbi

Thank you for Attending! Don’t forget to join your local PUG to enjoy year-round networking and learning. www. pbiusergroup. com/denmark www. pbiusergroup. com/sweden www. pbiusergroup. com/gebruikersgroep