cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Incremental Refresh with Excel Files?

So we have hundreds of Excel workbooks sitting in Onedrive folders that we have connected to a Power BI dataset. Each Excel workbook represents a month. This datasource is being used in a Power BI dataset that also has data that is refreshed daily.

 

We have the dataset to refresh daily, however, this takes longer than we would like as it has to refresh the hundreds of Excel files that do not have any new data.

 

I thought incremental refresh would be the answer, but from my understanding, incremental refresh cannot be used with flat files (meaning Excel files?) due to query folding. Please correct me if I'm wrong on this.

 

So is there any solution to the above scenario to cut down on refresh times? All Excel files involved are stored on OneDrive. 

2 REPLIES 2
Highlighted
Anonymous
Not applicable

Re: Incremental Refresh with Excel Files?

Huge SSD, lots of RAM, and an ethernet cord are you friends here

Highlighted
New Member

Re: Incremental Refresh with Excel Files?

Hi, 

I have exact same issue. Please tell me, have you find a solution for your case?

Thanks in advance

Alex

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors