How to use query by date not filter

[Anonymous]

Hello, 

I would like to only allow a certain amount of data to be queried into PowerBI. I don't want to load all of the data then filter. Can this be achieved through parameters or SQL? I have done it before, but not sure exactly how. Any suggestions would be great! Thank you!

[Anonymous · Accepted solution]

Hi @Anonymous,

Any date fields stored in your data tables? If that is the case, you can turn on the 'advance' option and write t-sql query to filter on that field based on the max value from your table values.

Power Query SQL Server connector | Microsoft Docs

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

I used SQL on the source to only allow the first 30 days. Thanks for your help!

[Pragati11]

Hi @Anonymous ,

I think you can use query parameters in Power BI to achieve this.

See this blog: https://blog.crossjoin.co.uk/2020/05/24/limit-the-amount-of-data-you-work-with-in-power-bi-desktop-using-parameters-and-deployment-pipelines/

Thanks,

Pragati

[Anonymous]

Thank you! This blog only shows how to show the last X amount of rows. How do I show only the last 30 days? I want to query by date. Thank you again 🙂

[Anonymous · Accepted solution]

Hi @Anonymous,

Any date fields stored in your data tables? If that is the case, you can turn on the 'advance' option and write t-sql query to filter on that field based on the max value from your table values.

Power Query SQL Server connector | Microsoft Docs

Regards,

Xiaoxin Sheng