Forum Discussion
Data refresh how to exclude a table with static data
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.
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
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.
This will NOT work in Power Query for excell
No, this doesn't work. If you do this, the next time the semantic model updates, on schedule, it will override & try to update & cause errors.
