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.
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, ahurleySubscriptions 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.
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.
