We have an availability group database with 4 servers which includes a asynchronous replica that is used for reporting. Sometimes due to large query sets the secondary replica stops synchronization and we have to resume synchronization manually. We also want to install SSRS on the secondary replica that we use for reporting. Here are my below questions 1) Is it worth the performance hit to install SSRS on secondary replica as we don't have Enterprise license to install SSRS on a separate host. 2) Can we separate the secondary report server and synchronize data through SSIS hence there will be 3 node availability group database servers and one separate report server which synchronizes through SSIS or some other form . Overall is it advisable to RUN SSRS on the secondary replica. Thanks for the input

Can we install Power BI and SSRS on Windows Server 2019 without having issues? Does SQL Server 2019 Enterprise Edition with Software Assurance get Power BI?

ContractStartDate & ContractEndDate returning dummy dates (1900-01-01 & 4000-01-01) - how can I remove them? I'll be using DirectQuery in Power BI to build a report but been asked to remove the "Dummy Dates". Any suggestions would be appreciated.

Select * from(

SELECT [ContactID]
      ,a.[InjixoID]
      ,a.[start_date] as ContractStartDate
      ,a.[end_date] as ContractEndDate
	  ,b.EmployeeID
	  ,b.[Full name]
	  ,c.LeaveDate as CiphrLeaveDate
	  ,d.ContractName
	  ,d.ContractHours
	  ,d.NoOfDays
	  ,(ROW_NUMBER() over (partition by a.InjixoID Order by a.[start_date] desc)) as rn
  FROM [Staging].[InjixoContactsbyPU] a

  left join InjixoUsers b on a.InjixoID = b.InjixoID
  left join Employees c on b.EmployeeID = c.EmployeeId
  left join InjixoContracts d on a.ContactID = d.contract_id
  left join InjixoEmployeePeriods e on b.InjixoID = e.employee_id

  where a.end_date >= getdate() 
  --order by b.EmployeeID
  ) t1

  where t1.rn = 1

I'm having trouble understanding the report server permissions mechanism. If I were to create a report based on a database, would other users be able to view it even though they have no permissions over the database? In my company, we are very strict with how user policy work with databases, so only specific users have logins to databases. If I use one of those users to create a report and then publish it over SQL Report Server, as long a user has permission to a specific site where the report lies, can he still view the report even though he has no assigned logins on the database? Is the report server keep collecting the data for the report using the report creator's permissions? Like when it live updates?

I've just installed the August 2018 release of PowerBI Report Server onto the same Win 2012 server with SSRS 2016. I can get it running but it clashes with SSRS with URL reservations. I've configured them to use different Virtual directories and ports but SSRS keeps breaking. - SSRS: http://ServerName:80/Reports - PBIRS: http://ServerName:8080/PBIReports What have I missed? Edit: I have SSRS 2017 and PBIRS working at the same time on my laptop. Both on Port 80 but with different virtual directories.

For an ETL reporting system, is it normal for the total execution time for a pull of 15 minutes with no data to be similar to a 24 hour pull with data? ------------- I had expected that the total time for ETL when there is NO data would be shorter but that is not the situation between a 15 minute and 24 hour pull. But I must confess that I know nothing about the internals of the T and L phases within a report server. Can someone shed light on whether the T and L phases are typically fixed in duration (up to a point)?

I have PowerBi Server (Jan 2019) installed on my server. I can see from the default trace that that the PowerBi Service account NT SERVICE\PowerBIReportServer is granting execute permissions on a stored procedure ExtendEditSessionLifetime to the RSExecRole (within the ReportServer database): GRANT EXECUTE ON [dbo].[ExtendEditSessionLifetime] TO RSExecRole This is happening frequently many times during the hour, most hours (around 50 times an hour) there doesn't seem to a pattern that I can see and I can't find any documentation online about what the stored procedure does. I can't see anything obvious in the PowerBI logfiles or the event viewer either. What could be causing this (or is it intended behaviour?)

We have SQL Server 2019 and Power BI Report Server installed on the same host. we're using a virtual service account for Power BI Report Server. We get the following error when trying to view a report: > An error has occurred during report processing. (rsProcessingAborted) > Cannot create a connection to data source 'DataSource1'. > (rsErrorOpeningConnection) Login failed for user 'NT > AUTHORITY\ANONYMOUS LOGON'. We are trying to migrate and upgrade to SQL Server 2019 and Power BI Report Server on Windows Server 2019 from SQL Server 2014 and SSRS on Windows 2012. SQL Server 2019 has been set up on the new host and database schemas have been migrated over and Power BI Report Server has been installed (same host as the new SQL Server). We can access the database using SSMS without any issues. We are able to log in to the reports URL (https://hostname/reports) and can see that there are some reports that have been created. When we try to view a report, we get the error I mentioned above. We are using a virtual service account for Power BI Report Server. As mentioned, Power BI Report Server and SQL Server are on the same host. For Data source properties > Credentials > Log into the data source If we set it to "As the user viewing the report" and click the "Test connection" button, it says "Connected successfully" Also tried setting it to "By prompting the user viewing the report for credentials" with "Type of credentials" set to "Windows username and password", but it does not prompt for credentials when trying to view a report. In both cases we get the "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' " error. web.config has

rsreportserver.config has

We have also tried RSWindowsBasic and RSWindowsNegotiate, but they did not work. We have 2 other servers where SQL Server and SSRS (not Power BI Report server) are installed and working. web.config and rsreportserver.config have the same values as above. I can't find any difference in the configs. Some posts and documentation mention setting up SPNs, but as I understand it, SPNs are only needed if you use a domain account for the service account and not needed if you use the virtual service account. Maybe I misunderstood? Also read the posts about it possibly being a double hop issue, but the solution there seems to be to set up SPNs, but I'm not sure how to do that for the virtual service account. Two of the docs I referred to: [Configure Windows Authentication on the Report Server](https://learn.microsoft.com/en-us/sql/reporting-services/security/configure-windows-authentication-on-the-report-server?redirectedfrom=MSDN&view=sql-server-ver15) [Specify Credential and Connection Information for Report Data Sources](https://learn.microsoft.com/en-us/sql/reporting-services/report-data/specify-credential-and-connection-information-for-report-data-sources?redirectedfrom=MSDN&view=sql-server-ver15)

I understand that as of the 2016 versions it is now possible to run SSRS and Power BI on the same server. I would like to know if anyone is currently running this combination and what are the pros and cons of doing so.

I've been requested to create some sql server reports ( create a report and send them by email ) for some poeple. I thought it would be like 2 or 3 but now that they know I can do it, every week I need to create 1 or 2 more reports. I use SQL Agent and some steps to create a table, populate with the desired results, then I send it inside a xls file. Thats really not a problem, But I would like to know what can be better used for this task, since now I have more then 20 jobs on my SQL Agent. its all well organized and etc but still, I dont like to be looking at it. I already have a lot of DBA jobs and I dont want to mix things. Is reporting services a viable way to do this? can I normally create a query, them send it to an excel file and send it by email without using c# or visual studio?

I am reading msdn article on using SSRS with AG and have few doubts on setting up the same: - **Server A** - Will host Report Server services with scale out deployment - **Server N1** - Node 1 with ReportServer and ReportServerTempdb database serving as primary replica - **Server N2** - Node 2 is secondary replica of the ReportServer and ReportServerTempdb Above nodes will be part of multi-subnet cluster with N1 in DC1 and N2 in DC2. I am thinking to create the listener first with 2 IPs for those multi-subnet so that we can use same while installing reporting services and point the listener name in instance and it's report server database to it so that it is aware of primary replica even after fail-over. Is my above understanding correct? Is that how it's suppose to work? Secondly, document says automatic fail-over is not supported even when I use sync mode between N1 and N2? Is that true? And why would that be the case only with SSRS? Also if it is, can we automate the fail-over or does it have to be manual every-time since I am thinking data source application string can use the option MultiSubnetFailover=true ? Appreciate your inputs.

I am running into a strange situation that I have not been able to resolve.  I have a 2 node Basic AG running sql server 2016 standard.  I am trying to add the reportserver DB to an AG, but it keeps failing on joining the DB to the secondary node. I have done the below: 1. fully recovered the DB on node1 (primary), made sure its in Full recovery mode 2. took a fresh backup, AND log backup immediately after it 3. restored both the full and log backup to Node2 (secondary) leaving it in restoring state. Back on primary I created an AG via the GUI, but when I get to the end it sits on joining the DB to the AG in node2. I get a few different errors, which essentially mean the same thing:  "the remote copy of the db "reportserver" has not been rolled forward to a point in time that is encompassed in the local copy" "the mirror db "reportserver" has insufficient transaction log data to preserve the log backup chain." I know these mean that should be additional log backups to restore, but I had just prior to this taken the full AND log backup and restored both of them to the secondary, so there should be no other backups to restore...  The only thing I can think of is that something is still writing to the log on the primary, but as far as I am aware, even if that is the case, joining the DB to the AG should still work as the currently un-backed up portion of the log should be streamed to the secondary replica during the sync process.  I skipped the listener configuration for the time being. I also stopped the SSRS service on both nodes prior to doing this. Has anyone encountered this before and had success fixing it?  Is it because it is the reportserverDB, and it can't be joined to the same AG as reportservertempDB? I have tried automatic seeding, and join only mode, and the strange thing is that automatic seeding gives me NO errors during the AG setup, but the DB does not ever show up on Node2. When i do join only, that is when I get the errors above.  I'm pretty much baffled by this.  I have 6 other DB's on these nodes that are each in their own basic AG, and I have not run into any issues with them.

We have faced an issue where the Dev team is not able to view their reports. The installations were all done by them and we had to jump to see what is wrong. We doubt they installed the Evaluation version and the 180 days are over. The error states thats the issue however, we still want to check the edition installed. We were able to find the Version from registry which was Version 1.4.6969.7395 (Build 15.0.1102.235) How to find the edition of Power BI Report Server?

I have a Power BI Report Server working perfectly connecting to SQL Server machines with a default instance only. I can also connect to SSAS named instances with the proper SPNs and by allowing Kerberos constrained delegation from the Power BI service account to the MSOLAPSVC.3 service (SQL Server Browser). I believe I have all proper SPNs set up properly as I can run linked servers and query just about anything from anything. Kerberos Configuration Manager shows green check marks for everything. My only problem is connecting to named instances of the SQL Server engine (not SSAS). I get the error below, which you would normally get if SPNs are not registered properly. > DESCRIPTION: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. > Reason: Could not find a login matching the name provided. [CLIENT: > x.x.x.x] Is there a difference in how named instances must be connected to from Power BI (and perhaps SSRS as well)? I am trying to do a DirectQuery against a remote named instance of SQL Server in a .pbix file in my environment.

I have to servers: one with the SSRS Report Server and a second server with the Power BI Report Server. The issue is I'm trying to migrate the SSRS Reports to the Power BI Report Server instance on a third server that I plan to unify both report databases. As far as I understood based on a Microsoft article (**Migrate a report server installation **), it's possible to migrate the SSRS database to the Power BI Report Server as shown in the picture to the same instance and service (Power BI Report Server in this case): I've created the backup of the SSRS databases (and encryption key) and restored on the PBI server, but it's not working. If I restore only the PBI database (and its encryption key) it works fine on the destination server. On the Report Server Configuration Manager I can only set the ReportServerPBI (that I restored from the server that already runs the PBI) to have it working. If I set the ReportServer database that I've had made the backup it doesn't work. Am I mistaken or is there any way that I can put these services in the same server/database and running under the Power BI Report Server? Will I have to keep separate instances to have both dashboard types running?