cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danielpenafiel Frequent Visitor
Frequent Visitor

Refresh only current year data

Hi,

 

I would like to set up my pbix to refresh the data only of current and last year. I have static data since 2014 to 2017.

 

I not sure if the incremental refresh is the better way or perphaps i need to create to querys one static and other that refresh and then merge both.

 

The botton line is get faster refreshing time.

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHaas Established Member
Established Member

Re: Refresh only current year data

Needs to be incremental refresh.  The other way you described will still force both queries to refresh.

 

You can create a calculated table in DAX using the following syntax:

 

IncrementalTable = 
UNION(
    StaticTable, 
    RefreshingTable
)

This will require that both tables have the same columns names and are in the same order.

 

This will also double the size of your model.  You'll only build your measures off of the new calculated table, but you need the other loaded into the model to build it.

 

If you have already paid for PowerBI Premium, use incremental refresh.

 

Or try to build the tables using Dataflows (again, a premium feature), and set up incremental refresh there.


Best,

 

~ Chris

1 REPLY 1
ChrisHaas Established Member
Established Member

Re: Refresh only current year data

Needs to be incremental refresh.  The other way you described will still force both queries to refresh.

 

You can create a calculated table in DAX using the following syntax:

 

IncrementalTable = 
UNION(
    StaticTable, 
    RefreshingTable
)

This will require that both tables have the same columns names and are in the same order.

 

This will also double the size of your model.  You'll only build your measures off of the new calculated table, but you need the other loaded into the model to build it.

 

If you have already paid for PowerBI Premium, use incremental refresh.

 

Or try to build the tables using Dataflows (again, a premium feature), and set up incremental refresh there.


Best,

 

~ Chris