Forum Discussion

danielpenafiel's avatar
danielpenafiel
Frequent Visitor
7 years ago
Solved

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 perphap...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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