Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Vasudevan606
New Member

PowerBI refresh issue.

Hi All, 

 

New to this group, so thank you for the help in advance.   I am currently facing a problem with refreshing the dashboard.   I am using Excel files from a shared drive as input.   Each Excel file is around 20MB in size, but when refreshing, it is displaying in GBs and not completing the refresh even after a day.  

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Vasudevan606,

The source file size does not mean the refresh operation only processed with these data, if you query table include complex operations(e.g. merge, combine, reference across query tables , invoke custom functions...), they may also affect the resource that spend on refresh.

Improving Power Query Calculation Performance With List.Buffer() 

Optimising The Performance Of Power Query Merges In Power BI 

I'd like to suggest you take a look at the following document about refresh and improve the performance if this help with your scenario:

Data reduction techniques for Import modeling - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @Vasudevan606,

The source file size does not mean the refresh operation only processed with these data, if you query table include complex operations(e.g. merge, combine, reference across query tables , invoke custom functions...), they may also affect the resource that spend on refresh.

Improving Power Query Calculation Performance With List.Buffer() 

Optimising The Performance Of Power Query Merges In Power BI 

I'd like to suggest you take a look at the following document about refresh and improve the performance if this help with your scenario:

Data reduction techniques for Import modeling - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.