Forum Discussion
ouafaa
Helper II
Helper IIPre-Filtering Data before Importing
we have an sql server database that contains very old data, and we just need some recent data for creating our reports. so, we chose to import only the data whose date is later than a date X for exem...
With SQL Server database, Power BI should be smart enough to send some transformation to the backend instead of doing the transformation in Power BI. In your case, filters will be applied first in the backend and then Power BI will retrieve the filtered rows. You can check out this article for more information regarding query folding: https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/