Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Problem with Power BI Report Server Email Subscriptions

Hi, our company started using Power BI about a month ago. We are using one of the Microsoft partners here in Chile to develop the reports. We have found an issue, that we seem unable to solve, even with their help. 

 

When we suscribe to a specific reporte, it saves the subscription, but the next day, we dont receive the report chosen and when we go back to the site, it shows as if we never suscribed. 

 

I could really use your help as our company's directors can't get the information needed. 

 

thank you for your quick response.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @RaulVargas,

 

1. Please subscribe to the report and set a one time schedule to send the report after a while, check if the report can be sent based on the schedule. 

 

2. The subscribe relies on SQL Agent service, after create a subscription, there is a job created in SQL agent. 

Please go to SSMS which connects to report server database, execute query below: 

 

select *from [dbo].[Catalog] c
Join ReportSchedule rs on c.ItemID=rs.ReportID
join Schedule s on rs.ScheduleID=s.ScheduleID

Then go to SQL Agent jobs, find the job based on ScheduleID found from above query, check job details to see if there are detail information. 

 

3. Please update the Power BI report server to the latest version. 

 

Best Regards,
Qiuyun Yu