180 likes | 199 Views
Power BI Embedded Bringing Analytics to your App. Brian Steele Senior BI Consultant December 11, 2018. bsteele@pragmaticworks.com. Your Current Situation. Do you currently have a customer facing application? Do you struggle with integrating your data for those customers?
E N D
Power BI EmbeddedBringing Analytics to your App Brian Steele Senior BI Consultant December 11, 2018 bsteele@pragmaticworks.com
Your Current Situation • Do you currently have a customer facing application? • Do you struggle with integrating your data for those customers? • What solution, if any, do you currently use to provide your customers with data?
Why Power BI? • End-Users Want • Built in analytics to help make decisions • Access to on real-time/on demand data • “Cool” factor • Business Wants • Offer in-context analytics • Increase User satisfaction • Attract new customers
So what is keeping us from providing that? • Investing in developer time is costly • Building from the ground up is complex, costly and time consuming • Traditional 3rd party software licensing is expensive
Power BI Advantages • Easy to connect to the data you need • On premise/In the cloud • Multiple sources • Data can be accessed in multiple ways • Updated or real time using Direct Query • Scheduled Refresh • Streaming Data • Open and extensible platform in Azure • Scalable • Access to New Advanced Tools like Streaming/Machine Learning
Embedding Power BI • Embedding for your organization (User Owns Data) • SharePoint Online • Microsoft Teams integration • Microsoft Dynamics • Embedding for your Customers (App Owns Data) • Single Power BI PRO Account • User does not need to have/know Power BI • User does not login to Power BI/Does not need to be AAD User
Embedding Context for Customers • Authorizing Power BI Analytics to your Application • Lets the application manage authentication • Take advantage of row level security • Embedding the Power BI Visualizations • Using the Power BI REST APIs • Simplified using the Power BI .NET SDK • Interacting with the Visualizations • Enabling client-side functionality with Power BI JavaScript SDK • Set specific info like Filters and Paging using JavaScript
Embedding Context for Customers - Authorize • Sign in to Power BI – Must have a Power BI Pro Account • Register your application – API Access • View • Edit • Create • Create a workspace • Import content • Grant permissions
Embedding Context for Customers - Embedding • Update the Web.config • Application ID • Workspace ID • Report ID • Finding your Workspace ID/Report ID in Power BI • Provide your Power BI Pro Account User Name and Password • Power BI REST API/.NET SDK To Build the Report Token
Embedding Context for Customers - Interacting • Power BI JavaScript SDK • Using the JavaScript “Sample Tool” for Code Examples • https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html#
Real World Example – Physician Portal • Customer Facing Application with Specific Data Based on Login • ASP.NET Core 2.0 Website • Need Analytics About Document/Physicians in the System • Previously Using Telerik Chart Controls
Resources • Power BI Developer Page • https://powerbi.microsoft.com/en-us/developers/ • Power BI Embedded Page • https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html# • GitHub Examples • https://github.com/Microsoft/PowerBI-Developer-Samples • Power BI Embedded on Azure • https://azure.microsoft.com/en-us/services/power-bi-embedded/
And More… • Self-service big data prep and paginated reports support in Azure capacities (paginated reports are not yet available in embedded) • New capacity Metrics to monitor workloads • Azure resource Health monitoring • Zero Downtime Capacity Scale • Usage metrics available for embedded reports and dashboards • Create a new workspace experience through API