When appending data daily to a source file, how do I show a visual with data from only yesterday?

[jduffy2nd]

Session information for the last 24 hours (midnight to midnight) is extracted from Citrix VDI, and appended to a SQL table.  I am working with that SQL table.  I do have a simple date table as a dimension.

Source data has Session StartDate and Session EndDate in it.

If today is (for example), January 9th at 5pm, then the data that was last appended is the session information (start and end time, user name, and other metrics) for January 8th, from the beginning of the day to midnight January 8th (or 11:59:59).  I append more data every day.

I want to have a visual that shows (in my example) all of January 8th.

How do I show only the latest day's data (January 8th in my example) in the visual (either a chart or a table)?

[Anonymous · Accepted solution]

Hi,   @jduffy2nd 

According to your description, after appending data every day, show only the latest day's data in a visual, you can consider the incremental refresh solution. Incremental Refresh allows you to set the refresh period and historical data retention time, and you can automatically refresh the data according to the configured refresh schedule. Below are notes on configuring incremental refreshes.

1.Create two parameters named RangeStart and RangeEnd, the case of these two parameter names cannot be changed.

 

2.Filter data

Screening data according to the parameters created, note that the screening range must not be equal or unequal at the same time, the interval is divided into must be a closed and open.

3.Then define the refresh policy in the Desktop interface, select the data period you want to keep; configure the refresh period, according to your needs, the refresh period can be set to 1 day; specify the optional settings, the second item of the optional settings is "Only refresh complete days", if the refresh operation is detected that a day is not completed, the rows will not be refreshed for that whole day, according to your needs. The second optional setting is "Only refresh complete days", if the refresh operation detects that a day has not been completed, the rows of the whole day will not be refreshed, according to your needs, you can check this item. After the configuration is complete, create the visual object and publish it to the Service, then configure the gateway and refresh schedule, the visual object can display the previous day's data.

 

Configuring the gateway: Use the on-premises data gateway app | Microsoft Learn

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

If you want to connect directly to the file in Citrix VDI, you can pull the data in PowerQuery using the M language.

Linking data in Citrix VDI: Incremental refresh for files in a Folder or SharePoint - Power BI — The Power User

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[adudani]

hi @jduffy2nd ,

in the date dimension table, consider adding a current day offset column. ( if today 0, yesterday = 1, ...)
add a visual/ page (depending on requirement) level filter where current day offset  = 1.

reference: (81) Power BI: Ultimate Calendar Table gets Week Offsets - YouTube 

the link above provides a sample calendar table with offsets and logic for reference.

You could wrap , Date.From / DateTime.From over DateTime.LocalNow(),