Natively integrated Microsoft technologies

Office 365 is Microsoft's ubiquitous line of subscription services, which includes traditional Office applications plus other productivity services that are enabled via the cloud (the internet). Central to Office 365 is the concept of a tenant, an organization's very own slice of Office 365. Power BI integrates natively with Office 365 so that when a user subscribes to Power BI, the email address is checked for existing Office 365 tenants, and if one exists, the Power BI user will be added to that tenant. If an Office 365 tenant does not exist, Power BI will provision a new Office 365 tenant, sometimes called a shadow tenant, and the Power BI user will be added to that tenant.

Excel incorporates many underlying Power BI technologies as native add-ins. These include Power BI Publisher for publishing Excel files to the Power BI Service, Power Map for map visuals, Power Pivot, which provides access to Power Query, and the same underlying data model used by Power BI (SSAS Tabular) and Power View for additional visualizations. Excel is also a first-class citizen within the Power BI Service and is called Workbooks.

Microsoft Flow is a workflow technology that has a native connector for Power BI that supports both triggers and actions. Triggers are based on the Power BI Service's data alerts, and actions support both streaming and non-streaming datasets in the Service. Flow is actually part of the same group of applications within Microsoft, that is, the Business Applications Group.

PowerApps is a form of technology from Microsoft that provides a native connector to Power BI, as well as a custom visual. In addition, Power BI tiles can be embedded into PowerApps applications. Finally, PowerApps uses Power Query technology as part of its Data Integration feature. PowerApps is also part of the Business Application Group within Microsoft.

The Microsoft desktop application, Visio, has a custom visual for Power BI that was built by Microsoft. This visual allows you to link data within Power BI to a Visio diagram as values or colors that are displayed within the Visio drawing.

SharePoint provides the ability to embed Power BI reports within SharePoint via a native Power BI web part.

Dynamics 365 provides the ability to embed Power BI visuals natively within Dynamics 365 reports and dashboards. In addition, Power BI has native connectors for Dynamics. Finally, there are a number of apps available for Dynamics in the Power BI Service.

The CDS is actually central to PowerApps, Flow, Dynamics 365, and Power BI. The CDS allows an organization to store and manage data from all of these business applications within a set of standard and custom entities. Entities allow an organization to create a business-focused definition of their data and use this data within apps. Power BI has a native connector for the CDS.

As we mentioned earlier, the underlying technology behind Azure Analysis Services and  SSAS Tabular is also part of Power BI. In addition, Power BI has native connectors for Azure Analysis Services. Finally, an instance of Azure Analysis Services is included with a Power BI Premium subscription.

Azure ML technologies are becoming pervasive within Power BI. This includes the ability to create Columns from Example within Power Query, as well as custom visualizations such as the Key Influencers visual that's available in AppSource.

Power BI Dataflows have native integration with Azure Cognitive Services. This allows Azure Cognitive Services to use Sentiment Analysis within Power BI.

One of the native outputs from Azure Streaming Analytics is Power BI. This allows you to stream data that's running through Azure Streaming Analytics and display it on Power BI's dashboard tiles.

As we mentioned earlier, Power BI Report Server is a superset of SSRS.

Report Builder is a venerable Microsoft tool for the creation of paginated reports (RDL). These reports can be published to a Power BI Premium instance and displayed within the Power BI Service.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.21.105.193