Posts

Showing posts from 2022

Enhanced refresh with the Power BI REST API is now generally available

We’re excited to move Enhanced refresh with the Power BI REST API (formerly asynchronous refresh) from public preview to general availability in Power BI Premium, Power BI Premium per User, and Power BI Embedded. As noted in the public preview announcement, this feature not only eliminates the need for synchronous client connections to perform a refresh, but also unlocks enterprise-grade refresh capabilities. It’s a significant improvement over the standard refresh REST API in Power BI. By using the enhanced refresh REST API, you can leverage built in features for refresh management, reliability, and granularity as shown by the following examples. Cancel an in-progress refresh operation. Check the status of historical, current, and pending refreshes. Refresh individual tables and individual partitions. Batched commits with restarts so long refreshes do not need to start from the beginning in cases of transient failure. Application of incremental refresh policy. Control the Analysis Ser

Simplifying capacity management with unified v-cores

Image
We’re excited to announce a platform update to simplify the way customers manage Power BI Premium capacities.  Starting on December 11th 2022, we’ll be rolling out changes to unify the concepts of front-end and back-end virtual cores for capacity management.  Unification of these concepts addresses the feedback we’ve heard from customers who sometimes misinterpret the concepts of customer-managed v-cores from Microsoft managed v-cores.  This change will simplify the model used by customers to both manage capacities and rationalize usage metrics against capacity sizing decisions. How do Premium capacity v-cores work today? Power BI Premium has historically used v-cores as the unit of measure that customers use to reserve compute resources when purchasing a capacity.  After a capacity is purchased, its resources can then be used to run a variety of Power BI workloads.  Before this change, purchased v-cores in a reserved capacity would be split evenly between front-end cores used by Micro

Subscribe to a report with filters applied Power BI

Image
Subscriptions are a great way for you and your colleagues to stay on top of your reports right from your inbox. We’re excited to announce a highly anticipated update to subscriptions: you can now create a subscription to a view of a Power BI report uniquely relevant to you! Include changes in your subscription When creating a new subscription, you’ll see a new  Include my changes  option if you have made changes to the report (e.g., applied filters or selected a slicer value). By selecting the  Include my changes  option, the view of the report sent to your email will capture any changes you have made to the following: filters, slicers, personalize visuals, cross-filtering or cross-highlighting, drill down or drill up, and spotlight. Deselecting the  Include my changes  option will create a subscription to the report in the default view as created by the report author.   Email link also captures your changes The recurring email you receive in your inbox will continue to show your lates

Announcing: Enterprise scorecards with hierarchies and linked metrics in Power BI Metrics

Image
Metrics in Power BI lets customers curate their metrics and track them against key business objectives all in one place, enhancing data culture by promoting accountability, alignment, and visibility for teams and initiatives within organizations. We are excited to finally announce two much anticipated releases in our Metrics experience. With  hierarchies and linked metrics , it’s easier than ever to automate your metric values so you can spend less time crafting multiple scorecards and connections, and more time analyzing your metric performance. Hierarchies is a premium or PPU feature, and linked metrics is a Pro feature. These two features enable easy, large scale enterprise scorecard deployment, allowing automated views of cascading scorecards and linked metrics that show up and are sync’d on multiple scorecards. Let’s take a look at how you can create your widespread scorecard solution: Cascading scorecards with hierarchies: Let’s start with hierarchies. This is a premium feature a

Dataset refresh cancellation is now available in Power BI Premium

Image
We are excited to share that cancelling an in-progress dataset refresh in Power BI Premium, Power BI Premium Per User, and Power BI Embedded just got significantly easier. A top-20 idea on Power BI Ideas (we do listen and appreciate your feedback), we acknowledge that this capability couldn’t have come soon enough for our customers. In the past, cancelling an ongoing refresh was an unreliable process that required external tools. Earlier this year, we released the Enhanced refresh with Power BI REST API, that – in addition to XMLA based refreshes – allows refresh cancellation. However, it requires the refresh operation to be triggered by the API. Today, users can cancel an ongoing scheduled or on-demand refresh using a contextual button in the Power BI service. Earlier limitations that constrained cancellation no longer apply. To begin using this feature in your Premium workspace, no actions are required. Please note that for datasets created as part of Datamarts, the refresh operation

Power BI November 2022 Feature Summary

Image
Welcome to the November 2022 update! This month we introduce an Optimize ribbon which makes your report creation experience more streamlined, especially if you are working in DirectQuery mode. Also new this month are Linked Metrics and a new EvaluateAndLog DAX function that enable you to log intermediate values of your DAX expressions. There is more to explore, so please read on! Announcing New Power BI Color Accent Reporting Unshared and unsynchronized axes for small multiples charts Controlling and customizing labels on Azure Maps Create dynamic slicers using field parameters  Composite models over Power BI datasets and Analysis Services  Modeling Streamline your report authoring experience with the Optimize ribbon  New DAX function: EVALUATEANDLOG New DAX functions: TOCSV and TOJSON Data connectivity and preparation Azure Databricks, Databricks Dremio Cloud Kognitwin Spigit, Projectplace, Planview Enterprise One – PRM, Planview Enterprise One – CTM SumTotal Service New way to upload