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...
v-yuta-msft
Community Support
Community SupportHi ouafaa,
If you want to filter data before the data has been imported into PBI, you can click Get Data->advanced options and write some SQL statements to achieve data you want.
If you want to filter data in Query Editors after the data been imported into PBI, you can use query parameter to filter your table. More details about query parameter, please refer to: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/.
Regards,
Jimmy Tao
If you are using the advanced feature and providing sql which contains a where clause to filter the data to your needs, powerbi will only get the results of that query.