{"id":1379,"date":"2024-03-31T14:15:27","date_gmt":"2024-03-31T12:15:27","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1379"},"modified":"2024-03-31T14:15:27","modified_gmt":"2024-03-31T12:15:27","slug":"dynamic-subscriptions-with-email-in-power-bi-paginated-reports-part-2","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1379","title":{"rendered":"Dynamic subscriptions with email in Power BI \/ paginated reports &#8211; Part 2"},"content":{"rendered":"\n<p>As with Power BI, the paginated reports use the same procedure and the same requirements. The technology is currently still in preview mode and can only be used with a premium capacity. In this entry I show how to use this.<\/p>\n\n\n\n<p>The semantic model from the previous entry is currently still in my workspace:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-18.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"432\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-18.png\" alt=\"\" class=\"wp-image-1380\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-18.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-18-300x137.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-18-768x351.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>The semantic model also contains the addresses to which emails should be sent as a subscription. But first I created the report with an appropriate parameter to filter the data. This is similar to line-based security, but is not used here because the service is not the user calling the report, but the service.<\/p>\n\n\n\n<p>The report is created using the Power BI Report Builder. <\/p>\n\n\n\n<p>To do this, connect to the Power BI service:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-19.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"452\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-19.png\" alt=\"\" class=\"wp-image-1381\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-19.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-19-300x143.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-19-768x367.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Now you can build the semantic model. It should be noted that this functionality is also available without adding premium capacity. However, this capacity is necessary when it comes to sending emails:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-20.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"515\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-20.png\" alt=\"\" class=\"wp-image-1382\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-20.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-20-300x163.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-20-768x419.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>A query must then be created on the semantic model to obtain the corresponding data:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-21.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"857\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-21.png\" alt=\"\" class=\"wp-image-1383\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-21.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-21-300x272.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-21-768x696.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>What is important is that the corresponding parameter is defined according to which the data should be filtered. To do this, I filter the data by country similar to the previous entry. This parameter can then be reused in the other datasets.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-22.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"443\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-22.png\" alt=\"\" class=\"wp-image-1384\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-22.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-22-300x141.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-22-768x360.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>After confirming, you will find the data in the report, including the parameters, and you can create the report.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-23.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"451\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-23.png\" alt=\"\" class=\"wp-image-1385\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-23.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-23-300x143.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-23-768x367.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>When you run the report, you will be asked to fill the parameter and then the data will be filtered accordingly:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-24.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"456\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-24.png\" alt=\"\" class=\"wp-image-1386\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-24.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-24-300x145.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-24-768x371.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>The report can now be uploaded to the Power BI service.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-25.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"515\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-25.png\" alt=\"\" class=\"wp-image-1387\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-25.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-25-300x163.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-25-768x419.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>The report can then be called up in the Power BI service and the corresponding parameters can be passed to it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-26.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"432\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-26.png\" alt=\"\" class=\"wp-image-1388\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-26.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-26-300x137.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-26-768x351.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>A corresponding subscription can now be created for this.<\/p>\n\n\n\n<p>Premium capacity is then required for this functionality.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-27.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"432\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-27.png\" alt=\"\" class=\"wp-image-1389\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-27.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-27-300x137.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-27-768x351.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>The procedure here is the same as when subscribing to Power BI reports.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-28.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"432\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-28.png\" alt=\"\" class=\"wp-image-1390\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-28.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-28-300x137.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-28-768x351.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>With this functionality, however, it is possible to use additional export formats instead of just using a PDF or PowerPoint<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-29.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"432\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-29.png\" alt=\"\" class=\"wp-image-1391\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-29.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-29-300x137.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-29-768x351.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>After the subscription is executed, the report will be sent to recipients in the selected export format:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-30.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"361\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-30.png\" alt=\"\" class=\"wp-image-1392\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-30.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-30-300x115.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2024\/03\/image-30-768x293.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>As with Power BI, the paginated reports use the same procedure and the same requirements. The technology is currently still in preview mode and can only be used with a premium capacity. In this entry I show how to use &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=1379\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1379"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1379"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1379\/revisions"}],"predecessor-version":[{"id":1393,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1379\/revisions\/1393"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}