You are comparing apples to oranges.

SSRS is a reporting tool.  You input 1 or more parameters, a query is sent, and a dataset is returned and displayed. Full stop.

PowerBI is...

• This reply was modified 2 years, 8 months ago by  Dave Scott.

Why would you be storing the a "Join Date" or "Hire Date" with a time component?

When storing the date, "zero out" the time portion. Then in your SP/Query all...

Here is the query I use (as a view):

SELECT TOP (100) PERCENT c.Name AS Report, msdb.dbo.sysjobs.name AS SQLAgentName, s.Description AS ToWho, MAX(s.LastRunTime) AS LastRun, s.LastStatus,

...

I came up with report or query which was able to at least 'cross reference' the jobs. Although, the server hasn't gone down since, so I haven't had a chance...

Thanks! I'll see what I can come up with, there are 140+ MSRS Scheduled jobs, at least I can look on this and look for the GUID in the...

Unfortunately, some of the jobs where set up before my time here, so I can ID a handful of them. I was hoping there was some script or tool...