{"id":95188,"date":"2022-12-12T17:00:07","date_gmt":"2022-12-12T17:00:07","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=95188"},"modified":"2024-09-03T20:15:19","modified_gmt":"2024-09-03T20:15:19","slug":"whats-new-on-power-bi-datamarts-ui","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/whats-new-on-power-bi-datamarts-ui\/","title":{"rendered":"What’s new on Power BI DataMarts UI"},"content":{"rendered":"

I wrote an article about Power BI Datamarts<\/strong><\/a> which was released together the feature, on the exact moment it was being announced in a conference. Of course, this feature has being evolved since that time.<\/p>\n

I would emphasize the performance. The general UI performance seems way better than when it was first released. Let’s talk about some more news on the Power BI Datamarts<\/strong>, specially on the UI.<\/p>\n

It’s easier to change the datamarts name<\/h2>\n

By clicking on the top of the window, on the datamart name, we can easily change the datamart name. When it was first created, the name was default and the datamart had to be renamed later.<\/p>\n

\"Texto\n\nDescri\u00e7\u00e3o<\/p>\n

We can save queries<\/h2>\n

A very welcome new feature for exploratory analysis is the possibility to save the queries we built. Either Visual Queries or SQL Queries, we can save and name them.<\/p>\n

\"Interface<\/p>\n

\"Interface<\/p>\n

Apparently, we can\u2019t delete the queries yet, only save, but one problem at a time.<\/p>\n

SQL Queries in a different place<\/h2>\n

The SQL Queries are not in the lower tabs anymore, but in a top button, a bit more hidden. Probably most users prefer the visual query than the SQL Query.<\/p>\n

\"Interface<\/p>\n

Export to Excel in Visual Queries<\/h2>\n

When I first wrote about Power BI datamarts, the Open in Excel<\/em> option was only available for SQL Queries, not for Visual Queries.<\/p>\n

Of course, it was just a matter of time for the Export to Excel be included in the Visual Query as well.<\/p>\n

<\/p>\n

Power BI Desktop connection to SQL<\/h2>\n

When we try to connect from Power BI desktop to the datamart, now we have the option to choose if we would like to connect to the azure SQL behind the scenes or make a live connection to the Power BI Analysis Services, connecting to the model.<\/p>\n

\"Interface<\/p>\n

Datamart Connectivity<\/h2>\n

Using Power BI Desktop<\/strong>, you can connect either to the Dataset or the Datamart and the result will be the same: It appears as a live connection to Analysis Services<\/strong>, the Power BI<\/strong> underlying engine, in a simplified way.<\/p>\n

<\/p>\n

In order to build a composite model, mixing the data from the data mart and other sources, you need the use of a preview feature: DirectQuery for PBI datasets and AS<\/strong><\/p>\n

<\/p>\n

Once this preview feature is enabled in Power BI Desktop<\/strong>, you can convert the Live connection in DirectQuery by clicking on the button Make Changes to this model.<\/em><\/p>\n

The message will request you to click on the button Add a local model<\/em>. This is exactly the difference between the Live connection and a composite model: The Live connection has no local model, is\u00a0 Live, while a composite model has a local model where the connections to the source are defined as DirectQuery or Import.<\/p>\n

\"Interface<\/p>\n

 <\/p>\n

Conclusion<\/h2>\n

In my humble opinion, the feature was already so good when it was released that it\u2019s receiving only few adjustments, but very welcome.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

I wrote an article about Power BI Datamarts which was released together the feature, on the exact moment it was being announced in a conference. Of course, this feature has being evolved since that time. I would emphasize the performance. The general UI performance seems way better than when it was first released. Let’s talk……<\/p>\n","protected":false},"author":50808,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,159166],"tags":[123648,147603,101611,147602],"coauthors":[6810],"class_list":["post-95188","post","type-post","status-publish","format-standard","hentry","category-blogs","category-powerbi","tag-data-platform","tag-datamarts","tag-power-bi","tag-power-bi-datamarts"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/50808"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=95188"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95188\/revisions"}],"predecessor-version":[{"id":95198,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95188\/revisions\/95198"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=95188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=95188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=95188"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=95188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}