際際滷

際際滷Share a Scribd company logo

Embed Interactive Reports in Your Apps

Teo Lachev
Teo Lachev

1. Power BI Embedded is an Azure cloud service that allows developers to embed Power BI reports in their custom applications. 2. Developers can connect to data sources, create reports and datasets, embed reports, and manage access using Power BI APIs. 3. The demonstration shows how to provision a workspace collection, embed an interactive report in an application, and handle authentication and permissions for end users.

1 of 22
Downloaded 11 times
Embed Interactive Reports in Your Apps Teo Lachev, Prologika teo.lachev@rologika.com @tlachev
Create compelling interactive reports Embed easily for faster time to value Deploy quickly and manage with ease You have the app. You have the data. Bring data to life inside your app with Power BI Embedded
About Me Consultant, author, and mentor in Data Analytics Owner of Prologika consulting and training company based in Atlanta (prologika.com) Microsoft Gold Partner in Data Analytics Power BI Red Carpet Partner Microsoft SQL Server MVP since 2004 Founder and leader of Atlanta BI group (atlantabi.sqlpass.org)
What's Power BI? Four products Power BI Service (powerbi.com) Cloud-based PaaS BI service Power BI Desktop free Windows app for designing self-service data model and reports Power BI Mobile a set of native apps for iOS, Android, and Windows devices Power BI Embedded Azure cloud service to embed Power BI reports in custom apps
Power BI for You For business users 1. Connect to cloud or on-premise data 2. Explore data with reports and dashboards 3. Mobile applications For data analysts 4. Import data from virtually everywhere 6. Create rich self-service data models 7. Create business calculations For BI and IT pros 8. Enable team BI 9. Implement organizational BI solutions For developers 10. Real-time content and management REST API 12.Embed reports in custom applications11. Create custom visuals 5. Cleanse, transform and shape data
Demo Power BI
Azure cloud service https://azure.microsoft.com/en-us/services/power-bi-embedded/ Enables developers and ISVs to embed reports for third party Priced per user session
Demo Power BI Embedded
Microsoft Azure subscription Embed End users Workspace Workspace collection Developer Name Admin Users Endpoints Keys Gateways Credentials Geo Location Tags Name Reports Datasets Tags Your app 1,N Azure SQL Data Warehouse Azure SQL Database Power BI Desktop
Power BI report Keep visuals up to date using DirectQuery Connect directly to the source without moving your data Build visualizations over very large datasets Azure SQL Data Warehouse Azure SQL Database Your app EmbedCreate Deploy
Discovery: Enumerate datasets and reports Content Creation: Provision datasets and reports Embed: Embed reports Utility: Set connection strings and credentials Power BI APIs Azure APIs for automation Provision workspace collections De-provision workspace collections Manage API keys Data Platform Programmatic Azure SQL Data Warehouse Spark on Azure HDInsight Azure SQL Database Microsoft Azure REST APIs Azure Resource Manager API Your app Power BI Embedded Power BI Embedded API surface EmbedCreate Deploy
Demo Power BI Embedded Provisioning
Embedding Reports
Users Application Permissions Auth. providers Power BI API keys Report 2 Workspace Report 1Token + Claim: Can view Report 1 + Expiration: 5 minutes API keys Copy API keys to your application Sign token Provide seamless authentication experiences EmbedCreate Deploy
Power BI Users Permissions Auth. providers API keys Token + Claim: Can view Report 1 + Expiration: 5 minutes User requests to view Report 1 Validate token API keys Report 2 Workspace Report 1 Application Provide seamless authentication experiences EmbedCreate Deploy
Provide seamless authentication experiences Power BI Users Permissions Auth. providers API keys API keys Report 2 Workspace Report 1Report 1 Application EmbedCreate Deploy
Demo Power BI Embedded Embedding Reports
Row Leve Security (RLS)
Embed Interactive Reports in Your Apps
JavaScript APIs
JavaScript API
Developer blog Samples https://github.com/Azure-Samples/power-bi-embedded-integrate-report- into-web-app/ Developer center http://dev.powerbi.com JavaScript APIs https://github.com/Microsoft/PowerBI-JavaScript/wiki/Understanding-the- object-hierarchy Need help? teo.lachev@prologika.com Home page https://azure.microsoft.com/services/power-bi-embedded http://blogs.msdn.com/powerbidev Resources

More Related Content

Embed Interactive Reports in Your Apps

  • 1. Embed Interactive Reports in Your Apps Teo Lachev, Prologika teo.lachev@rologika.com @tlachev
  • 2. Create compelling interactive reports Embed easily for faster time to value Deploy quickly and manage with ease You have the app. You have the data. Bring data to life inside your app with Power BI Embedded
  • 3. About Me Consultant, author, and mentor in Data Analytics Owner of Prologika consulting and training company based in Atlanta (prologika.com) Microsoft Gold Partner in Data Analytics Power BI Red Carpet Partner Microsoft SQL Server MVP since 2004 Founder and leader of Atlanta BI group (atlantabi.sqlpass.org)
  • 4. What's Power BI? Four products Power BI Service (powerbi.com) Cloud-based PaaS BI service Power BI Desktop free Windows app for designing self-service data model and reports Power BI Mobile a set of native apps for iOS, Android, and Windows devices Power BI Embedded Azure cloud service to embed Power BI reports in custom apps
  • 5. Power BI for You For business users 1. Connect to cloud or on-premise data 2. Explore data with reports and dashboards 3. Mobile applications For data analysts 4. Import data from virtually everywhere 6. Create rich self-service data models 7. Create business calculations For BI and IT pros 8. Enable team BI 9. Implement organizational BI solutions For developers 10. Real-time content and management REST API 12.Embed reports in custom applications11. Create custom visuals 5. Cleanse, transform and shape data
  • 7. Azure cloud service https://azure.microsoft.com/en-us/services/power-bi-embedded/ Enables developers and ISVs to embed reports for third party Priced per user session
  • 9. Microsoft Azure subscription Embed End users Workspace Workspace collection Developer Name Admin Users Endpoints Keys Gateways Credentials Geo Location Tags Name Reports Datasets Tags Your app 1,N Azure SQL Data Warehouse Azure SQL Database Power BI Desktop
  • 10. Power BI report Keep visuals up to date using DirectQuery Connect directly to the source without moving your data Build visualizations over very large datasets Azure SQL Data Warehouse Azure SQL Database Your app EmbedCreate Deploy
  • 11. Discovery: Enumerate datasets and reports Content Creation: Provision datasets and reports Embed: Embed reports Utility: Set connection strings and credentials Power BI APIs Azure APIs for automation Provision workspace collections De-provision workspace collections Manage API keys Data Platform Programmatic Azure SQL Data Warehouse Spark on Azure HDInsight Azure SQL Database Microsoft Azure REST APIs Azure Resource Manager API Your app Power BI Embedded Power BI Embedded API surface EmbedCreate Deploy
  • 14. Users Application Permissions Auth. providers Power BI API keys Report 2 Workspace Report 1Token + Claim: Can view Report 1 + Expiration: 5 minutes API keys Copy API keys to your application Sign token Provide seamless authentication experiences EmbedCreate Deploy
  • 15. Power BI Users Permissions Auth. providers API keys Token + Claim: Can view Report 1 + Expiration: 5 minutes User requests to view Report 1 Validate token API keys Report 2 Workspace Report 1 Application Provide seamless authentication experiences EmbedCreate Deploy
  • 16. Provide seamless authentication experiences Power BI Users Permissions Auth. providers API keys API keys Report 2 Workspace Report 1Report 1 Application EmbedCreate Deploy
  • 22. Developer blog Samples https://github.com/Azure-Samples/power-bi-embedded-integrate-report- into-web-app/ Developer center http://dev.powerbi.com JavaScript APIs https://github.com/Microsoft/PowerBI-JavaScript/wiki/Understanding-the- object-hierarchy Need help? teo.lachev@prologika.com Home page https://azure.microsoft.com/services/power-bi-embedded http://blogs.msdn.com/powerbidev Resources