cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryanc78 Member
Member

Only report on new data

My first PBI reports are coming up on 1 year old and I don't need to report on data older than that.  Could I go into the query editor and filter dates to only show the last 365 days and would that stop the older data from refreshing and loading?  Trying to keep 1 big report from timing out on refresh

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Only report on new data

@bryanc78 ,

 

If you mean that achieve the newest data only(don't import the old data again) when refreshing. You can use incremental refresh but you need a premium license. By the way, if you don't have premium license(e.g.: only a pro user), there's also a workaround by using dataflow and ETL tools, please refer to this blog.

 

However, if you mean to filter the date column, just click the filter, select "after" and input the date one year ago manually.

Capture.PNG

1.PNG 

 

Community Support Team _ Jimmy Tao

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

View solution in original post

2 REPLIES 2
jthomson New Contributor
New Contributor

Re: Only report on new data

You could try adding a Date.AddYears column in combination with DateTime.LocalNow with an offset of -1 for comparison purposes, and then remove based on those that, but I don't know if that'd actually improve performance (or if there's a more efficient way to handle this)

Community Support Team
Community Support Team

Re: Only report on new data

@bryanc78 ,

 

If you mean that achieve the newest data only(don't import the old data again) when refreshing. You can use incremental refresh but you need a premium license. By the way, if you don't have premium license(e.g.: only a pro user), there's also a workaround by using dataflow and ETL tools, please refer to this blog.

 

However, if you mean to filter the date column, just click the filter, select "after" and input the date one year ago manually.

Capture.PNG

1.PNG 

 

Community Support Team _ Jimmy Tao

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

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors