{"id":1005,"date":"2021-06-27T15:49:11","date_gmt":"2021-06-27T13:49:11","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1005"},"modified":"2021-06-27T15:49:11","modified_gmt":"2021-06-27T13:49:11","slug":"paginated-report-visual-and-exporting-data-for-printouts","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1005","title":{"rendered":"Paginated Report Visual and exporting data for printouts."},"content":{"rendered":"\n<p>The story is very simple, but it is often needed. In this case, you have a Power BI report and your Sales managers needs reports, which can be used offline. In Germany we like Printouts &#x1f60a;<br>So, I created a Power BI Reports which connects to a database and provides insights to each customer. But\u00a0 this report is not designed for print out and the consumers want to analyze the data, and if needed, they want to generate a printout with some needed data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-11.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"364\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-11.png\" alt=\"\" class=\"wp-image-1006\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-11.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-11-300x180.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-11-500x300.png 500w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>When you build a Power BI which should be re-used with Paginated Reports, you should build explicit Measures, because with RS you cannot build implicit Measures. This report is published to the service, because with Paginated Reports you can connect to this dataset and so, you must not rebuild the model. Now I have created a Paginated Reports which connects to this data model which shown below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-12.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"375\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-12.png\" alt=\"\" class=\"wp-image-1007\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-12.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-12-300x186.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-12-484x300.png 484w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>Now I created the reports which are designed for printouts and saved them to the service.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-13.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"337\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-13.png\" alt=\"\" class=\"wp-image-1008\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-13.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-13-300x167.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-13-500x279.png 500w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>Next, I used the Paginated Report visual inside of Power BI Desktop and embedded the Paginated Report with the Company Name property as the parameter. I also activated in the properties of this visual the Toolbar (needed for exporting) and the auto-apply of filters.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-14.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"364\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-14.png\" alt=\"\" class=\"wp-image-1009\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-14.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-14-300x180.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-14-500x300.png 500w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>After publishing this Power BI Report again, it looks like this and your Sales managers can analyze the data and, export the needed information or print out the pages:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-15.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"330\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-15.png\" alt=\"\" class=\"wp-image-1010\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-15.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-15-300x164.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-15-500x273.png 500w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>So, I think it is very useful to re-use your datasets, because your model only exists on time, and this makes the maintenance a little bit easier.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-16.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"330\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-16.png\" alt=\"\" class=\"wp-image-1011\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-16.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-16-300x164.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/06\/image-16-500x273.png 500w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The story is very simple, but it is often needed. In this case, you have a Power BI report and your Sales managers needs reports, which can be used offline. In Germany we like Printouts &#x1f60a;So, I created a Power &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=1005\">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\/1005"}],"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=1005"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1005\/revisions"}],"predecessor-version":[{"id":1012,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1005\/revisions\/1012"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}