I want to make sure there are only 90 days of data in my Azure Analysis Services (AAS) model. I'm thinking about using Power Query/M to only filter the most recent 90 days and then doing a Process Full. Is that the best approach to this? If so, how can this be implemented, especially since there is no DateDiff function in Power Query/M?

Hi @James H. Robinson , Thanks for your patience. I got update from Product team that the recommendation is to use partitions . Process the new partitions (Ex: monthly partitions) and delete the old partitions. And for using PowerQuery M functions, the filter expression in M will fold properly to the data source if it is a data source with compute (e.g. SQL Azure/Synapse/etc.) and be efficiently handled. For other data sources, you have to be careful about how to pull data efficiently. Hope this helps! Please let us know for further queries and we will be glad to assist.

Azure Analysis Services: Purging Data

Accepted answer

HarithaMaddi-MSFT 10,136 Reputation points

2020-10-19T08:08:11.573+00:00

Hi @James H. Robinson ,

Thanks for your patience. I got update from Product team that the recommendation is to use partitions. Process the new partitions (Ex: monthly partitions) and delete the old partitions.

And for using PowerQuery M functions, the filter expression in M will fold properly to the data source if it is a data source with compute (e.g. SQL Azure/Synapse/etc.) and be efficiently handled. For other data sources, you have to be careful about how to pull data efficiently.

Hope this helps! Please let us know for further queries and we will be glad to assist.
Please sign in to rate this answer.

1 person found this answer helpful.
HarithaMaddi-MSFT 10,136 Reputation points

2020-10-20T06:21:20.203+00:00

Hi @James H. Robinson ,

We have not received a response from you. If above clarification helped you, please let us know and for any other queries, let us know and we will be glad to assist.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

HarithaMaddi-MSFT 10,136 Reputation points

2020-10-21T08:16:33.097+00:00

Hi @James H. Robinson ,

We still have not heard back from you. Following up to check if above clarification helped you. Let us know for any other queries, we will be glad to assist.

-----------------------------------------------------------------------------------

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Sign in to comment

Azure Analysis Services: Purging Data

0 additional answers