stretcharm/SSIS-DB-Dashboard

Summary Tabs Only Reporting Last 3-4 days

Opened this issue · 4 comments

FIrst, I love the report you've put together. I'm learning a ton about my jobs and how to build better PBI reporting, so thank you.

On the Summary tabs I'm only getting the last four days' data. I have my history parameter set to 30 and can see in the Execution table, an earliest Execution Start Time of 9/17 at 9:27:14 am.

I'm seeing this on all of the summary tabs (1/2/3).
Any advice as to where to look to see where the bottleneck is?

I know it's almost a year later and you probably already figured it out. However the big filter icon on the visuals that is what you're looking for. Ctrl+click will get you the window to change how many days are displayed. Also in reference to: https://xkcd.com/979
image

Sorry I missed your original question.

Glad you got your answer eventually and you like the report.

There are lots of PowerBI features that could improve it, but I no longer use SSIS so I've not needed to keep tweaking it.

I may play with it and see what I can do, once my workload eases up a bit. Thanks again.