Forum Discussion
Memorable MemberSnapshot Model in Power BI
A snowflake model pulled in Power BI desktop in Import mode and we want to stop any update after the 1st of every month for the previous month all the measures and data being visualized. This will occur every month for example Feb 1 it will stop updating January data similarly, on March 1 it will stop updating February data.
What options do we have? I don't want the Snowflake Time Travel function...can we do anything with Power BI Desktop?
Ritaf1983
2 Replies
- danextian
Super User
Hi saud968
Power bI Desktokp has an option in the query editor (right click the query) to not include a query in the refresh but this also means you can't refresh the current data, for example Feb, unless you split the historical and current data into separate queries.
You can however, store the past data that doesn't need to be refreshed until needed in a table in a dataflow. You may opt to store the current data in another dataflow and let it be the only one that refreshes. Note: the historical and current data must be in separate dataflows as refresh can only be configured for each dataflow and not for every table in it. The historical and current dataflows then need to be combined in a separate dataflow (granting you have premium capacity) or combine both in Desktop. You may also opt not to use a dataflow for the current and instead combine directly the current data from snowflake and the historical from dataflow - this approach though might cause a formula firewall error.
- saud968
As you can see I have multiple queries. Also, I do not think it is a good idea to create multiple queries for each month and eventually I will have to create new measures for each query. though it can be done via tabular editor it is still not a good plan I think.. Is there no other option.
