cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArunkumarK
Helper I
Helper I

PowerBI Desktop Refresh Issue

Hi Users,

I have millions of rows in sql database and connected with powerbi desktop. All went well but recently i got an error as always times out. Lets see an example.

I have an 3 years of Fiscal year data and it keeps adding on every month. Once the data is uploaded it should not be modified at any cost. So dont needs to refresh again and again for the same query.

My structure is as below

FY 18 - Consolidation of 12 month's data

FY 19 - Consolidation of 12 month's data

FY 20 - Consolidation of 12 month's data

FY 21 - Consolidation of Recent Month's data

Master - Consolidation of FY18, FY19, FY20 and FY 21(Here no needs to refresh FY18, FY19 and FY20) But whenever I refresh the Master it keeps refreshing all the years from SQL. Hence time out becuase of huge data.

FYI, I unchecked the enable load in all Fiscal years including recent. I loaded only the Master table. Still it shows as time-out.

Any help would be really appreciated.

2 REPLIES 2
v-yingjl
Community Support
Community Support

Hello @ArunkumarK ,

You can try to configure incremental refresh or enable query folding for it.

About incremental upgrade, you can refer to:

  1. Incremental update in Power BI
  2. Everything you need to know about incremental upgrade in Power BI: Upload only changes

About query folding, you can refer to:

  1. Folding Power Query Queries
  2. Folding queries

Best Looks,
Yingjie Li

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.