Dataset Refresh History Enhancements

Power BI makes automatic multiple attempts to refresh a dataset in case of a failure. The newly-added ability to visualize all refresh attempts on the page, along with insight into the cause of any failures or unusual durations, can be valuable. It's worth noting that this information is helpful not just when refresh fails but also succeeds.

 

• A successful refresh that took longer than expected might have succeeded only after several prior failures.
• To access detailed error information for each attempted refresh, users can simply click on the “(Show)” link within the row of any failed attempt.

 

A Power BI dataset refresh operation may involve different refresh types and steps. Each refresh attempt comprises two operations: Data – Load data into the dataset and Query Cache – Premium Query Caches and/or Dashboard Tiles refresh.

 

• Excessive use of dashboard tiles and premium caching can potentially increase the overall refresh duration.
• This information can assist in quickly detecting any such scenario and taking appropriate steps like reducing dashboards or disabling automatic cache refresh.

 

The data and query cache phases are independent of each other, but run sequentially. If the “Data” phase is completed successfully, the data is up-to-date even if the “Query Cache” phase fails or takes extra time.

Depending on the location of your Power BI tenant, this feature may take up to two weeks to appear. Refreshes made via the enhanced refresh API and/or XMLA Endpoint won’t show attempt details.

 

More insights on Dataset Refresh History Enhancements

 

Microsoft's augmentation of the dataset Refresh History on Power BI is significant for users struggling with dataset refresh disparities. The improvement allows users to visualize every refresh attempt, successful or not, giving a deeper understanding of refresh activities. It leads to more efficient troubleshooting, revealing previously hidden issues such as multiple failed attempts before successful refreshes. This feature is a game-changer, notably for organizations that rely heavily on up-to-date data for critical decision-making.

 

Read the full article Dataset Refresh History Enhancements

Learn about Dataset Refresh History Enhancements

The main topic is about the enhancements in the Dataset Refresh History page of Power BI reports to improve the handling and troubleshooting of data refresh operations. This includes details for each refresh operation allowing users to diagnose why a refresh may have taken longer than expected. An automatic refresh attempts tracking feature is introduced where Power BI makes multiple attempts to refresh a dataset if a failure is encountered.

 

One can visualize all refresh attempts to gain insight into the reason for failure or unusual duration. The refresh operation can involve multiple types and steps, each refresh attempt is divided into two operations: Loading data into the dataset and Premium Query Caches or Dashboard Tiles refresh. Optimization techniques like reducing the number of dashboards or disabling the automatic cache refresh setting can be used to manage the number of cache related queries.

 

More links on about Dataset Refresh History Enhancements

Dataset Refresh

Feb 27, 2023 — After I executed the script and check the Refresh history of the dataset in Power BI Service, I'll see Via Enhanced Api as Type.

Refresh Extracts - Tableau

You can see a history of when the extract was refreshed by selecting a data source on the Data menu and then select Extract > History.

Refreshing SPICE data - Amazon QuickSight

An incremental refresh queries only data defined by the dataset within a specified look-back window. It transfers all insertions, deletions, and modifications ...

Visualise your Power BI Refresh

Feb 15, 2021 — Visualise your Power BI Refresh · Connect to Analysis Services and run a trace using SSMS Profiler · Kick off a dataset refresh · Save the trace ...

Automating Your Power BI Refresh History

Load_PBI_Refresh_History stored procedure – receives JSON data from the API, converts it to rows and columns, and merges it into the PBI_Refresh_History table.

Updating or Refreshing the DataSet for a Visualization Card

Intro. You can update or refresh the DataSet for any card you have edit access for. You can do this in the card view or the Details view.

What's New for Oracle Analytics Cloud

Here's an overview of new features and enhancements that're coming soon to improve your Oracle Analytics Cloud experience. Topics: September 2023 Update ...

Run Data Sync and Recipes to Create and Refresh Datasets

To get the latest data, always run a data sync job to synchronize your data with the source before you run your recipe to load data into the dataset. To run ...

Keywords

Microsoft Power BI updates, Dataset refresh issues resolution, Power BI refresh failure diagnosis, Power BI automated refresh attempts tracking, Enhancements in Power BI Refresh History page