Forum Discussion

HRM5's avatar
HRM5
Frequent Visitor
4 years ago

Incremental Refresh takes same time as Full refresh in PBI Service

Hi, I have applied incremental refresh on a fact table and after implementing that the Dataset is taking the same time to refresh as the normal refresh takes it. What's the problem with my config...
Show and Tell
Tips and Tricks
HRM5's avatar
HRM5
Frequent Visitor
4 years ago

Anonymous 

Hi,

 

I am using Oracle as a Database and On-Premise Power BI gateway to run my Reports and after implementing Incremental Refresh my dataset is taking almost 2 hours to refresh even the dataset is limited to 1 year of data.
I have checked it on connecting the Workspace to SQL server to see the partitons and there is only one partition showing onto that.



Can you help

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi HRM5 ,

 

I apologize for not getting back to you in time.

Have you solved the problem? I found a document with specific instructions on how to troubleshoot long incremental refresh times. Hope it can find you well:

 

Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Docs

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly