powerquery – Data source filter in Power BI for loading Azure Databricks table

I am loading a table from Azure DataBricks into Power Bi desktop. Now the problem is the data is so huge that it takes 25 minutes to load. I want to filter the data on the date basis so that only latest data is imported.

How do I do that? I can see that after loading I can add a step to filter the date but the loading itself is taking a lot of time. I want to load only the relevant data (i.e the latest Date).

Please help.

Just like when we load a data set from SQL Server. We have an option to write SQL query to load the data when we select Advance Option(this helps to filter the data at the even before importing). But the same thing is not available while loading data from Azure Databricks.