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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
amybirc77
Helper II
Helper II

Refresh taking more time

Hi All,

I have a desktop report which is deployed to the report server ( not services). The backend data source is a SQL Server database (VIEW). The report takes 2-3 minutes to refresh. The VIEW keeps growing everyday. The old records do not change, I mean the underlying tables do not do any UPDATE, it is just INSERT. Is there a way when the user clicks on the refresh , it just refreshes the new rows? I know it won't work that way , but just curious if there is a workaround.

Thanks

5 REPLIES 5
Uzi2019
Super User
Super User

Hi @amybirc77 
Please check the video for incremental refresh. It will resolved your issue.

 

https://www.youtube.com/watch?v=tfJXmfUXgu0&t=451s

 

I hope I answered your question!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

@Uzi2019 

Thanks, I have 2 dates createdate and modify date and i need to refresh based off both the dates how is that possible?

Thanks

Hi @amybirc77 

you can apply incremental refresh on single date. which ever upatated on daily basis. dont add on both dates in single table.

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

@Uzi2019 sorry for changing the goal posgt, here is the new requirement based off the incoming data, we are getting ID,PAYEYEAR,PAYMONTH. For example 

ID=96131A0205

PAYEAR= 2023 going forward

PAYMONTH= 1 TO 12

We get files on the first day of the month which get loaded into SQL Server table , this has YEAR and month only so need to refresh based on CURRENT_DATE-Month=1

Is that possible?

Thanks

@Uzi2019 Thanks, Will try this and update you. Thanks for sharing the video.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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