Workspace Weekly: Historic Date Ranges in the Power BI Template
September 2, 2025
Our Workspace Weekly series is all about practical value, and this week delivers. The Login Enterprise Power BI template (preview) now supports historic Start Date and End Date selection, so you can load an exact time window rather than only “days back” from today.
This unlocks backfills, fixed-window reporting, and clean A/B comparisons across specific periods. Kudos to Matt Schmitt here at Login VSI for shipping a simple change that creates a lot of power. Repo: LE-PBI-Connector
What’s new
When you open the .pbit template, you can choose a Start Date and an End Date. The old behavior still works if you prefer “days back” method. The feature is currently in preview, so please try it and share feedback.
Try it in a few clicks
- Download the connector and template from the repo: LE-PBI-Connector
- Put LE-PBI-Connector.mez in Documents\Power BI Desktop\Custom Connectors (create the folder if needed).
- In Power BI Desktop, allow custom connectors in Options > Security > Data Extensions, then restart.
- Open the .pbit, enter your FQDN, your API token, and now select Start Date and End Date, then load your data.
- Publish and set up a gateway if you want a scheduled refresh later.
Benefits and value
- Load exact historical windows for audits, QBRs, or incident reviews.
- Run true A/B comparisons on fixed periods, not just “until today”.
- Validate changes, for example group policy, security agents, image updates, hardware shifts, or cloud instance types.
- Track trends without drift, align reports to calendar weeks or months.
- Reduce guesswork, focus on precise problems, show outcomes clearly to stakeholders.
Think of the possibilities
Imagine you are the owner responsible for performance and user experience. With the updated template, you can line up two or more exact windows and answer questions quickly: did the security agent update cause a latency rise, did the new image speed up logons, did the cloud move affect EUX under load?
By selecting historical ranges, you can verify SLAs with confidence, prove there was no regression, or pinpoint when the curve began to bend. Open multiple Power BI windows at once, each with a different date range, and your comparisons become obvious, which helps quantify ROI and guide next steps.
Figure 1:
A four-quadrant desktop view with four Power BI windows, each set to a sequential two-week period of the same Continuous test. The EUX score trend is shown in each window, making side-by-side comparisons across the month straightforward.
Beyond a single test, you can compare different test types and datasets at the same time. For example, put Continuous Testing in one window, EUX Overview in another, Apps Overview in a third, and Logon Metrics in a fourth, all over the same historical span. In production, maybe one desktop group received an annual Windows upgrade, and users reported slower performance afterward. With historical windows, you can confirm or disprove the correlation by inspecting EUX, logon metrics, and app timings across matching periods.
Figure 2:
A four-quadrant desktop view with four Power BI windows, each two weeks, but mixing scenarios: Continuous Testing, Session Metrics, Logon Metrics, and EUX Overview. Historic access across multiple views turns you into a super-analyst.
Remember, you can also explore Application Testing, EUX results, Logon metrics, Application results (workloads), and Session Metrics historically, not just Continuous or Load tests.
Give it a try and unleash its power!
Give the preview a try and tell us what you think. Share findings, screenshots, and use cases in our #workspace-weekly Slack channel and stay tuned for more Workspace Weeklies!
Workspace Weekly
