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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
cyclist007
Responsive Resident
Responsive Resident

Is it possible to use SSRS ReportServer DB & ReportServerTempDB for Power BI Report Server?

Hi,

 

One of our clients have report server Databases for an SSRS instance (ReportServer DB & ReportServerTempDB). On installing a separate/new Power BI Report Server (PBIRS), they are wondering if the same SSRS databases can be used (pointed to) for the PBIRS? I would think no (as PBIRS is supposedly a superset to SSRS), but is there any documentation around this? Can anyone provide any details?

 

Thanks

2 REPLIES 2
d_gosbell
Super User
Super User

No you definitely should not do this. I can't think of any specific documentation that points this out, but each instance of SSRS or PBIRS should definitely have it's own set of databases. You can migrate an old SSRS database to PBIRS, but you should not point both instances at the same database.

 

One reason is that PBIRS gets updated every 4 months and you should always try to keep reasonably upto date as Microsoft only support the current version and the 2 prior versions. These updates often include small changes to the database schema so at somepoint it's highly likely that PBIRS would break SSRS.

 

Another reason is that the servers are constantly reading and writing to the databases and expect to have exclusive write access. With two instances connected you could cause lock/blocking that could cause strange behaviours on both instances.

Thanks @d_gosbell 

 

I wish Microsoft uses at least different default names for the Power BI metadata database names or this just causes confusion with SSRS (i will be editing the names). Also this should also be documented better, as SSRS & PBIRS documentation otherwise is pretty overlapping.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors