cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kumar09
Frequent Visitor

Power BI Report Server data base failover issues with SSRS subscriptions and PBIX data refresh jobs

 

Hi PBI Community - 

 

We have setup Power BI Report Server (Native Mode) on a scale out environment i.e. two instances of PBIRS backed by a one SQL Instance.( Report Server db, ReportServerTemp db). When ever we failover our Rpeort Server database we see issues with SSRS subscriptions like the scheduled jobs that were related to the subcriptions were either not enabled or have old subscription end dates. The same thing happens with Power BI reports data refresh jobs. We followed the steps mentioned in the below link for failng over the Report Server database. Any suggestions on how to resolve this issue would be appreciated.

 

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/reporting-services-...

0 REPLIES 0

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.