Technical Issue - SSRS Power BI PDF export triggers Acrobat 110/117 errors on large tablix reports
SSRS Report / Power BI / PDF Export Issue (Not sure if it’s VS’s report designer or Power BI that’s causing this so I’m putting it here): Using VS 2026, Microsoft Reporting Services Projects 4.0.0, Power BI Report Server 1.26.9682.1442 (May 2026) I have this SSRS report (designed with Microsoft Reporting Services Projects 4.0.0) with a tablix that has nested row groups published on a Power BI server. When the report gets over about 2500 records (~220 pages maybe) the report still generates. But when I save as PDF from the report viewer, it does produce a fine PDF but when any changes are saved in it from Adobe Acrobat, we’ll either get error code 110 “Unrecognized object name” or 117 “Non-hex character in a hex string”. I found it’s not because of specific records because when I made it retrieve 2500 records it worked, when I made it retrieve 4000 records it produced a corrupt PDF, but when I had the report’s SQL query skip the first 2500 records and get only those 1500 records that apparently corrupted the PDF, it produced a noncorrupt PDF. This has been confirmed with other records as well. I’ve tried every combo of row group, cell, and tablix settings that were half reasonable to try. I’ve added in and stripped out accessibility features. I fixed all warnings given when deploying the report. It’s always the same thing, it’s fine until over about 2500 records. We need the PDF to be editable after generation; I’ve exhausted every option. If anyone knows how to fix this that’d be great.
Trying to understand Power BI Server and SSRS.
Hi, I am new to Power BI and have been asked to look at he benefits of going with Power BI Server... From my initial readings, it seems the advantages are that we can brand the dashboard as our own, as well as host both our Power BI Dashboards and reports alongide our existing SSRS reports in a single web portal, with Power BI Server essentially superceeding SSRS? I have a few queries regarding the SSRS Reports. 1, Will Power BI Report Server essentially replace the need for our exisiting SSRS Report Home? Is it just a case of deploying our .rld reports and data sources to the BI Report Server? 2, Can we still maintain folder security for the report? 3, Can I still schedule (subscribe) the reports to run and email to users as and when we choose? 4, Can the reports to continue to run, via stored procedure calls to our SQL server database? I think I read that they must connect to a SSAS instance? Thanks in advnace for any thoughts. Mark
Dataset in report has null in colunm, but data exists when executing query in SSMS or DaxStudio
Hi all, Strange thing here. I have a dax query which works fine in SSMS and in Dax Studio when I connect to SSRS-Server instance. But the same query shows for one column all null values in Report Builder when testing my report. What can it be ? Here is the query : EVALUATE SUMMARIZECOLUMNS ( 'Datum'[Maand], 'StockTerminal'[LocationName], 'YearChart'[GroupedCommodity], 'Datum'[Datum], 'Datum'[JaarMaand], 'Datum'[Jaar], FILTER ( VALUES ( 'YearChart'[GroupedCommodity] ), ( 'YearChart'[GroupedCommodity] <> BLANK () ) ), KEEPFILTERS ( TREATAS ( { "ARRIVED" }, YearChart[InboundStatus] ) ), FILTER ( VALUES ( 'Datum'[Jaar] ), ( 'Datum'[Jaar] = YEAR ( TODAY () ) ) ), "Qty", [Qty], "QtyPreviousMonth", [QtyPreviousMonth], "QtySamePeriodeLY", [QtySamePeriodeLY], "QtySamePeriode2YAGo", [QtySamePeriode2YAgo], "Difference", ( [Qty] - [QtySamePeriodeLY] ), "Difference2423", ( [QtySamePeriodeLY] - [QtySamePeriode2YAgo] ) )
SSRS Subscriptions "To" Field Not User Email
Hi, I know this has numerous other posts, but I could not find crystal clear, satisfactory answers in any of them. SSRS 2019 When a user subscribes to a report in SSRS, the "To" field is pre-populated. However, it is pre-populated with their username, not their email. In our case, the username is part of the email, e.g. "[email protected]". I tried altering the SendEmailToUserAlias attribute in the rsreportserver.config file, but changing this to False merely makes it editable, and we don't want it to be editable. We want the email to show up. (If it is editable, users could have control over the email a subscription it gets sent to, and the point of the feature is for them to be able to set up subscriptions for themselves.) (Mine does let me edit because of elevated permissions, but "To" is appropriately greyed out for standard users) Changing the DefaultHostName attribute doesn't seem to either update the pre-populated email nor does it seem to constrain the domain to which emails can be sent (which could maybe be okay if we really couldn't get the true email pre-populated, but isn't desirable either). I put the same host name that is used in Report Server Configuration Manager for the sender address, which is on the same domain as user email addresses. In AD, the userPrincipalName is the full email address. The only attribute that seems to have just the username is sAMAccountName - is this indeed what SSRS is pulling from? I would rather not have to change this attribute, but I might be willing to if it meant that users could subscribe to emails themselves automatically. Is there really NO way to have the "To" field pull in the users email address?SSRS Cilckable Images based on logged in user
Hi Community Support Team, Need help on below requirement / suggest a video. This should be Implemented in SSRS I have 6 images, these should be arranged in 2 rows and 3 columns, Image1 Image2 Image3 Image 4 Image 5 Image6 and have a below daatest with below details SELECT ImageID, ImageName, ImagePath, PageURL, UserID FROM ImageLinks WHERE UserID = @UserID The requirement is to display six images for all logged-in users, with only the images relevant to the user being clickable, while the rest remain non-clickable. Note: Userid parameter should display on top 1. Display all images 2. Add Page URL to 6 Images 3. let say, if User 1 is logged in he/she can only click relevant image, rest all non clickable. It should be dynamic ImageID ImageName ImagePath PageURL UserID 1 Realtime file:C:\Users\\Downloads https://Reports/powerbi//REALTIME%20ANALYTICS analytic1 2 Incident file:C:\Users\\Downloads https://Reports//INCIDENT%20ANALYTICS user5 3 Maintenance file:C:\Users\\Downloads https://Reports//MAINTENANCE%20ANALYTICS analytics2 4 Safety file:C:\Users\\Downloads https://Reports/SAFETY%20AND%20SECURITY%20ANALYTICS NULL 5 Operations file:C:\Users\\Downloads https:/Reports//OPERATIONS%20ANALYTICS User2 6 Landing Analytics file:C:\Users\\Downloads https://Reports/Landing%20Dashboard User3
SSRS Subscription Problem
I am using SSRS 2019, latest version, on Windows 2019 server. When I attempt to create a subscription, I get this error message in the SSRS log: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. I have checked the file system and this assembly is not present. How can I fix this? Where can I get this assembly?
SSRS- Report server connection pool issues.
Hi Team, I need help with new SSRS version Version16.0.8969.32906 we installed on our new server. At exactly 4PM there are lot of connections made and there are multiple errors ocurred e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.Runtime.InteropServices.COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3) at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendEntityBody(Void* chunks, UInt16 chunkCount, Boolean finalWrite, Boolean closeConn) at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush) library!ReportServer_0-11!50f8!02/17/2025-16:35:58:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::FlushResponse., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_SSRS_0-11-133842388366968385. ---> System.Runtime.InteropServices.COMException: The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3) at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush) at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush) --- End of inner exception stack trace ---; webserver!ReportServer_0-11!50f8!02/17/2025-16:35:58:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_SSRS_0-11-133842388366968385. ---> System.Runtime.InteropServices.COMException: The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3) webserver!ReportServer_0-11!50f8!02/17/2025-16:35:58:: e ERROR: RS.Server.HttpHandlerError {"shortHttpDescription":"Reporting Services Error","code":"500","path":"reportServiceHandlerWriteError","exceptionType":"Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException"} library!ReportServer_0-11!9648!02/17/2025-16:49:00:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ODS_CAA2'. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
Power BI Report Builder - Inconsistent Report Rendering Across Different Environments
We're experiencing inconsistent report rendering behavior for a SSRS/PBIR report (RDLP) across different environments. The report has been functioning correctly for 3 months until recently. Current Behavior: 1. Power BI Report Builder (Desktop): - Renders correctly with all expected data - Shows all 21 pages as designed 2. Customer Browser Access: - Only shows 4 pages - Incomplete data rendering 3. Developer Browser Access: - Shows blank/white page - No data rendered -Filters work and are selected correctly Technical Details: - Report Type: RDLP (Power BI Report Builder) - Data Source: Power BI Dataset - Recent Changes: None on our end - Duration of Issue: Recently emerged after working correctly for 3 months Expected Behavior: All environments should render the complete report (21 pages) with full data, matching the Power BI Report Builder preview. Impact: This inconsistency affects our production environment and customer experience. The report is critical for business operations and needs to render consistently across all access methods. Troubleshooting Steps Taken: 1. Verified data source connectivity 2. Confirmed report settings are identical across environments 3. Validated user permissions and access rights 4. Tested with multiple browsers and users ( IE, Chrome Opera) 5. Affects mutlible reports. Request: Please investigate potential service layer changes that might affect report rendering consistency across different access methods. Could you please provide guidance on: 1. Known service-side changes that might affect rendering, last update date? any breaking changes? 2. Recommended configuration adjustments 3. Any required updates to maintain consistent behavior I know this is in preview still but customers need this especially moving from on prem to cloud. #Claude generated text 😉
