subscription
41 Topics
The subscription function cannot display all the table data completely.
There are tables in the report, but the PPT and PDF generated by the subscription function cannot display all the table data completely. Could you tell me where the settings are to show everything in full?Solved973Views0likes5Comments
Create Email Subscription for Power BI Report Server (On Premise) Not asking about paginated reports
Hello Everyone, Hope you are doing great. I want to setup email subscription(get daily emails of the pages of reports) on my Reporting server (on premise). As per Microsoft docs we can't do it (Comparing Power BI Report Server and the Power BI service - Power BI | Microsoft Learn) as of August 2022. See attached image. Can someone tell me if it is available now/any workaround to have the email subscription? Note: this question is not regarding subscription of paginated reports.Solved9.3KViews0likes7Comments
Problem with subscription in Paginated Report
Hello 🙂 I hope someone will be able to tell me where to look for the error 🙂 Environment : Version 1.22.9153.7886 January 2025 Error Message: “Failure sending mail: Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.ReportingServices.ProcessingObjectModel, Version=2024.9.0.0, Culture=neutral, PublicKeyToken=89845dcdxxxxxxx' or one of its dependencies. The lo” The above error occurs on;y occasionally when we try to delivery the report to an emial adrdress (automatic subscription) Usually, after a few manual attempts (we trigger the subscription manually by clicking the "run now" button), the report eventually reaches the recipeint. Br, MateuszSolved960Views0likes1Comment
Email subscription screenshots with RLS applied
Hello, I have a report that shows aggregated data for multiple companies. I would like to send a daily email to a contact in each one of the companies that contains a screenshot of the report, filtered to the data for that company. I have published the report to the power bi service, set up a subscription and applied RLS in the report to ensure data is filtered to the relevent company when the subscribed user clicks on the link in the email. This all works as expected, however the screenshot does not show filtered data based on the user, rather it shows the aggregation of the entire dataset. Is it possible to show a filtered view in the email screenshot? Or have I missed something when setting up the subscription and RLS? Many thanks, ahurley4.1KViews0likes8CommentsUpdate from January 2023 to September 2023, now data-driven subscriptions not emailing!
Hi, We have updated our Power BI Report Server from January 2023 to September 2023, email delivery data-driven subscriptions (pageinated reports) were working, but not now! After the update, reports displayed properly. I could download and upload report definitions after making changes. There was an issue with regular email subscriptions not triggering but I found references to permission problems on the MSDB and Master databases for SQL Agent and granted them. Errors like this: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'sp_help_category' after fixing that, then had this one; System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_sqlagent_enum_jobs' Permissions granted: GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole use master; GO GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO [RSExecRole] GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO [RSExecRole] GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO [RSExecRole] GRANT EXECUTE ON master.dbo.sp_helplogins TO [RSExecRole] After the permission updates the email subscriptions started working. Test of File share type subscriptions were also successful. So far I have tested my data-driven subscription, the data source\dataset SELECT - it still works for the user defined. I can't seem to see anything else in SQL Server that may be the problem. Any ideas where to look next? Should we just rollback the server and try the update again? Completely uninstall and reinstall? Thanks Gord Error log details: ------------------------------------------------ schedule!WindowsService_2!5d0!10/25/2023-14:30:09:: i INFO: Handling event with data: TimeEntered: 10/25/2023 14:30:09, Type: Event, EventType: TimedSubscription, SubscriptionID: 992cbf9a-d7ec-4456-91da-a7087a3c6306. library!WindowsService_2!5d0!10/25/2023-14:30:09:: i INFO: Schedule 037d0970-8df9-4bc0-9006-54effd424f0c executed at 10/25/2023 14:30:09. schedule!WindowsService_2!5d0!10/25/2023-14:30:09:: i INFO: Creating Time based subscription notification for subscription: 992cbf9a-d7ec-4456-91da-a7087a3c6306 library!WindowsService_2!5d0!10/25/2023-14:30:09:: i INFO: Schedule 037d0970-8df9-4bc0-9006-54effd424f0c execution completed at 10/25/2023 14:30:09. schedule!WindowsService_2!de8!10/25/2023-14:30:09:: i INFO: Handling event with data: TimeEntered: 10/25/2023 14:30:09, Type: Event, EventType: DataDrivenSubscription, SubscriptionID: 992CBF9A-D7EC-4456-91DA-A7087A3C6306. library!WindowsService_2!1100!10/25/2023-14:30:09:: i INFO: Handling data-driven subscription 992cbf9a-d7ec-4456-91da-a7087a3c6306 to report /SubscriptionTesting/SSRSReportTesting, owner: (xxxADxxx)\(xxxUserxxx), delivery extension: Report Server Email. library!WindowsService_2!1100!10/25/2023-14:30:09:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. dataextension!WindowsService_2!1100!10/25/2023-14:30:09:: i INFO: Opening SqlConnection with ClientConnectionId f3c89dba76ae4b07a895ccd8d1eae9ba library!WindowsService_2!694!10/25/2023-14:30:09:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. notification!WindowsService_2!694!10/25/2023-14:30:09:: i INFO: Handling subscription 992cbf9a-d7ec-4456-91da-a7087a3c6306 to report SSRSReportTesting, owner: (xxxADxxx)\(xxxUserxxx), delivery extension: Report Server Email. emailextension!WindowsService_2!694!10/25/2023-14:30:09:: e ERROR: Error sending email. Exception: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification). Additional Information: notification!WindowsService_2!694!10/25/2023-14:30:30:: e ERROR: Error occurred processing subscription 992cbf9a-d7ec-4456-91da-a7087a3c6306: Failure sending mail: Object reference not set to an instance of an object.Mail will not be resent. notification!WindowsService_2!694!10/25/2023-14:30:30:: i INFO: Notification f85c3820-d88a-4b79-92e7-bb9bd16caaed completed. Success: False, Status: Failure sending mail: Object reference not set to an instance of an object.Mail will not be resent., DeliveryExtension: Report Server Email, Report: SSRSReportTesting, Attempt 0Solved2.5KViews2likes7CommentsPBIRB Subscription to Folder
Is it possible to set up a subscription to a desktop folder? For example, can I create a PBIRB report and set up a subscription to export a PDF to a designated folder? I know older versions of Report Builder could do this, but I couldn't find an option for PBIRB. I tried looking through all the subscription settings and browsing online for an answer. I have a colleague who wants files saved to a specific folder daily. Alternative ideas are also welcome. Thank you!Solved2.6KViews0likes5CommentsSubscriptions API does not work?
Hello Folks, I've been struggling with the PBIRS API these days to move the whole content from one to another server. All goes fine until I faced some kind of inconsistences in the /subscriptions endpoint with post method. I'm sending the proper payload as body, as is it defined on https://app.swaggerhub.com/apis-docs/microsoft-rs/PBIRS/2.0#/Subscriptions/AddSubscription I fall back to the SOAP endpoints and, after review it, I found that the new Rest API is missing few important data to be able to create a new subscription. LocalizedDeliveryExtensionName is JUST a string, and nothing else. However, I think there are more details to add define the deliveryExtension settings (account, file share, etc..) For records, here is a sample of the payload I'm sending to the server: { "Id": "b872df6e-4147-403b-a343-c1481329828b", "Owner": "DEMOS2016\\SolidQMaster", "IsDataDriven": false, "Description": "TestSubscription99", "Report": "/TestingUploads/otherFolder/subfolder/performance_dashboard_main", "IsActive": true, "EventType": "TimedSubscription", "Schedule": { "ScheduleID": null, "Definition": { "StartDateTime": "2018-10-29T02:00:00Z", "EndDate": "0001-01-01T00:00:00Z", "EndDateSpecified": false, "Recurrence": { "MinuteRecurrence": null, "DailyRecurrence": { "DaysInterval": 1 }, "WeeklyRecurrence": null, "MonthlyRecurrence": null, "MonthlyDOWRecurrence": null } } }, "ScheduleDescription": "At 2:00 AM every day, starting 10/29/2018", "LastRunTime": "2018-10-29T11:28:39.953Z", "LastStatus": "The file \"performance_dashboard_main.docx\" has been saved to the \"\\\\sql2017box01\\Delivery\" file share.", "DataQuery": null, "ExtensionSettings": null, "DeliveryExtension": "Report Server FileShare", "LocalizedDeliveryExtensionName": "Windows File Share", "ModifiedBy": "DEMOS2016\\SolidQMaster", "ModifiedDate": "2018-10-29T12:55:37.57Z", "ParameterValues": [ { "Name": "Server", "Value": "localhost", "IsValueFieldReference": false } ] } And here the powershell command posting the request on the server: Invoke-restmethod -Uri "$DestServer/api/v2.0/Subscriptions" -body $Body ` -ContentType 'application/json' ` -UseDefaultCredentials -Method Post -Verbose Any clue would be appreciated. Thanks beforehand. Regards, Víctor M.1.5KViews1like1Comment
Power BI Report Subscription - no excel option?
Hello, I am using Power BI 'create a subscription' cunction to generate activity reports for my customers monthly. I rely on this to send me the data for each respective customer on a monthly basis for my review and then I share my notes of their activity for them to action any issues I find. The issues I am having are two fold. First, I cannot have the system simply send me the data in excel format. The only options I have are a png image and a power point presentation. Neither of these allow me to edit the data and to highlight or notate the issues to the customer. Secondly, the images I am receiving do not show all rows, there is no scrolling functionality and the image always cuts off the bottom row of "totals" which is very important for the customer to see. My end goal is to have Power BI send me these respective reports in excel format monthly. Otherwise, the emails I am receiving from Power BI are only serving as a notice for me to go in and pull the reports I am asking it to pull on a monthly basis which is defeating the point.670Views1like0Comments
Problem altering a subscription / JSON reader error
Hi all, after updating to Sep 22 Update, we have problems with changes in subscriptions to paginated reports. We do the changes and after clicking on "Apply" we receive a "there was an error" - "sorry there was an error, please try again." message box. We hunted down the topic in the log files and found out, that in the RSPortal log file after the PUT request for the Subscription there is a warn message: "BadRequest, Errors: An unexpected instance annotation name 'DaysOfWeek.Sunday' was found when reading from the JSON reader, In OData, Instance annotation name must start with @." In original it looks as following: 2022-10-17 08:00:19.1267|INFO|204|Received request PUT /api/v2.0/subscriptions(c2c964fc-149a-41b3-b578-a94e7045f41e)| RequestID = s_cc703e8e-f941-4a95-9508-8b0ebb994806 2022-10-17 08:00:19.1892|WARN|204|BadRequest, Errors: An unexpected instance annotation name 'DaysOfWeek.Sunday' was found when reading from the JSON reader, In OData, Instance annotation name must start with @.| RequestID = s_cc703e8e-f941-4a95-9508-8b0ebb994806 We have installed the german version of PBIRS. Any suggestions how to solve the problem? Best regards, ThomasSolved10KViews0likes23CommentsPaginated Report Email Subscription
Hi everyone, I m trying to create a email suscription for a paginated report to be sent out everyday. I was successfull in creating a pdf subscription. The issue I am having is adding a date to the pdf. Foe example. The email for a day shows up as - "Email subject line 10/07/2022 8:00:00 AM". So that is good but the name of the PDF remains the same each day. I need the PDF attached in the email to also show the date like above for each day Any help is highly appreciated. Thank you.Solved904Views0likes1Comment
