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.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community 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.

JRALCON's avatar
JRALCON
Frequent Visitor
1 year ago

This will NOT work in Power Query for excell