Automation & life-cycle management

Power BI Embedded in Azure

Dataflows and Paginated reports are now available on Azure capacities. Until now, your capacity resources were used exclusively to run queries on your dataset but now new services (named ‘Workloads’) are available to use the same resources in the capacity. They will join the existing data querying load, which is now called ‘Datasets workload’. Dataflows make data preparation easy, so fewer specialized skills are required to transform and clean up data.

Use the Power BI admin portal to get started for now, and Power BI REST API in the coming weeks. You can set the maximum memory consumed to give you control of your capacities. For more information, see configure workloads and Default memory settings.

Memory Per Workload– presents the usage of memory in your capacity resource per workload.

QPU Per Workload– presents the query processing units load on your capacity, per workload. A Query Processing Unit (QPU) is a unit of measure of relative computational performance for query and data processing. 1 core approximates to roughly 20 QPUs so with an A1, for example, you have values between 0 and 20 QPUs, where 20 represents 100% load.

The existing Memory and QPU metrics cannot be broken to specific workloads and will always show the total load on your capacity. To monitor workloads separately, use the new metrics. The remaining metrics, namely ‘Memory Thrashing’, ‘Query Duration’ and ‘Query pool job queue length’ are relevant only to Datasets workload.

The images below illustrate how you can select ‘Memory per workload’, for example, in your Power BI Embedded resource, go to ‘Metrics’ and choose ‘Memory Per Workload’.

click on ‘Apply splitting’ and select to split by workload to obtain a view presenting the memory per each of your workload (Dataset and Dataflows in the case demonstrated).

Viewing Memory Per Workload for the enabled workloads Datasets and Dataflows.

Azure resource Health monitoring

Power BI Embedded is integrated with Resource Health monitoring. Resource Health helps you monitor the availability of your resource and diagnose the root cause in case of unavailable status. Any status change will be reported in real-time.

You can find the Resource Health info in your resource blade in the Azure portal, under ‘Support+ troubleshooting’ (see image below). You can also view Power BI Embedded health alongside all your managed resources in Azure, under the main ‘Resource Health’ page.

Zero Downtime Capacity Scale

To remove the delay in content availability when a Power BI capacity resources scales up or down (in Azure portal or using ARM API), we have introduced the Zero-Downtime-Capacity-Scale PowerShell sample script, that calls the Power BI API and ARM REST API to programmatically scale capacity resource with no downtime. This means all embedded content is available during the scaling process. It also provides an option to reassign workspaces from one capacity resource to another.

The script avoids downtime by creating a temporary capacity resource, and reassigning the workspaces to it during the scaling process. Once the procedure is completed, the workspaces are assigned back to the original capacity resource and the temporary capacity resource is deleted. You can find this script and other automation scripts in Power BI PowerShell samples repository.

Embed capabilities

Usage metrics available for embedded reports and dashboards

Power BI enables authors of reports and dashboards to measure their impact using the ‘Usage metrics’ report. This feature is now available for authors of Power BI content when you are embedding for Power BI users in your organization.

The report shows the usage patterns across an organization and can help drive projects, make informed decisions, and provide valuable usage information, such as:

The frequency at which each type of content is viewed.

Areas for investment to improve analytics or increase user engagement.

Executive view of analytic engagement across the organization or customers.

With drill through report authors can create a page in their report that focuses on a specific entry. By right-clicking on a data point in other report pages they can drill through to the focuses page to get details that are filtered to that specific context.

The custom visuals marketplace has been growing rapidly over the past months, and it’s time we take a step forward. As such, we’re changing the policy so that custom visuals with additional purchases may also be submitted to AppSource.

What is a visual with additional purchases?

A visual with additional purchases is similar to in-app purchase (IAP) adds-in in the marketplace, those adds-in have a price tag "Additional purchase may be required". IAP custom visuals are free, downloadable custom visuals – users pay nothing to download those custom visuals from the marketplace. IAP visuals offer optional in-app purchases for advanced features.

What’s in it for you?

IAP custom visuals in AppSource, will be discoverable to the many daily visitors, bringing valuable traffic and increased awareness for your IAP custom visuals and to you as the developer.

If until recently you managed those visuals through your website, now you can submit them to AppSource. Which will increase the level of discoverability and visibility of the IAP visuals inside the Power BI community.

Visuals in the AppSource enjoy a Direct feedback channel from your customers who are using the IAP custom visual, through the reviews and rating system in the store.

Once the IAP visual was approved by the AppSource validation team, you may also submit those visuals for certification. It is an optional process.

Once the visual is certified, IAP custom visuals can be exported to PowerPoint and displayed in the emails received when a user subscribes to report pages. So today by submitting IAP visuals to the marketplace, IAP custom visuals can also be certified and support extra feature set.

What is changing in the submission process?

The IAP custom visuals submission process to the marketplace, is same process as for free visuals. It happens through the seller dashboard. The only change to the submission process is that you’ll need to state in the developer notes in the seller dashboard: “Visual with in-app purchase”. You’ll also need to provide a license key/token, if required to validate the paid/advanced features.

In addition, please let users know what to expect by providing in your store long description which features are free and which features require additional purchases to operate.

What should I do before submitting my IAP custom visual?

If you’re working on an IAP custom visual or already have one, please make sure that it complies to the guidelines.

If you have a logo in the custom visual, make sure it complies to the guidelines (color, location, size and action triggering) as described in the guidelines.

You can also find, in the guidelines, best practice notes. One of the notes relates to the landing page API, which will be available during this month (please follow our blog for updates).

The landing page is the first page displayed when user inserts the visual into the report.

Today custom visuals' first time insertion page is a permanent watermark. Once we release the API, you will be able to edit this page and add information on how to use the visual, features, and license related issues.

Can I get my IAP custom visual certified?

Yes, same with free visuals. Once your IAP custom visual is approved by the AppSource team, you can submit your visual to the certification process.

Please note that in order to certify your visual, it should comply to the certification requirements, for example the visual cannot access external services for licenses validation. This should be done within the IAP visual if you want to certify it.

Recall certification is an optional process, it is up to you to decide if you want your IAP visual to be certified.

How to get support?

Feel free to contact the custom visuals support team: pbicvsupport@microsoft.com with any question, comment, or issue you may have.

Looking forward to your contribution to the custom visual community!

As always, feel free to use all the communication channels at your disposal to connect with our team, share your thoughts and ask questions:

Sign up for the Power BI Newsletter

Sign up below to get the latest from Power BI, direct to your inbox!

By clicking Sign up today, you are giving your consent to Microsoft for the Power BI newsletter program to provide you the exclusive news, surveys, tips and advice and other information for getting the most out of Power BI. You can unsubscribe at any time. Microsoft Privacy Statement.

What is Power BI?

Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device.