Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data refresh how to exclude a table with static data

Hello All,     I have a report that will display tranactional date from 2019 to current. All of this data is in a table called ShoppingCart. The historical data from 2019 to 2021 will never change....
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    In power query editor, you need have two queries to the specifical table.

    1 Uncheck the include in report refresh and Enable load of the first part.

    2 Append the first part to the second part.

     

    So, the table will only refresh the second part in power bi model.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello,

 

   Thank you for your reply. Regarding the statement below:

Static =  ( date <= 31Dec2021)  with refresh turned off

 

1. Is this a Dax or Power Query command?

2. How do I appy it to a table?

3. "with refresh turned off" - How do I turn refresh off for a single table?

 

Thanks!

 

Peter

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

In power query editor, you need have two queries to the specifical table.

1 Uncheck the include in report refresh and Enable load of the first part.

2 Append the first part to the second part.

 

So, the table will only refresh the second part in power bi model.

Best Regards

Community Support Team _ chenwu zhu

 

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