"Shared Schedule Refresh" not working on Power BI Report Server Portal

[Anonymous]

Hi Team,

I am facing issue with "Shared Schedule Refresh" on "Power BI Report Server" Portal (Native mode).

"Manual" refresh and "Report-specific" refresh is working fine.

Only for "Shared Schedule" refresh, a SQL server agent job is getting created which then adds an event to dbo.Event table.

The problem is EventType = "SharedSchedule" is not getting proccessed further by Report server when verified through SQL server profiler trace.

Kindly help me with some ideas/solutions to resolve this issue.

Thank you!

[v-yanjiang-msft]

Hi @Anonymous ,

Firstly please check if the data source supports chedule refresh: 

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

Not all Power BI Reports can have a scheduled refresh plan created on them. The following is a list of Power BI Reports that you Can't create a scheduled refresh plan:

Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

If all is not there, please use the tools in the below report to dig:

Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

Best regards,

Community Support Team_yanjiang

[Anonymous]

@v-yanjiang-msft: Thank you for your reply.

1. My report is pointing to SQL server / Oracle data source.

2. I could not find any entries in ExecutionLog3 table for reports that are mapped to "Shared Schedule Refresh".

3. When I checked the SQL server profiler trace, I could only see queue processing for below EventType;

exec TakeEventFromQueue @EventType=N'DataModelRefresh'

The background process is not looking for EventType="SharedSchedule" at all and these events are getting piled up in Event table.

How do we make sure that EventType="SharedSchedule" also gets processed automatically?