Filter data source on load (or before load!)

[wikap]

Thought this would be simple:

I have an invoice table going way back, but want to load only the invoices with invoice date later than 1st of January 2017 (lets say 50.000 rows). I seems like it fetches all rows in the table (say 500.000), and then inside Power Bi does the filtering!

This puts performance pressure on our (very old) SQL database.

Any solutions on how I can apply a filter directly on the "on lead"/fetching of the data?

/Henrik, WIKAP.dk