Forum Discussion
Power BI Report Server SSRS Subscription
Hello, I have a SSRS report and I imported it to PBIRS. I have arranged e-mail subscriptions and that is ok. My problem is, sometimes my report returns no result and I do not want PBIRS to se...
You can create a data driven subscription. In the query where you select the data, you can make the check if the report should send. If not, the row is not in the resultset.
Hello Anonymous,
Can you give more detail? For instance, my mail query is below:
if (select COUNT(*) from MIX.rapor.vIkMailRaporu) > 1
begin
select
'mail adresses of my company'
as Mail
end
else begin
select ' ' as Mail
end;
where should I make this check? I want PBIRS not to send e mail if my report has no result.
Best regards.