Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

an error occured within the report server database

Hello, I moved the database off powerBI server (on premise) to another server with sql 2019, and now the schedule doesn't work anymore. I have an error message : "an error occured within the report ...
server power bi schedule
whereismydata's avatar
whereismydata
Resolver IV
4 years ago

Hi, did you also migrate the SQL Server Agent Jobs? PowerBI RS creates an SQL Server Agent Jobs for each schedule.

The name of the job is a GUID created by PBIRS.

You can query the ID's with this statement:

SELECT [ScheduleID] --> Name of job
      ,[ReportID]
	  ,c.Name
      ,[SubscriptionID] --> This id needs to be passed in the procedure
      ,[ReportAction]
  FROM [pbiReportServer].[dbo].[ReportSchedule] r
  LEFT JOIN [pbiReportServer].[dbo].[Catalog] c ON r.ReportID = c.ItemID
  ORDER BY Name asc

Within the job there is only one step of type T-SQL with this command

exec [pbiReportServer].dbo.AddEvent @EventType='DataModelRefresh', @EventData='INSERT Subscription ID'

Hope this helps

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI,

We migrate the SQL Server Agent Jobs, and

and we execute the TSQL command like your example, 

but we have the same error : we can't  modify the plannification

How do I determine what is not working ?

is it necessary to re install server power bi ?