Filter by date in source step

[Gerald23]

Hi Everyone,

Would it be possible to filter by date in the source settings within the Power Query editor?

I currently have setup an extra step that filters all records to only show data which is after 1-1-2020 but if possible i would like to apply this filtering in the Source step already because I think that would be better for performance reasons.

Is this possible and how would my query look like?

In Advanced Editor: #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Period.Date Value] > #date(2020, 1, 1)),

[Vijay_A_Verma · Accepted solution]

You can use a DAX to filter data before importing. This has been solved here

https://community.powerbi.com/t5/Desktop/limit-SSAS-data-import-through-MDX-DAX-query/m-p/701065#M33... 

[Anonymous · Accepted solution]

Hi @Gerald23 ,

You could also create the paremeters for filtering.

About more details, please kindly refer to

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

If your source is SQL then you can use direct query by applying the filter condition else
you can use Python or R script to do all data transformation steps and load the final dataset.

[Vijay_A_Verma · Accepted solution]

You can use a DAX to filter data before importing. This has been solved here

https://community.powerbi.com/t5/Desktop/limit-SSAS-data-import-through-MDX-DAX-query/m-p/701065#M33...