Limit table data import to last 7 days only?

[pborah]

I'm importing SQL tables for a report published on server and it is set to refresh every 10 minutes. I want it to look for data from only the last 7 days every refresh. Is this possible to set up when importing the data in desktop? Thank you.

[amitchandak]

@pborah , is it an incremental refresh?

refer : https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

[pranit828]

Hi @pborah 

I would use parameters for this requirement.

Check thes links

https://docs.microsoft.com/en-us/powerquery-m/understanding-power-query-m-functions

https://www.youtube.com/watch?v=7TfV8qTUyfU

[pborah · Accepted solution]

Nope. This is what worked for me.

https://community.powerbi.com/t5/Desktop/Limit-import-based-on-date/td-p/294485/page/2