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 😉
Image rotate when exported to pdf
If a report is rendered with an image (with an "External" source and a URL in the expression) it is OK, but when it is exported to PDF the image gets rotated -90º on the PDF file. This issue can be seen in several versions of SSRS and on the MS PowerBI Paginated Reports. I really appreciate any help you can provide. Report Builder: Power BI Online: PDF: Thank you MM
