{"id":834,"date":"2020-12-28T13:51:23","date_gmt":"2020-12-28T11:51:23","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=834"},"modified":"2021-01-24T18:52:59","modified_gmt":"2021-01-24T16:52:59","slug":"directquery-realtime-datasets-and-the-composite-model","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=834","title":{"rendered":"DirectQuery Realtime Datasets and the composite model"},"content":{"rendered":"\n<p>I really like the Realtime datasets in Power BI, especially why it is really easy to create one &#x1f60a; on the past you create on use it in the service or use it via the Desktop by using the Datasets connector. But there was not so much possibilities to make more with the data, e.g. to merge it with other sources. So you created \u201ccomplex\u201d processes via Azure, push the Realtime data into a SQL DB and then you are able to merge the data.<br>With the <a href=\"https:\/\/powerbi.microsoft.com\/de-de\/blog\/directquery-for-power-bi-datasets-and-azure-analysis-services-preview\/\">Direct Query mode for datasets<\/a> it is more easier. You can connect to the Realtime Dataset, import other data and analyze them.<\/p>\n\n\n\n<p>A small example:<br><br>Create a Streaming Dataset at Power BI<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-50.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"399\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-50.png\" alt=\"\" class=\"wp-image-835\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-50.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-50-300x198.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-50-455x300.png 455w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>With the examples for PowerShell and so on it is very easy to add data to this dataset<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-51.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"398\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-51.png\" alt=\"\" class=\"wp-image-836\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-51.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-51-300x197.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-51-456x300.png 456w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>Now you can connect to this dataset via the Power Desktop (you must enable the preview feature) and load other data from different datasources into your model:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-52.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"363\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-52.png\" alt=\"\" class=\"wp-image-837\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-52.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-52-300x180.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-52-500x300.png 500w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>The you can create relationships between the data and analyze them<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-53.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"353\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-53.png\" alt=\"\" class=\"wp-image-838\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-53.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-53-300x175.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2020\/12\/image-53-500x292.png 500w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p>Unfortunately it is not possible to modify the metadata, like to add translations via the Tabular Editor to the data from the Streaming Dataset. It is only possible from the data from other sources.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I really like the Realtime datasets in Power BI, especially why it is really easy to create one &#x1f60a; on the past you create on use it in the service or use it via the Desktop by using the Datasets &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=834\">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,30,41],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/834"}],"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=834"}],"version-history":[{"count":2,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/834\/revisions"}],"predecessor-version":[{"id":951,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/834\/revisions\/951"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}