Load limited data via Table storage

[Anonymous]

I have data stored in table storage and data set is huge which is casuing the data load failure 

Can we load limited data in during refresh like only the last 7 days of data or current / previous date data .. 

There is a date field in the table 

[Greg_Deckler]

@Anonymous - Yes, you can use Incremental Refresh.

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

[Anonymous]

Hi @Greg_Deckler

Thanks for the quick responce, I tried usign Incremental refresh however not sure how I can add dynamic filter on date column like pick only dynamic current or last date data only. for every day refresh

[Greg_Deckler]

@Anonymous Look at the Refresh ranges part of the document link I sent. If I understand what you are asking about.

[Anonymous]

@Greg_Deckler I tried to lookup this option However unable to find this . Is it in PowerBI service once the parameters are added and is Table Storage connector an approved one .