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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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