Microsoft Press ebook Introducing Power BI PDF for mobile

Figure 8-25: Request made through Q&A for the number of requests made today. Power BI embedded in applications Another extension available through the Power BI REST API and specific libraries to manage authentication for custom application is Power BI Embedded, which is an Azure service with which you can set up integration between an application and Power BI services. For example, consider a service that collects data about personal bicycle trips. This service has a web application to manage the configuration and manual upload of data, even if most of the information will be sent by specific devices and/or apps. When it comes time to analyze 381 C H A P T E R 8 | Using Microsoft Power BI in your company

data, it would be nice for this application to use Power BI services. One way to obtain this integration is to export data to Power BI and create custom data models and reports. For the company that provides this service, it could be a good idea to create a service content pack to make it easy for existing Power BI users to import their data. However, this approach requires all users to create their own Power BI account (even if it is a free one), whereas the application instead should have some embedded solution to display standard reports containing personal data. By using Power BI Embedded, the developers who build the web application can design these reports and publish them within their application in a seamless way. In this way, the web application can show a report containing data of the user who signed in within the same webpage, and without requiring additional authentication to the user itself. The process is completely transparent to the user. More info You can find documentation for Power BI Embedded and its pricing details at https://azure.microsoft.com/services/power-bi- embedded/. 382 C H A P T E R 8 | Using Microsoft Power BI in your company

Note It is worth to mention that we showed you another type of web publishing in Chapter 2, the Publish To Web feature. The main difference between Power BI Embedded and Publish To Web is that the former controls the authentication of the user and can display customized content within the same report, whereas the latter only shows the same content to anonymous users. Conclusions In this chapter, you learned how you can use Power BI in your company, what the architectural implications of the many options available for data refresh are, how to manage security, and what the options are to customize Power BI and/or integrate it with existing applications. Here are the most important features you learned:  Available options to update data with scheduled refresh or live connections  Integration of Power BI with Microsoft Office  Control data access for specific users with row-level security 383 C H A P T E R 8 | Using Microsoft Power BI in your company

 Possible extensibility options using the Power BI REST API Power BI is an open ecosystem that is constantly growing, thanks to the features added by Microsoft and those additional options provided by third-party groups, which use the same API you can use to customize and extend Power BI according to your specific needs. 384 C H A P T E R 8 | Using Microsoft Power BI in your company

About the authors Marco Russo and Alberto Ferrari are the founders of sqlbi.com, where they regularly publish articles about Microsoft Power BI, Power Pivot, DAX, and SQL Server Analysis Services. They have worked with DAX since the first beta version of Power Pivot in 2009, and, during these years, sqlbi.com became one of the major sources for DAX articles and tutorials. They both provide consultancy and mentoring on business intelligence (BI), with a particular specialization in the Microsoft technologies related to BI. They have written several books and papers about Power Pivot, DAX, and Analysis Services. They also wrote popular white papers such as “The Many-to-Many Revolution” (about modeling patterns using many-to-many relationships) and “Using Tabular Models in a Large-Scale Commercial Solution” (a case study

of Analysis Services adoption published by Microsoft). Marco and Alberto are also regular speakers at major international conferences, including Microsoft Ignite, PASS Summit, and SQLBits. You can contact Marco at [email protected], and Alberto at [email protected].

Free ebooks FromFtroemchtenchinciacall oovverevirevwisetowdsrilltdoowdnsriolnldspoecwianl tsopoicsn, get Free ebooksspeciafrleeteobpooickssf,rogmeMticfrroesoeft ePrbesos aot:ks from Microwswowf.tmPicrroesosfstvairttu:alacademy.com/ebooks Download your free ebooks in PDF, EPUB, and/or Mobi for www.Kmindiclerfoorsmoatfst. virtualacademy.com/ebooks DownwLloohoekarefdoyroyoutohcaeunrrglerfaerranet nereesweoubsrkcoiellssoaaknt dMshiicenrlopstoahfdtvrVaeinretcueafylooAurcramcdaearmeteysr, : with free Microsoft training delivered by experts. From technical overviews to drilldowns on special topics, get • PDfreFe ebooks from Microsoft Press at: • EMPwoUwbwBi.mfiocrrosKofitnvidrtulealacademy.com/ebooks • Microsoft PressDownload your free ebooks in PDF, EPUB, and/or Mobi for Look Kfoindrleofothrmearts.great resources at Microsoft VirtuaLlooAkcfoardotehemr gyre,awt rheseourrecesyaot uMiccroasnoftlVeiarturanl Ancaedwemy, skills awhnedre yhoeulcpanaledarvnannewcsekilylsoanudrhcelap raedvearncwe yiotuhr cfarreeeer MicrowsiothfftreterMaiicnroisnofgt trdaienilnigvdeerlievedredbbyy eexxpperets.rts. Microsoft Press