Filter by current date only through SQL Statement from column

Hello idk_the_answer , quick question, would you be able to connect to an upstream View that applied the filter, in order to improve your Power BI experience?

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Hi,idk_the_answer I am glad to help you.
Hello,foodd ,thanks for your concern about this issue.

Your answer is excellent!And I would like to share some additional solutions below.

According to your description, you want to reduce the data while speeding up the report display efficiency, aiming to get a "real-time" data experience.

I recommend using incremental refresh, which allows you to select the data you want to display (you can set the history partition to control the scope of the data to be displayed; you can set the refresh partition to control the scope of the data to be refreshed).

For very large data sets, incremental refresh is a great option because it doesn't refresh all the data and can significantly reduce your refresh and load time.

If you think incremental refresh is a good suggestion, you can refer to the following official documentation to configure incremental refresh

(Incremental refresh requires that your data source supports query collapsing and that the dataset has Date/Time fields in its tables)

URL:Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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