Power BI Report Server SSRS Subscription

You can only use the data driven subscription if the PBIRS instance is on an enterprise license.

If it is not, you can stop the schedule in PBIRS but still leave the job intact so you have the To: , cc: etc and get the nice report server formatting.

Then from the SQL Agent create you own scheduled job that calls the PBIRS job. You'll need to look up the SQLAgent guid.

You can use this and change 'YOUR REPORT NAME%' accordingly:

use ReportServer
go
select S.ScheduleID as SQLAgent_Job_Name
	,SUB.Description as Sub_Desc
	,SUB.DeliveryExtension as Sub_Del_Extension
	,C.name as ReportName
	,C.Path as ReportPath
	,SUB.LastStatus
	,SUB.LastRunTime
	FROM ReportSchedule RS
inner join Schedule S on (RS.ScheduleID = S.ScheduleID)
inner join Subscriptions SUB on (RS.SubscriptionID = SUB.SubscriptionID)
left join [Catalog] C on (
		RS.ReportID = C.ItemID
		and SUB.Report_OID = C.ItemID
		)
where C.name like '%YOUR REPORT NAME%' --Enter Report Name to find Job_Name
ORDER BY SUB.LastRunTime desc

Pseudo code for the agent job would be like

If @rows > 0

Begin

USE msdb EXEC sp_start_job Anonymous_name = 'A00E3318-9D97-45E8-8476-526118CA62B1' /*Enter SQLAgent_Job_Name for PBIRS job*/

End

Else

Return /* nothing to do */