Posts

Showing posts with the label Refresh

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...

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 Datamart...

New cache refresh settings available in Power BI Premium

Image
Earlier this year, we announced the additional  Analysis Services server properties  that are now supported in Power BI Premium and Power BI Embedded. With this capability, Power BI administrators can modify XMLA-based Analysis Services server properties to optimize, govern, and alter query behavior in their workspaces. Today, we are adding another familiar server property that will be supported in Power BI! We are happy to announce that ClientCacheRefreshPolicy is now a configurable property for your Power BI Premium workspaces. Admins can override scheduled cache refresh settings for an entire workspace, improving the performance of their semantic models. The default behavior in the Power BI service is to automatically cache dashboard, tile, and report queries upon refresh to provide an optimal report viewing experience. For enterprise semantic model deployments, where hundreds of reports and artifacts are built from a single Power BI dataset, automatic caches may cause perf...