Microsoft Fabric Updates Blog

Asynchronous refresh now available in Power BI for public preview

We are excited to unlock additional asynchronous refresh capabilities for Power BI Premium, Power BI Premium per User, and Power BI Embedded! As Power BI becomes a superset of Azure Analysis Services, the asynchronous refresh REST API for Power BI brings built-in features for reliability, such as auto retries and batched commits. It is a significant improvement to the existing Power BI refresh capabilities, providing enterprise grade refresh capability for your largest datasets!

A critical requirement for most enterprise BI environments is an up-to-date data model. Due to long processing times or network interruptions, it can be a challenge to refresh your largest datasets. Client tools and processes such as SQL Server Management Studio (SSMS), PowerShell cmdlets, Tabular Object Model (TOM), or Tabular Model Scripting Language (TMSL) provide fine-grain dataset management capabilities inherited from Azure Analysis Services for semantic models. However, performing long-running refresh operations using these tools requires maintaining an ongoing HTTP connection. If either the client or network is interrupted, the processing operation is cancelled. Though there has been significant investment to ensure the stability of these methods, for your large datasets, it is more reliable to avoid long-running HTTP connections from client applications. Asynchronous processing eliminates the need for a synchronous client connection increasing processing reliability and enabling the scalability of your big data models.

Please visit our documentation page for details on how to use the REST API for Power BI. It covers how to perform asynchronous refreshes, check their status, and cancel them if necessary. Additionally, the C# RestApiSample code sample is provided.

Related blog posts

Asynchronous refresh now available in Power BI for public preview

November 10, 2023 by Christian Wade

Datasets are being renamed to semantic models in Power BI and Fabric. This will make the product clearer and more usable and reflects the immense progress that Power BI datasets have made in becoming an enterprise-grade semantic modeling technology. The semantic model name will help drive awareness of the unparalleled capabilities provided.

October 16, 2023 by Zoe Douglas

The model view now has even more to offer! We are excited to share the public preview of the Model explorer in the model view of Power BI Desktop.