Power BI visuals platform

Embedded analytics

Automation & embed capabilities

Service principal is generally available

We are excited to announce that service principal, released as preview back in February, is now generally available.

Service principal allows you to access resources or perform operations using Power BI API without the need for a user to sign in or have a Power BI Pro license. Service principal can also embed content for non-Power BI users in 3rd party applications.

Since the Preview release, the following capabilities have been added to service principal:

Schedule dataset refreshes – since service principal cannot log in to the Power BI portal, it cannot configure scheduled refreshes. To tackle this challenge, we released a new API that configures scheduled refreshes for datasets, so that service principal can use it. Learn more.

Share workspaces with service principal – Workspaces can be shared with service principal, just like any other Power BI user, by typing the service principal name in the ‘email address’ field. Power BI will auto complete the service principal name for faster searching.

Admin portal – enabling service principal is performed in the Admin portal. Now, a Power BI Admin can enable access to service principals for the entire organization.

Note: it is recommended to enable service principal access only from specific security groups. Learn more

Paginated reports brings a new set of enterprise reporting capabilities to the Power BI service. It enables developers and BI professionals to create and distribute highly formatted, pixel-perfect reports alongside their interactive Power BI content, becoming the first cloud BI solution that combines the power of self-service BI with the needs and capabilities of traditional Enterprise BI scenarios.

Today, we’re thrilled to announce the public preview of embedding paginated reports into your organization’s internal applications and portals. As part of this capability, you can simply get the embed URL by calling the GetReports API and use it to embed the paginated report in your application or portal. To get started, you can follow this article with the relevant modifications related to paginated reports.

The new and exciting Power BI Report Authoring SDK extension was added recently. This extension allows to programmatically create visuals, bind them to columns, measures, hierarchies, and personalize them by setting properties like axis visibility and titles. Installed custom visuals are supported as well!

Following are several use cases which are supported now by using the new API:

ISVs that provide their customers with a friendly 3-4 step wizard for self-creation and personalization of new visuals

ISVs that provide their customers with a friendly UI to customize existing reports for further exploration

A chatbot that builds embedded visual analytics in the bot, based on user inquiries

Improved rendering performance

The following improvements were added recently:

Embedding different reports into the same iframe – allowing apps that provide their end-users with a list of reports to use the same iframe, switch between the reports, and thus achieve better performance than embedding in new iframes. To use this functionality, all you need to do is to call embed() method with the same div element.
Code example:// Embed to reportContainer div element with embed configurationpowerbi.embed(reportContainerDivElement, embedConfiguration1);// Switch to another report on button clickfunction onButtonClick() { // Embed to THE SAME reportContainer div element with ANOTHER embed configuration powerbi.embed(reportContainerDivElement, embedConfiguration2);}

Query caching for embedded reports – Query caching is now available for embedded reports backed by Power BI Premium or Power BI Embedded capacity. Query Caching speeds up content loading by caching previously used query results. Controlling query caching is done on the dataset settings page in the Power BI service. Learn more.

Install version 2.6.5 or higher of Power BI client SDK. We continue to release more enhancements, so make sure to follow up from time to time and update your SDK version.

Avoid generating the embed URL yourself. Instead, make sure you get the embed URL by calling the Get reports, Get dashboards, or Get tiles API. We added a new parameter to the URL called config, used for performance improvements.

It’s also important to build your reports to be fast and reliable in any platform. Please follow the Power BI performance best practices article to make sure you use the best practices.

Power BI Embedded in Azure

Know what your Power BI Embedded capacity can handle

A tool for automating load testing of Power BI Embedded capacities was released recently. This tool can help you understand how much user load your capacity can handle when used. It uses PowerShell to create automated load tests against your capacities, and lets you choose which reports to test and how many concurrent users to simulate.

The tool will generate load on a capacity by continuously rendering each report with new filter values (to prevent unrealistically good performance due to report caching) until the token required for authenticating the tool against the service expires.

Using the new tool, capacity administrators can get a better understanding of how many users their capacity can handle in a given time frame. The tool can also be used by report authors that wish to understand the user load effect of performance improvements measured with Power BI desktop’s Performance Analyzer

While the tool is running, users can both see the renders happening in real time on their browsers, as well as connect to the XMLA endpoints of the capacities being measured with SQL Server Profiler to see the queries execute as they come.

To see the effects of the load test in the metrics app after the test runs, admins should expand the “Datasets” tab of their metrics app landing page and initiate an on-demand refresh by clicking “refresh now”. Admins should expect up to a 15 minutes lag from the time the test starts generating load until the time that load is visible in the metrics.

To host the tool and other future tools and utilities, we established a new GitHub repository. The entire repository is Open Source and users are welcomed to contribute, add additional tools and repositories related to Power BI Premium and Embedded capacities, and improve the existing ones.

Please be mindful of the existing load on your capacities and make sure not to run load tests during top usage times.
We look forward to hearing your feedback from using the tool and your contributions to the repository!

New resource creation and pricing experience in Azure portal

Users creating and managing Power BI Embedded capacities in Azure, can now enjoy a new user experience in the Azure Portal. The resource creation form is now a full-screen experience, and it displays a summary of the resource before provisioning. It also allows to create a resource with tags, and the pricing cards in resource creation, and scale experiences were replaced by a tabular design.

New region available for Power BI Embedded in South Africa North

Power BI now has its first available region in Africa, located in Johannesburg (South Africa North).

This new region allows customers to locate their Power BI deployments closer to their data sources, either in Azure or on-premises, enabling faster data refresh performance and lower networking egress costs.

With the addition of this new region, Power BI is now available in 19 regions in our global public cloud, in addition to 6 regions in our three national clouds, Power BI for US Government, Power BI Germany, and Power BI China.

Community forum for developers, to seek answers or ask any other questions you have.

Power BI Visuals Platform

Multi-selection support

As of API 2.6.1, Power BI visuals created with our SDK (aka custom visuals) support multi-selection, similar to out-of-the box visuals.

Previously, if you wanted to filter out this report based on two data points, for example: “Men” from the first visual below and “OH” from the second visual below (by holding Ctr+ multi-selecting), visuals in the reports were filtered out based on the second selection only, i.e., “OH”

Now, when you multi-select data points as shown below, the rest of the visuals in the report will filter out based on both selections (“Men”+ “OH”), as shown below.

We recommend that you enable this capability for all your visuals to provide a smooth and unified experience to all users.

How to enable this capability?

Simply add “supportsMultiVisualSelection”= “true” to the capabilities of the visual.

Context menu support

Last November we enabled the context menu (right-click menu) for visuals created by our SDK (aka custom visuals).

Users typically hover over data points in a visual for the right-click menu to be available.

To provide a unified and smooth experience to all users using any Power BI visual, we recommend that our developers and partners enable the context menu in their existing and new visuals’ submissions. We also updated our guidelines for Power BI visuals.

This is a heads-up that we’ll add this as a new requirement to our submission process for any new visuals or any updates of existing visuals in September.

Come and meet us!

Aviv Ezrachi, the Group Product Manager of Power BI for Developers, is delivering a breakout session about Power BI Embedded at the Data Platform Summit 2019 – Bengaluru India, Aug 22-24. Be sure not to miss it!