{"id":1221,"date":"2022-06-14T15:19:32","date_gmt":"2022-06-14T13:19:32","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1221"},"modified":"2022-06-14T15:19:32","modified_gmt":"2022-06-14T13:19:32","slug":"a-look-to-power-bi-power-automate-visual","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1221","title":{"rendered":"A look to Power BI Power Automate Visual"},"content":{"rendered":"\n<p>Inside Power BI you have access to the Power Automate visual. With that, you can create and trigger flows and give your users more possibilities to interact with your data. This post shows you, how your users can send out information\u2019s. So, I have created y report based on the Dashboard in a Day data with a country slicer and I have added a Power Automate visual. To the visual I have added the country column and a measure, <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-18.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"555\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-18.png\" alt=\"\" class=\"wp-image-1222\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-18.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-18-300x176.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-18-768x451.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Inside the flow I have added a parsing JSON and an email task. The JSON task is needed to get out the fields of the sanded data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-19.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"374\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-19.png\" alt=\"\" class=\"wp-image-1223\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-19.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-19-300x119.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-19-768x304.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Inside the task I have added a sample of the provided JSON. To get another one you can debug the flow and can get out an example.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\r\n    \"type\": \"object\",\r\n    \"properties\": {\r\n        \"entity\": {\r\n            \"type\": \"object\",\r\n            \"properties\": {\r\n                \"Power BI values\": {\r\n                    \"type\": \"array\",\r\n                    \"items\": {\r\n                        \"type\": \"object\",\r\n                        \"properties\": {\r\n                            \"Country\": {\r\n                                \"type\": \"string\"\r\n                            },\r\n                            \"Sales\": {\r\n                                \"type\": \"number\"\r\n                            }\r\n                        },\r\n                        \"required\": &#91;\r\n                            \"Country\",\r\n                            \"Sales\"\r\n                        ]\r\n                    }\r\n                }\r\n            }\r\n        }\r\n    }\r\n}\r\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-20.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"748\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-20.png\" alt=\"\" class=\"wp-image-1224\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-20.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-20-300x237.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-20-768x608.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Inside the email task, I have added a fixed email address. This can also be provided by data driven. Next you can format your email.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-21.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"635\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-21.png\" alt=\"\" class=\"wp-image-1225\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-21.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-21-300x202.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-21-768x516.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>After saving the flow, you can trigger them by filtering the data by using the slicer and clicking the button. It is easier by doing this at the service canvas.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-22.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"410\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-22.png\" alt=\"\" class=\"wp-image-1226\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-22.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-22-300x130.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-22-768x333.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Now your users will receive the selected information.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-23.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"664\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-23.png\" alt=\"\" class=\"wp-image-1227\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-23.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-23-300x211.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-23-768x540.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Inside Power BI you have access to the Power Automate visual. With that, you can create and trigger flows and give your users more possibilities to interact with your data. This post shows you, how your users can send out &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=1221\">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\/1221"}],"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=1221"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1221\/revisions"}],"predecessor-version":[{"id":1228,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1221\/revisions\/1228"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}