Forum Discussion

GARYSS's avatar
GARYSS
Regular Visitor
3 years ago
Solved

Incremental refresh process

Good day.

 

Just seeking to confirm how the incrementl refresh process works.  Understand it only works with Premium level license.  The reports  have been created in Power BI Desktop and posted to the Service where they are posted along with the Dashboard created at the Service level.

 

Does the incremental refresh:

1) connect to the data source(s)

2) perform the Transformations for each data source

3) load the incremental data from the data sources

4) perform the Applied Steps on the table columns

5) perform the update to the Merge Table of the 2 data sources

6) Update the Desktop Reports

7) Update the Service Reports

😎 Update the Service Dashboard.

 

Appreciate anybody willing to set me straight on this.  Thank you, in advance, for your time.

Sincerely,

Gary 

Need Help
  • GilbertQ's avatar
    GilbertQ
    3 years ago

    Hi GARYSS 

     

    When using Incremental refresh it will only apply to the tables where you applied the Incremental refresh policy.

     

    On the table where it has been applied it does the following:

     

    • The first time you upload the PBIX to the PBI Service and refresh the dataset it will refresh all the data and create the incremental partitions.
    • It will run through the steps in your table and apply the date filter and only upload the newer data to your dataset.
    • All your service and reports will always look at the entire dataset and will show the new data once the dataset has been refreshed.

     

    Here are more details: Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

4 Replies