"power bi report server "
157 TopicsProblem with updating the Power BI Report Server dashboard
Problem with updating the Power BI Report Server dashboard (Version: 1.21.9032.4573 (build 15.0.1116.121), released: September 26, 2024) One report is successfully updated with the Completed Data Refresh status. However, when the dashboard is opened, the data is not loaded, and the report is empty. How can this be resolved? There are no errors, and the data is physically present in the database tables, but the report itself is empty.Solved2KViews0likes14Comments
Where can I find "Power BI Report Server May 2026 Feature Summary" ?
Hello, Does anybody know where to find a summary of changes for May 2026 Power BI Report Server ? January 2026 Report Server release notes are here, but cannot find a similar page for May 2026: https://learn.microsoft.com/en-us/power-bi/report-server/whats-new Regards.Solved448Views1like1CommentSSMS connection failure to reporting services
Hello, we recently migrated the Report Server to a new machine running the latest SQL Server Standard 2025 (Dev). The Report Server version was upgraded to January 2026. Unfortunately, I am no longer able to connect to the Reporting Services instance via SSMS (22.6). I am using Windows Authentication with the system administrator account. In the instance selection for Reporting Services, the local instance MACHINE\PBIRS is visible, but the connection attempt fails after some time. The reported cause is a generic error message: Cannot connect to the server at "MACHINE\PBIRS". The specified URL may not be valid, or there may be an issue with the report server version or configuration. Specify a different URL, or contact the server administrator to verify that the report server is running SQL Server 2008 or later. Also, when attempting to connect to a SharePoint integrated report server, ensure that SharePoint is installed on the server and that the report server is configured for SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)Solved1.6KViews1like8Comments
PBRS licensing (Server+CAL vs Per-Core) and implementation advice for an on-prem deployment
Hi all, My organization is planning a Power BI implementation for a department of around 40 people. Because we work with highly confidential data, we're not comfortable hosting anything in the cloud, so the standard Power BI + cloud setup is off the table. We're therefore looking at Power BI Report Server (PBIRS) as our on-premises option, and I have a few questions I'm hoping the community can weigh in on. 1. Licensing route and edition My understanding is that with SQL Server 2025, PBIRS rights are now included with any paid edition (Standard or Enterprise) and no longer require Software Assurance — a change from older versions, which needed Enterprise + SA. If that's correct, Standard edition looks like the most budget-friendly route for us versus the Fabric F64+ path. Can anyone confirm this is accurate, and flag any practical limitations of running PBIRS on Standard rather than Enterprise (e.g. virtualization or failover rights) that we should factor in? 2. Server + CAL vs. Per-Core This is the main thing I'd like to hear real-world experience on. For those of you running PBIRS: Which licensing model did you choose, and why? If you went with Per-Core, what core count did you settle on? The minimum is 4 cores per OSE — in practice, is 4 cores enough for a department of our size, or does it tend to underperform? For roughly 40 users, did Server + CAL end up cheaper, or did Per-Core make more sense? 3. Implementation and hidden costs Finally, I'd appreciate any general advice on implementing PBIRS — gotchas a new user should know going in, and especially any additional or unexpected costs to budget for. One thing I've seen mentioned is that a Power BI Pro license is still required to publish reports to the server regardless of the SQL licensing route — I'd love confirmation on how that works in practice and whether every report author needs one. Thanks in advance for sharing your experience!Solved1.2KViews0likes3Comments
PublishModel fails with ImageLoad on High CPU consumption
Hello, High CPU consumption is causing Analysis Service to have a Timeout and terminating a refresh of a report. We got 8 CPU and I see max CPU consumption in this time period. There is a refresh of 4 Reports at the same time. *) The ASManagedRoot log has no records in these 9 minutes *) What is the recommend solution in this case? The ASManagedRoot log shows: 2026-06-11 07:44:21.5286|INFO|170|Getting data sources in the model for connection string for databaseName = eb219e3c-06db-4650-b62b-654c6f87bd5f_1936952837 ---- 9 MINUTES of no entries in the log ----- 2026-06-11 07:53:34.1593|INFO|132|Initializing a new instance of PBIRSMashupProviderHost... The RSPowerBI Log says: 2026-06-11 07:45:46.2109|INFO|6|Processing Data Model Refresh: SessionId: 368281d1-fe31-43f5-8f21-5bcd52e5b4e2, Status: Starting Streaming model to Analysis Server. ERROR coming after a couple of minutes: .... 2026-06-11 07:51:59.8585|ERROR|88|S-KP\s030f738 192.169.3.17: GET / - 0:01:39,5295055 Exception: System.IO.IOException ---> System.Net.HttpListenerException: Es wurde versucht, auf eine nicht vorhandene Netzwerkverbindung zuzugreifen ... 2026-06-11 07:51:59.9895|ERROR|91|Failed to publish model for ac4f5693-f48d-43b7-8eab-a34432755014_833159031Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to publish model for ac4f5693-f48d-43b7-8eab-a34432755014_833159031 ---> Microsoft.AnalysisServices.ConnectionException: The connection either timed out or was lost. ---> Microsoft.AnalysisServices.XmlaStreamException ---> System.IO.IOException: In die Übertragungsverbindung können keine Daten geschrieben werden: Eine vorhandene Verbindung wurde vom Remotehost geschlossen. ---> System.Net.Sockets.SocketException: Eine vorhandene Verbindung wurde vom Remotehost geschlossen bei System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size) --- Ende der internen Ausnahmestapelüberwachung --- bei Microsoft.AnalysisServices.XmlaClient.ImageLoad(String databaseName, String databaseId, Stream sourceDbStream, Boolean allowOverwrite, String readWriteMode) bei Microsoft.AnalysisServices.Core.Server.ImageLoad(ImageLoadInfo imageLoadInfo) bei Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<>c__DisplayClass47_0.<LoadDatabaseInAsAsync>b__0() --- Ende der internen Ausnahmestapelüberwachung --- many thanks for hints! StefanSolved1.1KViews1like5Comments
Power BI Report Server Cannot Create SSL Certificate Binding on Windows Server 2025
Hello, I am trying to configure HTTPS for Power BI Report Server on a Windows Server 2025 machine. Environment: - Power BI Report Server (latest available version) - Windows Server 2025 - SSL certificate installed under Local Computer > Personal > Certificates - Certificate has a valid private key - Certificate subject: *.imidro.gov.ir - Port 443 is available and not currently bound to another service Issue: When configuring HTTPS in Report Server Configuration Manager, the URL reservation succeeds, but certificate binding fails. Configuration Manager log: Create certificate binding. We were unable to create the certificate binding. Reserving url https://+:443 The url was successfully reserved. The specified url was unexpectedly reserved. The previous reservation has been overridden. Additional troubleshooting performed: 1. Verified that the certificate contains a private key: "You have a private key that corresponds to this certificate." 2. Checked SSL bindings: netsh http show sslcert No existing SSL bindings were found. 3. Verified port 443: No process is listening on TCP 443. 4. Certificate verification: certutil -verifystore my Output includes: Incomplete certificate chain Cannot find certificate: CN=Certum Domain Validation CA SHA2 5. Certificate Path tab shows: The issuer of this certificate could not be found. Questions: - Can an incomplete certificate chain cause Power BI Report Server to fail during SSL certificate binding? - Does PBIRS require the full certificate chain (Intermediate and Root CA certificates) to be installed before creating the binding? - Has anyone successfully configured HTTPS on Windows Server 2025 with a similar setup? Any guidance would be appreciated. Thank you.Solved1.1KViews0likes3Comments
Report Server on Virtual Machine Problem
Hello, We are using RS engine on Virtual Machine. Despite having robust hardware, the system becomes unresponsive due to 100% CPU usage, primarily driven by the msmdsrv.exeprocess. Environment Details: Hardware: VM with 16 vCPUs and 128 GB RAM. Workload: ~1000 reports with approximately 1030 scheduled refreshes per day. Observations: RAM usage is stable and within limits, but CPU spikes to 100% and stays there, causing the portal to hang. Steps Taken (No significant improvement): Adjusted MemorySafetyMargin, MemoryThreshold, and CleanupCycleLimit. Increased tempDBInitialSize and adjusted MaxActiveReqForOneUser. IT has reviewed Local Security Policies and determined they are not the primary bottleneck. Specific Questions: Since msmdsrv.exe (Analysis Services Engine) is the main consumer of CPU, what are the best practices for Resource Governance in a shared PBIRS environment with 1000+ refreshes? Would limiting CoordinatorExecutionMode or tuning ThreadPool\Process\MaxThreads within msmdsrv.inibe recommended for a 16-core setup to prevent thread contention? Are there any known issues with the January 2026 buildregarding how the Data Mashup Engine hands over tasks to the Analysis Services engine under parallel load? Beyond staggering refresh slots, are there internal PBIRS queuing mechanisms we can tune to throttle the number of concurrent msmdsrv tasks? Any architectural insights or advanced configuration suggestions would be greatly appreciated. Best Regards,Solved979Views0likes3Comments
Is pro or PPU license required with Power BI Report Server (PBIRS)?
Hi everyone, I’m a bit confused about the licensing requirements for Power BI Report Server (PBIRS). If we are hosting dashboards on PBIRS (on-premises), do end users need a Power BI Pro or Premium Per User (PPU) license to view the reports? Also, is a Pro/PPU license required only for developers who publish/creates reports, or does it apply to all users accessing the dashboards? I’ve gone through some documentation but I’m still not fully clear on how licensing works specifically for PBIRS vs Power BI Service. Would really appreciate if someone could clarify this. Thanks in advance!Solved2.1KViews0likes7CommentsPower BI Report Server licensing with SQL Server 2025 Standard when separating servers
Hi, I have a question regarding Power BI Report Server (PBIRS) licensing with SQL Server 2025 Standard Edition. In my architecture, I am planning to separate the Report Server and the SQL Server database into two different servers: - Server A: Power BI Report Server (PBIRS) - Server B: SQL Server hosting the ReportServer database My understanding is that SQL Server 2025 Standard Edition includes the rights to use Power BI Report Server. However, I am not clear about the licensing requirements in a separated server setup. My questions are: 1. If PBIRS and SQL Server are installed on separate servers, do both servers need to be licensed with SQL Server 2025 Standard (core-based licensing)? 2. Or is it sufficient to license only one server and use PBIRS across both? I understand that SQL Server uses a core-based licensing model per server, but I could not find clear documentation specifically addressing this scenario. Any clarification would be greatly appreciated. Thank you.Solved2.4KViews0likes3CommentsPower BI RS January 2026 – Reports Using RLS Enter Infinite Reload Loop
We upgraded to the January 2026 latest release of Power BI Report Server, which is reported to include a fix for this issue: Version: 1.25.9558.32914 (build 15.0.1120.122), Released: March 5, 2026 Fixed issue where Power BI reports with RLS get stuck spinning. However, this keeps happening for any user that is not set-up with a Role in the RLS report. This is very confusing; previous versions were displaying a relevant error message that helped identify the issue (missing access rights). But now the report keeps reloading over and over! Please advise Regards2.5KViews0likes8Comments
