How to refresh the last 180 days from an Azure BLOB storage dataset

[Anonymous]

Hello,

I'm fairly new to Power BI and we have a file within Azure BLOB storage (Events) that Power BI is refreshed against.

The file contains 18 months of data but we would like to only refresh the last 6 months worth of data.

With that being said, Is there a way this can be programatically done?

Thank you for your answers.

[v-yuezhe-msft]

Hi @Anonymous,

Do you set refresh for  your dataset in Power BI Service? If that is the case, there is no method to control refresh on specific data in the dataset. The current refresh functionality is “all or nothing”.

However, if you refer to refresh in Power BI Desktop, you can split your table into two tables based on data time. For the table that contains 12 months of data, you can disable the option “Include in Report Refresh”. For more details, please review this blog: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ . Meanwhile, you can vote this idea.

Thanks,
Lydia Zhang