Intro to Power BI Embedded and APIs

[Music] hello everyone and welcome to intro to power bi embed analytics and apis my name is amit shuster i'm a product manager for power bi embedded so let's get started today i'm going to show you an intro to power bi we're going to cover all the probably embedded apis how to get started and at the end we'll talk about licensing so let's talk about power bi power bi lets you experience your data any data anywhere any way you want so your data can be either on a cloud data or on-premises data and you connect it to power bi where you get all the services that power bi gives you which can be template apps real-time dashboards and interactive reports where you can slice and dice your data you also have support for natural language query custom visualization that you can create yourself and and the integration with office from power bi you can consume these reports or other items through the web in a mobile app you can export the data to excel and you can also get it inside your website or web application which means to embed it in your application so let's talk about gartner you can see here the uh gartner magic quadrant for analytics and business intelligence platforms this is from february 2020 and you can see on the right upper side microsoft is a leader at the in the analytics and bi platforms so when you're you want to get analytics in your application you have two options the first one is to build it so you build your analytics solution um this can take a lot of effort a lot of resources um and you don't have all the advanced feature um that you can get when you buy the best fit solution so for example if you get power bi you get all the features of power bi inside your web application and why why do you even need embed analytics products so well let's talk about three different things so for your business it gives you a faster time to market you don't need to develop the things by yourself you can stand out like get the best analytics you can get today on the market and it can offer new revenue streams for you if you're an isv that's that build other companies and analytics solutions for a developer it gives the focus on your product they don't need to build uh the analytics solution they just need to connect the data to an existing analytics solution um and it also supports all kind of like and it also supports a library of apis and sdks and for your customers they can explore the data from any device from their mobile from their web portal or application you can make decisions in context so you can see the data and then take an action from the data itself and you can keep the analytics inside the application so you don't have to go for example to power bi service powerbi.com to consumer analytics you can get it inside your application with power bi embedded so let's see what power bi embedded is so what is power bi embedded power bi embedded is built on decades of analytic expertise of microsoft it gives you total control of visuals and user experience and if you're using the isv scenario which also called embed for customers your end users don't need any and user licensing it was built for software companies and if you look on the right side you can see the gif of customer service insight which i will show you live in a second so let's go to this demo here you can see customer service inside sample environment you can see the power bi report embedded inside their application we can switch between the tabs for example if i click here to new cases and get the other report page with the popular topics and merging topics what i can do here i can right click and use all the power bi uh features including uh topic drill through so if i'll click on topic drill four you can see here all the details of the specific topics including the topic case consumption for example so this is actually a power bi embedded reports embedded inside customer service insights web application so this is what you can achieve with power bi method so let's talk about the power bi embedded api surface power bi apis let you manage all your analytics objects let you get the reports and you can also automate on boarding new customers embed reports and dashboards and and get all the details from our apis we also have azure apis for automation that lets you scale up and down the capacity and you can monitor the performance uh using metrics and alerts and if your capacity gets to some usage for example or the memory exceeds some limit that you set on on the azure alert you can scale it up and down and last we have the power bi javascript api that lets you build your client-side integration and interaction and gives your users the best user experience this javascript api used to embed the report and also use to communicate between the power bi report and your application so what power bi solutions do we have we have power bi.com which is also called the power bi service we have embed for your organization and embed for customers which is our probably embedded main two scenarios and both of them are powered by the javascript sdk embed for organization is when you're embedding four internal users so all the users need to have azure active directory users and they use their own accounts to authenticate when we talk about embed for customers we have one identity which can be either a service principle or a master user that manages the authentication for your end user and generate an embed token for each end user with his own uh permissions and our last rules for example um next we have the url embedding in website or portal so this is also called uh simplify.mad and it just gives you um an iframe code to embed in your web application where you have a sign-in button inside this iframe and you don't need to work with code and so this is our last code no code approach we also have the embed in sharepoint and teams where you can just add a report to sharepoint and teams and now we also support embedding in powerapps and for the last we have the published web where you make your data public and everyone can access it this is mostly used for journals um so all the ford as you can see or five that you can see on the left side requires end user authentication to power bi so as i mentioned all the users are internal users um who have aad accounts and the other to embed for customers and publish to web don't require your users to have end user license so let's talk about typical sas applications each app drives a specific value for your users analytics is most valued when integrated into an application workflow so let's start from the data connectivity this is what you can see on the bottom the application storage so power bi uh supports over 100 data connectors um we support uh direct query cached cached mode real time you can your data can be either in the cloud on on premises you can manage your data set and data sources using our power bi apis and above that we have the application so the application lets you integrate your analytics into your app logic and use the bi-directional api to increase engagement so you can really work take actions from your data so let's have a look at it so this is the power bi javascript api here on red you can see the iframe boundaries so this is the client application and this is the embedded report um and as i mentioned before this is the iframe boundary and the javascript api allows you by using events to communicate between the client application and the embedded reports so the power bi javascript api let you communicate between your um power bi report and your application and you can listen to events and get uh and take actions from your data so let's have another demo um where i show you the power embedded api surface i'll show you the rest apis and the try it option and the javascript uh on the power embedded playground so let's have a look at the power bi rest apis here you can see all the different operation groups and for example if i'll go to reports and then i go here to the api for get reports in group you can see here i have the api documentation if i go here and click on try it i here i do some sign in for the service you can it's just an interactive sign in where you can choose your user and all you need provide here for the parameters is a group id so i'll go to power bi this is my workspace and i'll just go here to the url and copy from here the workspace id and if i'll click here on the group id i'm getting here adding here the group id that i just took and i'm clicking on run this will get me all the uh reports that i have on this workspace so this is just one of the use of the rest apis next we're going to talk about um the power bi embedded playground so the probably embedded playgrounds let you interact with different samples and see if all the client-side apis that we support so if i'll go here to the sample report first i can choose if i want to see it in view mode edit mode or create mode so i'll just click run and run the code that let me embed my power bi report in view mode and you can see that the report is now loaded at the bottom of this page and if i'll go here at the top to the interact i can see here all the different apis that we support for the client side so i can just go here and choose filters and slicers for example and i can set slicers set slicer state and when i click run you can see that this slicer state was set to specific dates and all the data is filtered for the same range of dates we also have set of apis for example to do some report offering so if i'll go to offering and choose create visual and personalize and then i can just click run and get directed to a new page where this visual is created and i can also change this visual type for example and add a new data field to this visual all using our apis another thing that we have here on the power bi embedded playground is the showcases and the showcases show you some advanced use cases for our apis so for example let's have a look at the insight to action the insight to action showcase shows you how to leverage the menu extensions and export data apis um to get you the ability to take meaningful actions um so here i have my report i have all these slicers at the top where i can choose which customers i want to target so let's say i want to see all the people that spent between 100 and to 300 and they did their last purse at let's say 25 days to 120 days so here i got this list of four customers that i can now go to the options menu and here you can see the new menu extension that we added here um as part of barbie embedded and when i click on this start campaign what happens is that there is an event that lets me communicate with my application code and this will open a dialogue so this dialog is not part of power bi report anymore this is just part of your application and you can have any logic that you like here here i just have these customers where i can do another filtering of the customers for the customers and get all the details and then i can choose either to send a coupon or send a discount for them and this is just one example of the use cases of connect of insight to action so how do you start with power bi embedded first you need to create your analytics uh this is done is done by analyst in power bi desktop which is a free tool uh next you need to provision you need to set up your embedded solution you need to create it up on azure and give it the right permissions and after that you need to develop your application which contains both the rest apis and javascript apis so we have the server side where you use the rest apis um for your permission logic for example to get the reports to get embed url to generate the embed token and we have the javascript api which lets you do the actual embedding of the iframe and all the interactions and apis for your end users after that when you need to deploy your solution you can scale using capacities based licensing where your application is getting to the end users in your website and portal so let's talk about no end user licensing when you're embedding for your customers you don't need your customers don't need end user licensing as i mentioned before you can use one identity which is either a master user or service principle to get the analytics to your end user so the creation and development testing is free you have a free trial for embed tokens on the azure services when you get an a capacity you can pause and resume it and and it's flexible and you only pay by the hour so if it was uh so it's starting from about one dollar to an hour uh to thirty two dollars per hour um and you can scale between the capacities according to your demand so if you have a peak hour and there's a lot of customers that's using the reports you can see the metrics and you can scale your capacity up so everyone will get the best service um and it's bring your own authentication so you can use any authentication that you like um so the customer like your end user is connecting to your application based on your authentication and then based on on the identity of this user you generate the appropriate embed token for him so let's talk about licensing power bi capacities is a dedicated resources that you need when you move to production and you want your end user to consume the analytics so we have the asus ems queues and psqs and let's see the difference between these queues so the sqs you can buy on azure and the other two skus em and p um you buy on office um the aceqs are using to embed content in your application uh which is the embed for your customers where the ems queues and psq's can be used uh to share content with power bi uh free users so it can be used for embed for organization um the main difference between these offering is that the billing for aceqs is hourly and you don't have any commitment where on em skus and psq's you have either a monthly or yearly commitment um and they're not flexible so you can't scale them up and down where on the a skus you can scale them up and down you can pause and resume them and all is done through the azure portal or our apis um so uh probably embedded a sku's uh pricing starts from seven 750 dollars per month or about one dollar per hour you can see here all these cues starting from a1 to a6 and how many virtual cores and memory you get for each of the skus this can also be found in our documentation and here you have some of the developer resources that can be really useful for you the links with developer center developer documentation probably embedded playground that i just showed you um our samples uh where you can start by downloading a sample and just insert your workspace id report id your tenant your application nd and and you can get uh application secret and just get up and running really quickly um we have here the link to our javascript uh wiki our rest api documentation and our onboarding tool so that's all i hope you enjoyed this session i was amit and this was power bi embedded in apis thank you very much [Music] you

Channel: SQLBits

Views: 3,741

Keywords: Cloud, Developing, Managing, Power BI Embedded

Id: WLRSI5PMzSk

Length: 19min 15sec (1155 seconds)

Published: Tue May 11 2021