{"id":1196,"date":"2022-06-01T14:37:41","date_gmt":"2022-06-01T12:37:41","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1196"},"modified":"2022-06-01T14:37:41","modified_gmt":"2022-06-01T12:37:41","slug":"a-first-look-to-power-bi-datamarts","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1196","title":{"rendered":"A first look to Power BI Datamarts"},"content":{"rendered":"\n<p>With Datamarts you can create Power BI models directly inside the cloud. You can use Power Query to make some ETL actions and DAX to create measures. To show you this, I have created a small demonstration. For doing this, you need a Premium capacity or Premium per user (PPU)<\/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.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"503\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image.png\" alt=\"\" class=\"wp-image-1197\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-300x160.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-768x409.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>After clicking \u201cGET DATA,\u201d you can select your driver to get the 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-1.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"503\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-1.png\" alt=\"\" class=\"wp-image-1198\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-1.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-1-300x160.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-1-768x409.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>I\u2019ve selected a file from my OneDrive, but xou are also able to get data from your local environment by using a Gateway.<\/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-2.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"503\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-2.png\" alt=\"\" class=\"wp-image-1199\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-2.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-2-300x160.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-2-768x409.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-3.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"503\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-3.png\" alt=\"\" class=\"wp-image-1200\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-3.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-3-300x160.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-3-768x409.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Next you can do your ETL steps with PowerQuery.<\/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-4.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"503\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-4.png\" alt=\"\" class=\"wp-image-1201\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-4.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-4-300x160.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-4-768x409.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Next, you are in the screen to do some modeling steps, like after closing the Power Query Editor at your Power B\u2019I Desktop. Here you can create measure, and if your multiple tables, you can create relationships or you can discover your data with T-SQL.<\/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-5.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"503\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-5.png\" alt=\"\" class=\"wp-image-1202\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-5.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-5-300x160.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-5-768x409.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Inside now your workspace you will find a dataset and the mart. The dataset is not needed for this case, and you can ignore that. By opening the settings of the mart, you will find a connection string to your mart by using the Management Studio, you can connect to the mart, and you can also query the data by using the views.<\/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-6.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"555\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-6.png\" alt=\"\" class=\"wp-image-1203\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-6.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-6-300x176.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-6-768x451.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n\n\n\n<p>Next, you can create reports on top of the mart and share it with your users<\/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-7.png\"><img decoding=\"async\" loading=\"lazy\" width=\"945\" height=\"503\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-7.png\" alt=\"\" class=\"wp-image-1204\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-7.png 945w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-7-300x160.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2022\/06\/image-7-768x409.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>With Datamarts you can create Power BI models directly inside the cloud. You can use Power Query to make some ETL actions and DAX to create measures. To show you this, I have created a small demonstration. For doing this, &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=1196\">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\/1196"}],"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=1196"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1196\/revisions"}],"predecessor-version":[{"id":1205,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1196\/revisions\/1205"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}