Some data comes from the msdb for the SQL jobs
If you don't need SQL Job replace the query "Currently Running SQL Jobs" with a dummy record set.
I've been having some problems with this query since I changed the Server param and tried to handly it as an optional data set.
let
BlankTable = #table(
type table
[
#"JobName"=text,
#"StartExecutionDate"=date,
#"RuNRequestedDate"=date
],
{{"Job data not available","",""}})
in
BlankTable
If you do have access to the server then you can use this query
let
SQLCmd="
SET NOCOUNT ON;
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT sj.name as JobName, sja.start_execution_date StartExecutionDate
, sja.run_requested_date RuNRequestedDate
FROM msdb.dbo.sysjobs sj
JOIN msdb.dbo.sysjobactivity sja
ON sj.job_id = sja.job_id
WHERE 1=1
AND session_id = (
SELECT MAX(session_id) FROM msdb.dbo.sysjobactivity WHERE sj.job_id = sja.job_id )
AND sja.start_execution_date IS NOT NULL AND sja.stop_execution_date IS NULL
",
SQLJobs = Sql.Database(JobServerName, "msdb", [Query=SQLCmd])
in
SQLJobs
I don't use the PowerBI service as we have no gateway to connect to our servers.
