Filter by current date only through SQL Statement from column

[idk_the_answer]

Hello. I'm trying to reduce that amount of time my data takes to load in my reports. I want to filter by current date in addition to my other filters: 

Select * FROM CSI.SY_WHSE_TRACE where DC_ID = '0747' and TRANS_SOURCE='K' and TRANS_TYPE='D';

The column imports  the date as text into powerquery. I'm not sure if that is part of the problem too.

I only want today's data to load, I'm trying to make this as "live" as possible as data will be display on tvs on the production floor, the current time to refresh is approx 10 mins.

Can anyone help me out, I've tried everything I can google.

Thanks in advance

[foodd · Accepted solution]

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.

[Anonymous · Accepted solution]

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...

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.

[foodd · Accepted solution]

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.