Questions tagged [powerbi-report-server]
Use for questions about Microsoft Power BI Report Server.
15 questions
0
votes
1
answer
33
views
SSRS on a Secondary Replica
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 ...
- 1,063
0
votes
1
answer
181
views
SSRS and Power BI report server on same server?
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?
- 7
0
votes
0
answers
33
views
ContractStartDate & ContractEndDate returning dummy dates (1900-01-01 & 4000-01-01) - how can I remove them?
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 ...
0
votes
1
answer
244
views
Microsoft SSRS - Can users view a report based on a database they have no permissions to?
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 ...
1
vote
3
answers
174
views
Should the T and L phase of a well tuned ETL report process take the same amount of time regardless of the time bucket width and data size?
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 ...
- 543
0
votes
2
answers
5k
views
Power BI report server: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' when trying to view a report
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:...
- 1
1
vote
1
answer
544
views
SSRS and Power BI on same server
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 ...
- 11
4
votes
2
answers
1k
views
what is the best approach to send report by Email?
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 ...
- 7,484
2
votes
2
answers
2k
views
Setting up Availability group for report server databases
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 ...
- 2,210
1
vote
1
answer
166
views
PowerBI Service Account granting duplicate execute permissions on stored procedure almost constantly
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 ...
- 2,083
0
votes
1
answer
180
views
reportserver will not join basic availabiltiy group
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 ...
- 255
2
votes
2
answers
5k
views
Edition of Power BI Report Server
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 ...
- 2,328
0
votes
1
answer
2k
views
How to get Kerberos working against a named SQL Server instance in 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 ...
- 2,053
1
vote
1
answer
2k
views
Migrate SSRS Reports to Power BI Report Server
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 ...
- 145
4
votes
2
answers
5k
views
SSRS and PowerBI Report Server on same server
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 ...
- 3,243