tag:blogger.com,1999:blog-71494797264227486952024-03-16T23:32:38.850+01:00Fabric, Power BI, Power Platform, Data PlatformBlogging about Microsoft Fabric, Power BI, Power Platform and other things I find interesting.Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.comBlogger161125tag:blogger.com,1999:blog-7149479726422748695.post-91872285149760183082024-03-04T10:37:00.002+01:002024-03-04T10:47:56.055+01:00Governance & Administration - Tenant Settings: Visual Cues<div style="text-align: left;"><span style="font-size: medium;"><span>With all the Fabric announcements in the last months, some of the Admin announcements might have slipped through. As you might know, the Admin part of Fabric is dear to my heart. I've posted about it earlier </span><a href="https://www.nickyvv.com/2022/06/power-bi-governance-administration.html">here</a><span>, </span><a href="https://www.nickyvv.com/2020/05/power-bi-governance-administration-organizational-visuals.html">here</a><span>, </span><a href="https://www.nickyvv.com/2020/06/refresh-a-power-bi-dataset-with-powershell-and-a-service-principal.html">here</a><span>, and </span><a href="https://www.nickyvv.com/2020/07/using-power-bi-rest-api-as-admin.html">here</a><span>, to name a few π</span><span>.</span></span></div><p style="text-align: left;"><span style="font-size: medium;"><span>So in the next weeks I am going to highlight a few things with short, informative posts.</span></span></p><p style="text-align: left;"><span style="font-size: medium;">You can find other posts in the series here:</span></p><p style="text-align: left;"></p><ul style="text-align: left;"><li><a href="https://www.nickyvv.com/2024/02/governance-administration-fabric-tenant-settings-apis.html"><span style="font-size: medium;">Fabric (Tenant Settings) API's</span></a></li></ul><p></p><h2 style="text-align: left;">Visual cues</h2><div><span style="font-size: medium;">Today I want to talk about a new little addition Microsoft made to the Fabric Admin portal.</span></div><div><span style="font-size: medium;">This change has actually been here for quite a while now, but I still think it's worth mentioning because (1) I really like it, and (2) it's also an important change that the community, and MVP's in specific, has been requesting for quite some time.</span></div><div><span style="font-size: medium;"><br /></span></div><div><span style="font-size: medium;"><a href="https://www.linkedin.com/in/rksrinivasan/" target="_blank">Radhakrishnan Srinivasan</a> and (members of) his team added <b>visual cues</b> to the Admin portal of Fabric. These are green (or teal π) little pop-ups that show besides a menu item or tenant setting that has recently been changed, or added to the Admin portal.</span><br /></div><div><br /></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAAovxhHurvZ3rqITuwY-GTiSKnXd7ATuvuJO2oo_AbW0x4tRmz87p_QyTfq-hV_oPMNDE0XxDkbbixGTCc8SenzoOqJOY0OuZVPhdRpcxdEKE7ETffq3RwDnKAMlL6xN3KVW9zuhsD1lJPdOP9mmALvrgzEKIc2ldo1YpVu4cCJHIfr32WFumS03yHM0/s1026/Admin%20portal%20visual%20cues%201.png" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="650" data-original-width="1026" height="405" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAAovxhHurvZ3rqITuwY-GTiSKnXd7ATuvuJO2oo_AbW0x4tRmz87p_QyTfq-hV_oPMNDE0XxDkbbixGTCc8SenzoOqJOY0OuZVPhdRpcxdEKE7ETffq3RwDnKAMlL6xN3KVW9zuhsD1lJPdOP9mmALvrgzEKIc2ldo1YpVu4cCJHIfr32WFumS03yHM0/w640-h405/Admin%20portal%20visual%20cues%201.png" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><i>Visual cues in the Fabric Admin portal</i></td></tr></tbody></table><br /><div><br /></div><div><span style="font-size: medium;">I think this is really important so Administrators at least know that settings have been added (or changed) when they visit the Admin portal (which they should do regularly anyway in my opinion π).</span></div><div><span style="font-size: medium;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFEmiknXgMyBkZoqO8YDHX7DMUejPlZEVxL_8obFV-iVAcpvK7OeF7LvpCVT6iT4MOCRyo7oEQIIOBWw6ZySIhh5jt8_JJd8NjBddCmQK3jG6aTsqcxq0i1gTpADbUXDT6v4XMBnptQE4FqVabfGB3Tkz2w2XszWoD-W3gLdh9a2fmE_Dlnw5rP2dGxlY/s644/Admin%20portal%20visual%20cues%202.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: medium;"><img border="0" data-original-height="207" data-original-width="644" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFEmiknXgMyBkZoqO8YDHX7DMUejPlZEVxL_8obFV-iVAcpvK7OeF7LvpCVT6iT4MOCRyo7oEQIIOBWw6ZySIhh5jt8_JJd8NjBddCmQK3jG6aTsqcxq0i1gTpADbUXDT6v4XMBnptQE4FqVabfGB3Tkz2w2XszWoD-W3gLdh9a2fmE_Dlnw5rP2dGxlY/w640-h206/Admin%20portal%20visual%20cues%202.png" width="640" /></span></a></div><span style="font-size: medium;"><br /></span><div><span style="font-size: medium;">There is also a <i>sub-menu</i> on the top of the Tenant settings page that you can expand, showing all the newly added settings. This overview also has links to the corresponding setting so you can easily navigate there.</span></div><div><br /></div><h2 style="text-align: left;">Conclusion</h2><div><span style="font-size: medium;">I'm not sure how long a new cue is visible, it looks like the cut-off is around 30 days. </span></div><div><span style="font-size: medium;">The Domains cue is an exception I guess, it has been there since Domains have been added in the beginning.</span></div><div><span style="font-size: medium;"><br /></span></div><div><div><span style="font-size: medium;">Take advantage of this added funtionality, it helps you as an Administrator to prepare and be ready for new tenant settings:</span></div><div><ul style="text-align: left;"><li><span style="font-size: medium;">Sometimes a setting can have a default state that is not desirable for your organization, so you need to change it within a certain period</span></li><li><span style="font-size: medium;">Or you want to pro-actively communicate to your users that a certain settings is going to be enforced in the future. This could either be making a new feature available, disabling a new or existing feature for certain people, or slowly rolling out a feature to groups of people</span></li></ul></div><div><span style="font-size: medium;"><br /></span></div><div><span style="font-size: medium;">To look beyond the visual cue and what is possible, you could even build yourself a solution by actively searching the Admin portal for new options and automate that process.</span></div></div><div><span style="font-size: medium;"><br /></span></div><div><span style="font-size: medium;">If you are new to the Fabric Admin portal, you can get more info here:</span></div><div><ul style="text-align: left;"><li><a href="https://powerbi.microsoft.com/en-us/blog/new-tenant-setting-notifications-and-gettenantsettings-api/" target="_blank"><span style="font-size: medium;">Introducing Visual Cue for New Tenant Settings</span></a><br /></li><li><a href="https://learn.microsoft.com/fabric/admin/admin-center?WT.mc_id=DP-MVP-5003835#what-can-i-do-in-the-admin-portal" target="_blank"><span style="font-size: medium;">What is, and what can I do in the Fabric Admin Portal?</span></a><br /></li><li><a href="https://learn.microsoft.com/fabric/admin/about-tenant-settings?WT.mc_id=DP-MVP-5003835" target="_blank"><span style="font-size: medium;">About tenant settings</span></a><br /></li></ul></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-18226773799259467592024-02-26T08:44:00.003+01:002024-03-04T10:39:56.990+01:00Governance & Administration - Fabric (Tenant Settings) API's<span style="font-size: medium;">With all the Fabric announcements in the last months, some of the Admin announcements might have slipped through. As you might know, the Admin part of Fabric is dear to my heart. I've posted about it earlier <a href="https://www.nickyvv.com/2022/06/power-bi-governance-administration.html">here</a>, <a href="https://www.nickyvv.com/2020/05/power-bi-governance-administration-organizational-visuals.html">here</a>, <a href="https://www.nickyvv.com/2020/06/refresh-a-power-bi-dataset-with-powershell-and-a-service-principal.html">here</a>, and <a href="https://www.nickyvv.com/2020/07/using-power-bi-rest-api-as-admin.html">here</a>, to name a few π.<br /><br />So in the next weeks I am going to highlight a few things with short, informative posts.<br /><br />This first post in the series is focused on the Tenant settings API and other Fabric API's available at the time of writing.</span><div><span style="font-size: medium;"><br /></span></div><span style="font-size: medium;">You can find other posts in the series here:</span><div><ul style="text-align: left;"><li><span style="font-size: medium;"><a href="https://www.nickyvv.com/2024/03/governance-administration-tenant-settings-visual-cues.html">Tenant Settings: Visual Cues</a></span></li></ul><h2 style="text-align: left;">Get Tenant Settings API</h2><div><span style="font-size: medium;">Obviously, to use the <a href="https://learn.microsoft.com/en-us/rest/api/fabric/admin/tenants/get-tenant-settings?tabs=HTTP&WT.mc_id=DP-MVP-5003835" target="_blank">Get Tenant Settings</a> API you need to have at least Tenant.Read.All permissions, or have the Fabric Administrator role (or higher) in Azure.</span></div><div><span style="font-size: medium;">There are a few use cases I see for getting these settings exported with this API:</span></div><ul><li><span style="font-size: medium;">Documentation purposes when you have multiple Fabric Administrators</span></li><li><span style="font-size: medium;">Distributing tenant settings to users, and explaining why we (as a team of Administrators/within the Center of Excellence) made certain choices</span></li><li><span style="font-size: medium;">Get notified of the changes in the tenant settings, without having to use Microsoft Defender or M365 Security & Compliance center like mentioned <a href="https://www.coatesdatastrategies.com/blog/how-to-be-alerted-when-power-bi-tenant-settings-change" target="_blank">here</a></span></li></ul><div><br /></div><p></p><h3 style="text-align: left;"><span style="font-size: medium;">Get Capacities Tenant Settings Overrides</span></h3><p><span style="font-size: medium;">With the introduction of Fabric, there has also been the ability to have capacity admins override certain tenant settings. </span></p><p></p><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqfRx51YpHEXbrN9HzVmYB1hrnfL_wIid2x1_NYyaWMfsQNhmA14A5NfVQRcg3EFye0mN1jo05nQ_DC4e6JntfrPPR0Gbkt-NJs0tYsVOKFWmdrAlH4enNkDF-breYH2HYLtuq2BY5RUXcFIUIhOmmYtVMUmuSbyoMEljVNK5hbPkQv3WFn8v2W_QT74A/s583/Fabric%20delegated%20tenant%20setting.png" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="178" data-original-width="583" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqfRx51YpHEXbrN9HzVmYB1hrnfL_wIid2x1_NYyaWMfsQNhmA14A5NfVQRcg3EFye0mN1jo05nQ_DC4e6JntfrPPR0Gbkt-NJs0tYsVOKFWmdrAlH4enNkDF-breYH2HYLtuq2BY5RUXcFIUIhOmmYtVMUmuSbyoMEljVNK5hbPkQv3WFn8v2W_QT74A/s16000/Fabric%20delegated%20tenant%20setting.png" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><i>Example of a tenant setting that can be delegated</i></td></tr></tbody></table><br /><span style="font-size: medium;">Some settings in the Admin portal are automatically delegated to capacity admins, like shown above. </span><p></p><h2 style="text-align: left;">Other Fabric API's</h2><p><span style="font-size: medium;">Next to the API's on the tenant settings, there are already a lot more API's in the Admin section for you to check out, for example to handle <a href="https://learn.microsoft.com/en-us/rest/api/fabric/admin/workspaces?WT.mc_id=DP-MVP-5003835" target="_blank">workspaces</a>, <a href="https://learn.microsoft.com/rest/api/fabric/admin/users?WT.mc_id=DP-MVP-5003835" target="_blank">users</a>, <a href="https://learn.microsoft.com/rest/api/fabric/admin/domains?WT.mc_id=DP-MVP-5003835" target="_blank">domains</a>, and <a href="https://learn.microsoft.com/rest/api/fabric/admin/items?WT.mc_id=DP-MVP-5003835" target="_blank">items </a>as a Fabric Admin.</span></p><p><span style="font-size: medium;">Next to that, so not as a Fabric Admin, you can also interact with <a href="https://learn.microsoft.com/rest/api/fabric/lakehouse/tables?WT.mc_id=DP-MVP-5003835" target="_blank">Lakehouse tables</a>, and there's a bunch of Core API's, for example to use <a href="https://learn.microsoft.com/rest/api/fabric/core/git?WT.mc_id=DP-MVP-5003835" target="_blank">Git</a> or <a href="https://learn.microsoft.com/rest/api/fabric/core/onelake-shortcuts?WT.mc_id=DP-MVP-5003835" target="_blank">OneLake Shortcuts</a>.</span></p><h2 style="text-align: left;">Preview note</h2><div><span style="font-size: medium;">Please note that at the time of writing this post, most of the API's are still in preview and subject to change.</span></div><div><span style="font-size: medium;">Except for the <a href="https://learn.microsoft.com/en-us/rest/api/fabric/admin/tenants/get-tenant-settings?tabs=HTTP&WT.mc_id=DP-MVP-5003835" target="_blank">Get Tenant Settings</a> API, all the API's are currently in preview:</span></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRAjSMk3lMqsyvqpbTt3WWIkmroriiCRlB4QCC4C5EUpBiL9v05Al2yDfPqNBQkILC6cDd91CKL-Zjk_M5RTc5FPDhzHa8pmONTl51GdmeeDwaOST8TVxMarnTKfA8XQEsgBY3dajoZ2uWkBYMK5kWEeTrNXdtBIwBmBnDwR0S-BA1pko4EKfvPjPKMmU/s222/Fabric%20API's%20-%20API%20preview%20note.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="81" data-original-width="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRAjSMk3lMqsyvqpbTt3WWIkmroriiCRlB4QCC4C5EUpBiL9v05Al2yDfPqNBQkILC6cDd91CKL-Zjk_M5RTc5FPDhzHa8pmONTl51GdmeeDwaOST8TVxMarnTKfA8XQEsgBY3dajoZ2uWkBYMK5kWEeTrNXdtBIwBmBnDwR0S-BA1pko4EKfvPjPKMmU/s16000/Fabric%20API's%20-%20API%20preview%20note.png" /></a></div><br /><div><br /></div><div><br /></div></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-77548243585309487722024-01-25T08:42:00.002+01:002024-01-25T08:42:13.652+01:00The Conference Season Has Begun!<p>The conference season is kicking off again! I have quite some events and sessions already lined up for the next months, so I though I'll update you here.</p><p>First up is <a href="https://datasaturdays.com/2024-01-26-datasaturday0046/#schedule" target="_blank">Data Community Day Austria</a>, in Vienna. I'm actually at Schiphol Airport now, waiting to board my plane π I'm presenting a new session on Direct Lake in Microsoft Fabric.</p><p>In March, 7-9, the Dutch <a href="https://pbig.nl/events/power-bi-gebruikersdagen-2024/" target="_blank">Power BI Gebruikersdagen</a> are in Utrecht and I'm presenting a session on Saturday: How to use Power BI External Tools.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgRkuHdx_dKkJn1vlLH0EbHeWWe1g0Mx4Bs8-EXf2P4Jo-3UYIwADuKVa9h4gtRlj8iMOmHgpF8B2gagD_b0DUUhsWEydRE0DiOLDBa1nU7cQj1JIIfzclsIgB-rtDHT8qDLfZCqVjdFAiUBDifgyjLtA-TAeEAoWzW6Rvby2ropmTvxmYLslHpfYInvyw" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="377" data-original-width="775" height="312" src="https://blogger.googleusercontent.com/img/a/AVvXsEgRkuHdx_dKkJn1vlLH0EbHeWWe1g0Mx4Bs8-EXf2P4Jo-3UYIwADuKVa9h4gtRlj8iMOmHgpF8B2gagD_b0DUUhsWEydRE0DiOLDBa1nU7cQj1JIIfzclsIgB-rtDHT8qDLfZCqVjdFAiUBDifgyjLtA-TAeEAoWzW6Rvby2ropmTvxmYLslHpfYInvyw=w640-h312" width="640" /></a></div><br /><br /><p></p><p>After that is SQLBits, which I'm skipping this year. MVP Summit is unfortunately also online for me this year, but that has a very good reason...</p><p>Because, in the last week of March the <a href="https://azuredataconf.com/" target="_blank">Microsoft Fabric Community Conference</a> is happening in Las Vegas, and I'm delighted and excited to say I am presenting 2 sessions there!<br />The first session is with <a href="https://www.linkedin.com/in/ulrich-christ-489b99117/" target="_blank">Ulrich Christ</a>, Program Manager Azure Data Factory at Microsoft, and we are going to talk about <a href="https://azuredataconf.com/#!/session/Connecting%20to%20SAP%20Data%20with%20Data%20Factory%20in%20Microsoft%20Fabric/6325" target="_blank">Connecting to SAP Data with Data Factory in Microsoft Fabric</a>.<br />Because the second session is still in the works I can't share any details yet, so you'll just have to wait a bit longer for that.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjc3zv3QdHFR0Npx2J9KcRnY8ICusunMdbRy_HUaccQaHyejJUQBKk6wIQHnIGaEuT0RHDEipHWoT-7Q61uac_CNraGWKXdmUJg7ZbCoyh77jWpwZWRIrdGodLWr1tgn9CX9ZuDl2I9QOBUuKpNoOPHLnymnuf6akSgBgHcngC41H_3kIbwy2AEtp_zQI8" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="518" data-original-width="1127" height="294" src="https://blogger.googleusercontent.com/img/a/AVvXsEjc3zv3QdHFR0Npx2J9KcRnY8ICusunMdbRy_HUaccQaHyejJUQBKk6wIQHnIGaEuT0RHDEipHWoT-7Q61uac_CNraGWKXdmUJg7ZbCoyh77jWpwZWRIrdGodLWr1tgn9CX9ZuDl2I9QOBUuKpNoOPHLnymnuf6akSgBgHcngC41H_3kIbwy2AEtp_zQI8=w640-h294" width="640" /></a></div><br /><br /><p></p><p>After that, there's also <a href="https://datagrillen.com/theschedule/" target="_blank">DataGrillen</a> in Lingen, Germany on May 16 & 17. I'm presenting a session dear to my heart: Fabric Admin in a Day. Do check the amazing 2-day schedule on their site. It's also happening during the Kievelinge Fest, which happens the weekend right after DataGrillen, how convenient... π</p><p><br /></p><p>I'm very excited for the coming months and hope to see many of you there, meeting up with old friends and making new ones! π</p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-81178896672058295832023-11-15T20:01:00.164+01:002023-11-16T11:13:15.311+01:00Ignite News: Microsoft Fabric is Now GA (and more)!<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9tIrC1nO2b9bCqMwWnQmRfSvfRTR1nB1rwSY0_-I5zMsY0_o5mamZXYgDk_ckidcpZAqp4w43jWFTN2n3vUWnwtQhQjQT5_j0JvpXO0P2X2_CiLKmM60HILipzmVtr3i20rWf3sSk1kt4Sh0YybREJIRnl7VNWBxprEhFxXXpi_i5DW3uFSWXf_TsTB8/s2048/Fabric_2048.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="2048" data-original-width="2048" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9tIrC1nO2b9bCqMwWnQmRfSvfRTR1nB1rwSY0_-I5zMsY0_o5mamZXYgDk_ckidcpZAqp4w43jWFTN2n3vUWnwtQhQjQT5_j0JvpXO0P2X2_CiLKmM60HILipzmVtr3i20rWf3sSk1kt4Sh0YybREJIRnl7VNWBxprEhFxXXpi_i5DW3uFSWXf_TsTB8/s320/Fabric_2048.png" width="320" /></a></div><br /><p>Over the (roughly) last 6 months we all had the ability to play with <a href="https://learn.microsoft.com/fabric/?WT.mc_id=DP-MVP-5003835" target="_blank">Microsoft Fabric</a>, when it went Public Preview at Microsoft Build.</p><p>Now that the keynote of <a href="https://ignite.microsoft.com/" target="_blank">Microsoft Ignite</a> by CEO Satya Nadella has been delivered, and also the amazing in-depth Fabric session by Amir Netz, Arun Alagaratchagan: <a href="https://ignite.microsoft.com/en-US/sessions/1eff13d6-1924-435a-8778-111d7131f061?source=/schedule" target="_blank">Make your data AI ready with Microsoft Fabric and Azure Databricks</a>. Back then at Build, Satya <a href="https://www.youtube.com/watch?v=FaV0tIaWWEg&t=1326s" target="_blank">called it</a>:</p><p></p><blockquote>"...the biggest launch of a data product from Microsoft since the launch of SQL Server!"</blockquote><h2 style="text-align: left;">Generally available</h2><p>But now, Satya went one step further and announced <b><span style="font-size: medium;">GENERAL AVAILABITIY</span></b> of <b>Fabric</b>!</p><p>Also, <b>Copilot </b>in Fabric is now in <b>public preview</b>.</p><h2 style="text-align: left;">More updates</h2><p>There's a ton of updates inside Fabric on existing features on the <a href="https://www.microsoft.com/en-us/microsoft-fabric/blog/2023/11/15/prepare-your-data-for-ai-innovation-with-microsoft-fabric-now-generally-available/" target="_blank">latest Fabric blog here</a>.</p><p>And there are also some exciting new features:</p><p></p><ul style="text-align: left;"><li><b>Seamlessly connect your data sources to Fabric</b><br />The ability to create shortcuts was already there, where you virtualize data in OneLake without having to move or duplicate that data.. You can create shortcuts to another Lakehouse and Warehouse, but also to files on ADLS or even Amazon S3 or Google storage.<br />The newest feature just announced is called <b>Mirroring</b>, where you can add and manage existing cloud data warehouses (and databases) in Fabric's Data Warehouse experience. The way this works, is like replication in SQL Server. Fabric replicates a snapshot of that database to OneLake in Delta Parquet files and keeps that in sync in near real time, which relies on the Change Data Capture feature of the underlying source. Initially it's supported for Azure Cosmos DB, Azure SQL DB and Snowflake, more sources will follow next year.</li><li><b>Copilot in Power BI (public preview)</b><br />Just be aware that Copilot will be rolling out in stages, </li><ul><li>Smart Narrative is an existing visual in Power BI Desktop, now rebranded to Narrative with Copilot</li><li>The November Desktop update let's you generate synonyms for your fields, measures and tables using Copilot.</li><li>In the future, there's also going to be:</li><ul><li>a report creation experience</li><li>a DAX writing experience</li></ul></ul><li><a href="https://learn.microsoft.com/power-bi/enterprise/directlake-overview?WT.mc_id=DP-MVP-5003835" target="_blank">Direct Lake </a>support on Data Warehouse<br />There's also an update on the size limits of your Fabric capacity and when it will <a href="https://learn.microsoft.com/power-bi/enterprise/directlake-overview?WT.mc_id=DP-MVP-5003835#fallback" target="_blank">fallback to Direct Query</a>.</li><li>Stored credentials for Direct Lake semantic model<br />You can now specify a <a href="https://learn.microsoft.com/en-us/power-bi/enterprise/directlake-fixed-identity?WT.mc_id=DP-MVP-5003835" target="_blank">fixed identity</a> (like a service principal) for a Direct Lake mode semantic model</li><li>Pricing on Fabric is updated!<br /><a href="https://azure.microsoft.com/pricing/details/microsoft-fabric/?WT.mc_id=DP-MVP-5003835" target="_blank">Reserved pricing</a> is now available, with a rough discount of around 41% off of Pay-As-You-Go pricing.<br /></li><li><a href="https://learn.microsoft.com/en-us/power-bi/enterprise/onelake-integration-overview?WT.mc_id=DP-MVP-5003835" target="_blank">OneLake integration for Import-mode</a> semantic models is coming!<br />This allows for a seamless (at least that's what Microsoft claims π) integration for your import Power BI Desktop models into OneLake. I wonder if this also implies that you can convert your import report to a Direct Lake mode model afterwards. It's not totally clear to me at this point.</li></ul><div><i>[update on November 16th]</i></div><ul style="text-align: left;"><li>Power BI Desktop November is also out!<br /><a href="https://powerbi.microsoft.com/en-us/blog/power-bi-november-2023-feature-summary/" target="_blank">Power BI November 2023 Feature Summary</a></li><ul><li>DAX query view</li><li>Stored credentials for Direct Lake</li><li>Explore</li></ul></ul><h2 style="text-align: left;">Conclusion</h2><div>Will I now go all-in on Fabric? "It depends", but probably not π</div><div>I think it still depends on a case per case basis. Is it a <i>newish</i> customer with not too many investments in other data platform services like Synapse/Data Factory. Then it makes sense to evaluate the requirements and see if it's worthwhile to start with Fabric, considering a lot of features are still in preview, and others are not there yet.</div><div>On the other hand, if it's an existing customer with real estate in Synapse and databricks for example, where they implemented a medaillon structure and have infrastructure running there, I'd seriously reconsider if it's worth moving to Fabric. I'm leaning towards a <b>no</b> for now.</div><div><br /></div><div><br /></div><div>Keep a look out on the official Fabric and Power BI blogs and Microsoft Learn for all new content:</div><div><ul style="text-align: left;"><li><a href="https://powerbi.microsoft.com/en-au/blog/" target="_blank">https://powerbi.microsoft.com/en-au/blog/</a></li><li><a href="https://blog.fabric.microsoft.com/en-US/blog" target="_blank">https://blog.fabric.microsoft.com/en-US/blog</a></li><li><a href="https://learn.microsoft.com/en-us/fabric/get-started/whats-new" target="_blank">https://learn.microsoft.com/en-us/fabric/get-started/whats-new</a></li></ul></div><div><br /></div><div><br /></div><div><br /></div><div><i>I'm updating this post live while the updates are rolling out, so come back later for more updates!π</i></div><p></p><p></p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-86348903936825273192023-10-20T16:12:00.001+02:002023-10-20T16:12:12.541+02:00Data, Insights, and Community: My Reflections on Data Saturday Holland and dataMinds Connect<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0-6lUpAbGzk2XLmtiCiK8dLPioZ8HIX0KAEE8Cb8hM_IWKOTQqqU_n4FgHQEwaMsdbdY1saqjUxRUHSAZSKIkVie_gGQuyYJ9wxNh9so2r_VTfUB5glHv6pMt2OZ3cWpr1mgZEQxKHVFMtctXKCiz9VX5TYgiDEtc-zjOqgl_0ovs-xwIAURmSovCWWk/s4000/20231010_123843.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="3000" data-original-width="4000" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0-6lUpAbGzk2XLmtiCiK8dLPioZ8HIX0KAEE8Cb8hM_IWKOTQqqU_n4FgHQEwaMsdbdY1saqjUxRUHSAZSKIkVie_gGQuyYJ9wxNh9so2r_VTfUB5glHv6pMt2OZ3cWpr1mgZEQxKHVFMtctXKCiz9VX5TYgiDEtc-zjOqgl_0ovs-xwIAURmSovCWWk/w640-h480/20231010_123843.jpg" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">The Lamot conference center alongside the river Dijle in Mechelen, Belgium</td></tr></tbody></table><br /><div><br /></div>
The world of data and analytics is constantly evolving, with new tools, technologies, and best practices emerging almost daily. As a data enthusiast and professional, I'm always on the lookout for opportunities to expand my knowledge and stay up to date with the latest trends in the field. Recently, I had the pleasure of attending two fantastic events: Data Saturday Holland and dataMinds Connect, and you may already guessβit was amazing!<br /><br /><h2 style="text-align: left;">Data Saturday Holland - Where Passion Meets Expertise</h2><br />Data Saturday Holland, formerly known as SQL Saturday Holland, is a renowned event that brings together data professionals, enthusiasts, and experts to share their knowledge and experiences.<br /><br />One of the things that struck me the most at Data Saturday Holland was the passion of the speakers and participants. From Power BI to data engineering, there was a wide range of sessions to choose from. I attended sessions covering various topics like Direct Lake in Power BI and improving your Power BI report. These sessions provided me with valuable insights and practical tips that I could immediately apply to my work. It was enlightening to learn from experts who shared their real-world experiences and demonstrated the tools and techniques they use on a daily basis.<br />
<br />A highlight of the Saturday was being able to attend my favorite podcast, <a href="https://www.kneedeepintech.com/" target="_blank">Knee-Deep in Tech</a>, live in a movie theater!<br />
<div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWFLwhSuCeiYJJmgGCEr-PlFYWLRJ6_bx4iTGdbhT_b7Vjn4OX8WzWlqFPVpTtpQKOa75Mp-yDh0WNuoW8hhsPSzaq-1vliE30vlU2AQAx3eEqX5VaYyyYmuzfLREHObH9zebpMziNyoPzse_dRQ2IW03W67qFD0uCbuWveWkfSn9zIKsyZW-u6XfIqTU/s4000/20231007_132922.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="3000" data-original-width="4000" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWFLwhSuCeiYJJmgGCEr-PlFYWLRJ6_bx4iTGdbhT_b7Vjn4OX8WzWlqFPVpTtpQKOa75Mp-yDh0WNuoW8hhsPSzaq-1vliE30vlU2AQAx3eEqX5VaYyyYmuzfLREHObH9zebpMziNyoPzse_dRQ2IW03W67qFD0uCbuWveWkfSn9zIKsyZW-u6XfIqTU/w640-h480/20231007_132922.jpg" width="640" /></a></div><i>Knee-Deep in Tech by Heini Ilmarinen, Alexander Arvidsson and Simon Binder</i></div><br /><br />Another highlight of the event were the networking opportunities. I had the chance to meet old friends and new people, exchange ideas, and even discuss potential collaborations. It's incredible how the event fostered a sense of community and encouraged knowledge sharing. I left Data Saturday Holland inspired and motivated!<br /><br /><h2 style="text-align: left;">DataMinds Connect - A Deep Dive into Data and AI</h2><br />Just when I thought my week couldn't get any better, I had the privilege of attending dataMinds Connect. This event is an annual conference organized by the dataMinds community, focusing on Microsoft Data Platform technologies. The event spans (for now π) two days and covers a wide range of topics related to data and AI.<br /><br />One of the standout features of dataMinds Connect was the depth and breadth of the sessions. Experts from various domains within data and AI shared their knowledge. From advanced SQL Server features to leading AI applications, there was something for everyone. I especially enjoyed the in-depth sessions that allowed me to explore complex topics in detail, like Mathias Thierbach's Power BI Source Control precon.<div><br /><div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbQYhBV3D5ZkEGPW3QXGW-lBATOY2uczu5rcjgtaa9CwNOBSkYHNOS5co7grUIke07t_38qXEsdyRLsgughW26qb37CtEKNyDpfkpXQjt7PAXCsWvA-FE1tZJvDaDA4Xie8d97yo7Mzbi1oeR8RLDv3QasN5eiq2N5h5eOack5AdroDT63ALEdfpJHqXI/s4032/20231009_090028.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="3024" data-original-width="4032" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbQYhBV3D5ZkEGPW3QXGW-lBATOY2uczu5rcjgtaa9CwNOBSkYHNOS5co7grUIke07t_38qXEsdyRLsgughW26qb37CtEKNyDpfkpXQjt7PAXCsWvA-FE1tZJvDaDA4Xie8d97yo7Mzbi1oeR8RLDv3QasN5eiq2N5h5eOack5AdroDT63ALEdfpJHqXI/w640-h480/20231009_090028.jpg" width="640" /></a></div><br /><br />I also volunteered during the two days this year, assisting speakers and visitors in making the most of their own experience. During Mathias' workshop, I helped answer questions and on the second day, I addressed general visitor questions and took care of the speakers, so they didn't have to worry about the technical aspects, drinks, or other logistics.<br /><br />The community at dataMinds Connect was incredibly welcoming, and I had the opportunity to engage in conversations with participants and speakers. This sense of community and feeling of being welcome was a common theme throughout the event, and it's something that truly sets this conference apart. A beer and some chocolate certainly works wonders too! :-)<br /><br /><br /><h2 style="text-align: left;">The Value of Conferences</h2><br />Attending Data Saturday Holland and dataMinds Connect provided me with a comprehensive overview of the Power BI and Fabric landscape and the latest developments in this field. I left with new skills and insights and a better understanding of the latest trends and technologies. Moreover, the connections I made during these events were invaluable. Networking with professionals who share my passion and interests can lead to future collaborations, career opportunities, or simply the joy of being part of a vibrant and supportive community.<br /><br />In summary, my week at Data Saturday Holland and dataMinds Connect was an incredible experience! These events not only expanded my knowledge but also allowed me to connect (and continue to connect) with fellow data enthusiasts and experts! </div><div><br /></div><div>I have a few more things coming up in the following monhts:</div><div><ul style="text-align: left;"><li><a href="https://www.newstarsofdata.com/" target="_blank">New Stars of Data</a> with my mentee Ioannis Philippides</li><li><a href="https://datagrillen.com/data-left-unattended/" target="_blank">Data Left Unattended</a></li><li><a href="https://sqlusergroupaustria.wordpress.com/" target="_blank">Data Saturday Vienna</a></li><li>... A few more things are in the works, but nothing definitive yet...</li></ul><div>Do I see you there? π</div></div></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-10212647920584799062023-09-29T16:19:00.005+02:002023-10-04T11:16:19.593+02:00Pausing a Fabric Capacity - What Does It Actually Mean?<div>
<div>After an initial question by my friend and fellow MVP <a href="https://sqlkover.com/" target="_blank">Koen Verbeeck</a>, myself and a bunch of people started answering, amongst others was <a href="https://twitter.com/mohaali45" target="_blank">Mohammad Ali</a>, Group Program Manager for Power BI.</div><blockquote class="twitter-tweet"><p dir="ltr" lang="en">If a <a href="https://twitter.com/hashtag/MicrosoftFabric?src=hash&ref_src=twsrc%5Etfw">#MicrosoftFabric</a> capacity is not running, you cannot use the <a href="https://twitter.com/hashtag/PowerBI?src=hash&ref_src=twsrc%5Etfw">#PowerBI</a> reports? cc <a href="https://twitter.com/BenniDeJagere?ref_src=twsrc%5Etfw">@BenniDeJagere</a> <a href="https://twitter.com/cwebb_bi?ref_src=twsrc%5Etfw">@cwebb_bi</a></p>β Koen Verbeeck πΊπ¦ π (@Ko_Ver) <a href="https://twitter.com/Ko_Ver/status/1706904548856516707?ref_src=twsrc%5Etfw">September 27, 2023</a></blockquote> <script async="" charset="utf-8" src="https://platform.twitter.com/widgets.js"></script>
</div>
<div><div><br /></div><div>After a while it got me thinking:</div><div><ul style="text-align: left;"><li>What does it actually mean when I pause a Fabric capacity?</li><li>What will stop working?</li><li>What can I still do and won't stop working?</li></ul><div><br /></div></div></div><div><h3 style="text-align: left;">Important considerations</h3><div><i><blockquote style="background-color: #6fa8dc;">Microsoft Fabric is a <b>prerelease </b>online service that is currently in <b>public preview </b>and may be <b>substantially modified</b> before it's released. Preview online service products and features aren't complete but are made available on a preview basis so that customers can get early access and provide feedback.</blockquote></i></div><div>A note before you start and might be aware of, Microsoft Fabric is still in preview, so be aware of the available functionality, availability and supportability, which is described in detail <a href="https://learn.microsoft.com/en-us/fabric/get-started/preview?WT.mc_id=DP-MVP-5003835" target="_blank">here</a>.</div><div><br /></div><div><div><h2 style="text-align: left;">TL;DR</h2></div><div><div>After playing around and testing various scenario's, I was quite surprised on a few answers I got, so keep reading if you want to find out!</div><div>In case you are not interested in the setup, you can also skip right to <a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#tests">my tests</a> or the <a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#conclusions">conclusions</a>.</div></div></div><div><br /></div><div></div><h2 style="text-align: left;">Start setup</h2><div>The steps I took to start exploring the capacity capabilities are the following:<br /><ul style="text-align: left;"><li>I created a Fabric capacity in the Azure Portal for my tenant. You can even start an Azure (30 day) <a href="https://azure.microsoft.com/en-us/free" target="_blank">free trial</a> and use that to create a Fabric capacity. Erwin did a great job explaing how to <a href="https://erwindekreuk.com/2023/06/create-capacity-for-microsoft-fabric/" target="_blank">create a Fabric capacity</a>, so I won't go into details here.</li><li>Then I set up a basic Lakehouse from the <a href="https://learn.microsoft.com/en-us/fabric/data-engineering/tutorial-lakehouse-introduction?WT.mc_id=DP-MVP-5003835" target="_blank">Lakehouse tutorial</a> on Microsoft Learn. I followed the tutorial up untill step 3 (Build a lakehouse), where I end up with a dataflow Gen2, a lakehouse and a Power BI (Direct Lake) report on the default dataset.</li><li>I also created 2 workspaces:<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9BkSkTdEr7UbyRKwTdxFv6n7rcFU-2bdJIKJj9LqZGtBYi47HmCzWtVq9Sfdre5ioCJN8WxDaAGw-k4EzGGd7hLZnibJk4yIHMw6CVdHRnxqwP07tRiz3z_rKE9nTYezHWEHOy9UBsUgl4FZmDH0CpOjyOcgnUPGlG9_mmES3mr4K524nkAwCfkVcDEs/s251/Pause%20Fabric%20capacity%20-%20workspaces.png" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="103" data-original-width="251" height="103" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9BkSkTdEr7UbyRKwTdxFv6n7rcFU-2bdJIKJj9LqZGtBYi47HmCzWtVq9Sfdre5ioCJN8WxDaAGw-k4EzGGd7hLZnibJk4yIHMw6CVdHRnxqwP07tRiz3z_rKE9nTYezHWEHOy9UBsUgl4FZmDH0CpOjyOcgnUPGlG9_mmES3mr4K524nkAwCfkVcDEs/s1600/Pause%20Fabric%20capacity%20-%20workspaces.png" width="251" /></a></div></li></ul><div><span style="color: #0000ee;"><u><br /></u></span></div><div><span style="color: #0000ee;"><u><br /></u></span></div><div><span style="color: #0000ee;"><u><br /></u></span></div><div><span style="color: #0000ee;"><u><br /></u></span></div><div><span style="color: #0000ee;"><u><br /></u></span></div><div><span style="color: #0000ee;"><u><br /></u></span></div><div><span style="color: #0000ee;"><u><br /></u></span></div><ul style="text-align: left;"><ul><li>Test Fabric Capacity holds all my Fabric <strike>artifacts</strike> items and has the Fabric capacity (nickyscapacity, see below) assigned. This is the workspace I used for my tutorial. Let's call this the <b>Fabric workspace</b>.</li><li>Test Fabric semantic model has no capacity assigned, so it's a regular (pro) workspace. Let's call this <b>workspace</b>.</li></ul><li>After that, I've created a few datasets/reports (or <a href="https://www.linkedin.com/feed/update/urn:li:activity:7110927496526602241?updateEntityUrn=urn%3Ali%3Afs_feedUpdate%3A%28V2%2Curn%3Ali%3Aactivity%3A7110927496526602241%29" target="_blank">semantic models</a> if you will π) (with Direct Lake, DirectQuery and Import) on top of the SQL Endpoint of my lakehouse.</li></ul></div><div><br /></div><div>The basic report I created, it's not really important how it looks for now:</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaKfHWuha26-ZbaeNjcc8FGKtuSdv430MB-HB6kFk9IRlEAzB5jEPTLtaA0ZIq9Ffeicf5tWn7Gw0PDkR9e-7R3rsiVVG8cbrtFAsHhk0khBx0IBU3Icuqhyphenhyphenaz9FqwUkXlp6w0gnLReZ80ndJogb17kYl1YkBPWU9Wdi6-O3ZCZLos6tvWo80u-mnBYWQ/s929/Pause%20Fabric%20capacity%20-%20DL%20report.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="540" data-original-width="929" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaKfHWuha26-ZbaeNjcc8FGKtuSdv430MB-HB6kFk9IRlEAzB5jEPTLtaA0ZIq9Ffeicf5tWn7Gw0PDkR9e-7R3rsiVVG8cbrtFAsHhk0khBx0IBU3Icuqhyphenhyphenaz9FqwUkXlp6w0gnLReZ80ndJogb17kYl1YkBPWU9Wdi6-O3ZCZLos6tvWo80u-mnBYWQ/w400-h233/Pause%20Fabric%20capacity%20-%20DL%20report.png" width="400" /></a></div><br /><div><br /></div>
<h2 id="tests" style="text-align: left;">My tests</h2><div>The first thing is of course pausing my capacity, which is an easy push of a button in the Azure portal.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXhnb1-936Z11vrluU6mfJWx2_nZXVG_FCMXZj5IR_GTdS1PIL0_-4JpPDUDHyhXDMNursYjoNpGD3fnUO-HpJSixQHbDguLoIZ_Xy2tJ_TxlKxyLuELN6_fkxMhnYEbs5QIzSkJCdUBVL9v1pLhxJmIdpUDaipwKDraypdSyuobLlhPoLqWU6xkUkC08/s630/Pause%20Fabric%20capacity%20-%20pause%20capacity.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="220" data-original-width="630" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXhnb1-936Z11vrluU6mfJWx2_nZXVG_FCMXZj5IR_GTdS1PIL0_-4JpPDUDHyhXDMNursYjoNpGD3fnUO-HpJSixQHbDguLoIZ_Xy2tJ_TxlKxyLuELN6_fkxMhnYEbs5QIzSkJCdUBVL9v1pLhxJmIdpUDaipwKDraypdSyuobLlhPoLqWU6xkUkC08/s16000/Pause%20Fabric%20capacity%20-%20pause%20capacity.png" /></a></div><br /><div><br /></div><div>Next I want to see what happens when I access certain items or take certain actions in my workspaces.</div><div>Here's a list of things I tried to do:</div><div><ul style="text-align: left;"><li><span style="white-space: normal;"><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#dataflowgen2">Access dataflow Gen2</a></span></li><li><span style="white-space: normal;"><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#lakehouse">Access the Lakehouse</a></span></li><li><span style="white-space: normal;"><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#sqlendpoint">Access SQL Endpoint (of the Lakehouse)</a></span></li><li><span style="white-space: normal;"><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#directlake">Access Direct Lake model from Fabric workspace</a></span></li><li><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#directlakeregularws">Access Direct Lake model from workspace</a></li><li><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#dqfabric"><span>Access DQ model from </span>Fabric workspace</a></li><li><span style="white-space: normal;"><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#dqregular">Access DQ dataset from workspace</a></span></li><li><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#importfabric"><span style="white-space: normal;">Access Import dataset from </span>Fabric workspace</a></li><li><span style="white-space: normal;"><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#importregular">Access Import dataset from workspace</a></span></li><li><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#downloadimport">Download import dataset and re-publish to workspace</a></li><li><span style="white-space: normal;"><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#refreshimport">Refresh Import dataset from workspace</a></span></li><li><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#moveworkspace"><span style="white-space: normal;">Move the </span>Fabric workspace to Pro</a></li><li><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#metricsapp">Access the Fabric Capacity Metrics app</a></li><li><a href="https://www.nickyvv.com/2023/09/pausing-fabric-capacity-what-does-it-actually-mean.html#editcapacitysettings">Edit capacity settings</a></li></ul></div></div><div><br /></div>
<div>
<h3 id="dataflowgen2" style="text-align: left;">Access my dataflow Gen2</h3></div>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieIQK28LigNLFGiM1WFikw05i-OWTTFlHHKO7-s3XKU4iTc2u9KWQhdmsPyKecQ6U9QOkDQxdHUseB8Zs4p9gsxFZZmt-lF3bB15_uy0aIZkeuf-VdoTmIGC59pT0N3nxj18lrqo7r7kM88SkfOQ6rnMWZ8S8GuQCey4oeYpzHemTOFYT2PcgLJIin3S0/s622/Pause%20Fabric%20capacity%20-%20errors%20dataflow%20Gen2.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="248" data-original-width="622" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieIQK28LigNLFGiM1WFikw05i-OWTTFlHHKO7-s3XKU4iTc2u9KWQhdmsPyKecQ6U9QOkDQxdHUseB8Zs4p9gsxFZZmt-lF3bB15_uy0aIZkeuf-VdoTmIGC59pT0N3nxj18lrqo7r7kM88SkfOQ6rnMWZ8S8GuQCey4oeYpzHemTOFYT2PcgLJIin3S0/s16000/Pause%20Fabric%20capacity%20-%20errors%20dataflow%20Gen2.png" /></a></div><div class="separator" style="clear: both; text-align: left;">Not a very helpful error message π</div><div class="separator" style="clear: both; text-align: left;"><br /></div>
<h3 id="lakehouse" style="clear: both; text-align: left;">Access the Lakehouse</h3><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1Y0Fr-XD1HpZk5r6h86Yr0y1zg37iGruuK85ky59pLaG0sfE4ZbY3bPbSOSHtFdG5iucF0uOCQcPfNm5co-grWAri_38k_7eMDQQeGsC412iak46l6HZ5unU_9L-rGJ8lOIdPvpiQCAyDfZycdkQ_ULO71f_UmDImT3OL8f2JuKhPo2B_lHEMu1Eq7H8/s833/Pause%20Fabric%20capacity%20-%20errors%20lakehouse.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="289" data-original-width="833" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1Y0Fr-XD1HpZk5r6h86Yr0y1zg37iGruuK85ky59pLaG0sfE4ZbY3bPbSOSHtFdG5iucF0uOCQcPfNm5co-grWAri_38k_7eMDQQeGsC412iak46l6HZ5unU_9L-rGJ8lOIdPvpiQCAyDfZycdkQ_ULO71f_UmDImT3OL8f2JuKhPo2B_lHEMu1Eq7H8/w640-h222/Pause%20Fabric%20capacity%20-%20errors%20lakehouse.png" width="640" /></a></div><br /><div>This is very helpful, it actually mentions my capacity (ID) is not running.</div><div><br /></div><div>
<h3 id="sqlendpoint" style="text-align: left;">Access SQL Endpoint (of the Lakehouse)</h3><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLS09rFECZqVxL227-k3hATDe7XBSaKI9AN14glAbX1W4bX4xm25hEhB28Obo1XRT9Fxvh3ayWJmPUD4OAsTIxARbGkorBPxTyVR_LaMs9SQ0kEMgGsGVGQXbn9TPquKWRyc0yXSM_ITyXljwpgk3obVDm092JXzbZlelxi10S1ky5f2uzmgTTklW-q_M/s592/Pause%20Fabric%20capacity%20-%20errors%20sql%20endpoint.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="449" data-original-width="592" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLS09rFECZqVxL227-k3hATDe7XBSaKI9AN14glAbX1W4bX4xm25hEhB28Obo1XRT9Fxvh3ayWJmPUD4OAsTIxARbGkorBPxTyVR_LaMs9SQ0kEMgGsGVGQXbn9TPquKWRyc0yXSM_ITyXljwpgk3obVDm092JXzbZlelxi10S1ky5f2uzmgTTklW-q_M/s16000/Pause%20Fabric%20capacity%20-%20errors%20sql%20endpoint.png" /></a></div><br /><div>Not very helpful, it doesn't say anything about my capacity.</div><div><br /></div>
<h3 id="directlake" style="text-align: left;">Access Direct Lake model from Fabric workspace</h3><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKdQaTx_5_pPXiKfPgtWsb12fN_9BmhDVE7jVE6oJGA2c1QMfQv2Qjb6H1PJZwSPq0mHeRgAM8JeeUEn4Aw9Kc51kI6XzpZoZR9G22EZ-M5MLBvXJVpqsn9cRyqvRS3wTEg0FnCRFl2o3E9y2dcgCGcEIHogBiFVO1jmXH3BSSBuEvSvRpq7rxKbGmFPg/s770/Pause%20Fabric%20capacity%20-%20errors%20import.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="370" data-original-width="770" height="309" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKdQaTx_5_pPXiKfPgtWsb12fN_9BmhDVE7jVE6oJGA2c1QMfQv2Qjb6H1PJZwSPq0mHeRgAM8JeeUEn4Aw9Kc51kI6XzpZoZR9G22EZ-M5MLBvXJVpqsn9cRyqvRS3wTEg0FnCRFl2o3E9y2dcgCGcEIHogBiFVO1jmXH3BSSBuEvSvRpq7rxKbGmFPg/w640-h309/Pause%20Fabric%20capacity%20-%20errors%20import.png" width="640" /></a></div><br /><span>This one IS helpful, it actually mentions my capacity is not active, although it doesn't give the ID like with accessing the lakehouse.</span></div><div><br /></div>
<h3 id="directlakeregularws" style="text-align: left;">Access Direct Lake model from workspace</h3><div>I created a copy of the report into the regular workspace and opened the report.</div><div>Strange enough, I suspect because of some caching that was already done before pausing the capacity, some parts of the report still work. I assume that cache is then copied over (with the report) to the regular workspace.</div><div>Some interactions worked, but when I clicked a filter without any cache, I got the same error message as below with the DQ model.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirGP8o4GQRoqsXd-oKbNrYLv_eX1JChsetBJC5XZgUpmqheJ9a_otQB8wO6O9cPAcpRC4sbvG8DEnDO7cQjIsJZfISGNW4tY8aiuuqiBIel8n82RPYZvgGio9YqXeDMWHJ-mQdz30D11HJm9C1rJZrSxYza4fzeQOwgzw0NyrMQq1O-xkYQ5TfAbhJCRE/s355/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20fabric%20workspace%201.png" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="118" data-original-width="355" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirGP8o4GQRoqsXd-oKbNrYLv_eX1JChsetBJC5XZgUpmqheJ9a_otQB8wO6O9cPAcpRC4sbvG8DEnDO7cQjIsJZfISGNW4tY8aiuuqiBIel8n82RPYZvgGio9YqXeDMWHJ-mQdz30D11HJm9C1rJZrSxYza4fzeQOwgzw0NyrMQq1O-xkYQ5TfAbhJCRE/s320/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20fabric%20workspace%201.png" width="320" /></a></div><div></div><div><br /></div><div><br /></div>
<h3 id="dqfabric" style="text-align: left;">Access DQ model from Fabric workspace</h3><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirGP8o4GQRoqsXd-oKbNrYLv_eX1JChsetBJC5XZgUpmqheJ9a_otQB8wO6O9cPAcpRC4sbvG8DEnDO7cQjIsJZfISGNW4tY8aiuuqiBIel8n82RPYZvgGio9YqXeDMWHJ-mQdz30D11HJm9C1rJZrSxYza4fzeQOwgzw0NyrMQq1O-xkYQ5TfAbhJCRE/s355/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20fabric%20workspace%201.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="118" data-original-width="355" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirGP8o4GQRoqsXd-oKbNrYLv_eX1JChsetBJC5XZgUpmqheJ9a_otQB8wO6O9cPAcpRC4sbvG8DEnDO7cQjIsJZfISGNW4tY8aiuuqiBIel8n82RPYZvgGio9YqXeDMWHJ-mQdz30D11HJm9C1rJZrSxYza4fzeQOwgzw0NyrMQq1O-xkYQ5TfAbhJCRE/s320/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20fabric%20workspace%201.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: left;">The visual itself gives me the above error, see the detailed error message below: not very helpful.</div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtlruq3LFXy8ryDlRYDzaxFJY163Ev-5KsC0cyx9j-d_fkQzVNMNgm7WmZ2kOoF152cDPUCsnh-3cVvijSsXK7JcVbLDKo1ifoNfusE0PgoREAWwNcfARQHLajIhk6xqcDaEUdyEnvbkOO7_mNxwkfKePEioInBzzjY8teMrZLGSWLXakfF6WYZ1kkOpQ/s591/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20fabric%20workspace%202.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="438" data-original-width="591" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtlruq3LFXy8ryDlRYDzaxFJY163Ev-5KsC0cyx9j-d_fkQzVNMNgm7WmZ2kOoF152cDPUCsnh-3cVvijSsXK7JcVbLDKo1ifoNfusE0PgoREAWwNcfARQHLajIhk6xqcDaEUdyEnvbkOO7_mNxwkfKePEioInBzzjY8teMrZLGSWLXakfF6WYZ1kkOpQ/s16000/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20fabric%20workspace%202.png" /></a></div><div><br /></div><div><br /></div>
<h3 id="dqregular" style="text-align: left;">Access DQ dataset from workspace</h3><div class="separator" style="clear: both; text-align: left;">This one is a bit inconsistent because I got different errors on this action.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiT2JFvIZZV7D3Gdic3HwEhqKaYqJnM0tH1V2HGHvuSoOPBufh3va5tTt5ylkdQHYJGYDPq3R4nFtgSWaqW4b_uHHIli7MXsZ1H48IICkJaiXIy-Hhr6BCVSX4RzwzfNJG_U0rt2GbT9OWMHmbj40PacSSnaoaSqZIzbQSTnuDB5RFJSFBEAAvOC9NxXhI/s288/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20regular%20workspace%201.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="110" data-original-width="288" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiT2JFvIZZV7D3Gdic3HwEhqKaYqJnM0tH1V2HGHvuSoOPBufh3va5tTt5ylkdQHYJGYDPq3R4nFtgSWaqW4b_uHHIli7MXsZ1H48IICkJaiXIy-Hhr6BCVSX4RzwzfNJG_U0rt2GbT9OWMHmbj40PacSSnaoaSqZIzbQSTnuDB5RFJSFBEAAvOC9NxXhI/s1600/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20regular%20workspace%201.png" width="288" /></a></div><div class="separator" style="clear: both; text-align: left;">I'm accessing the DQ report in the other, regular workspace. I'm getting a slightly different error in the visual, but the detailed error message is totally different then from the Fabric workspace. It's more a SQL server error message.</div><div class="separator" style="clear: both; text-align: left;">It at least tells me there's something wrong with the SQL endpoint.</div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtKvxkXv1U2gPHjPl-zirEsUERKUfo1NqwPK6NYCk2EkVYn5hLyAypYDoKCHLqapVfmSzUTWslu68kszYJhAeKY6WoT3Jp44P-OapXXJ81JgqfzVdwatIoeEe6g2bY96PvoB1aA-L-H6yB2ioGUPSmapwAaB2Thmkr9uau9jgZ4sB7XtUVp3ZnYvLzDh4/s1036/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20regular%20workspace%202.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="475" data-original-width="1036" height="293" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtKvxkXv1U2gPHjPl-zirEsUERKUfo1NqwPK6NYCk2EkVYn5hLyAypYDoKCHLqapVfmSzUTWslu68kszYJhAeKY6WoT3Jp44P-OapXXJ81JgqfzVdwatIoeEe6g2bY96PvoB1aA-L-H6yB2ioGUPSmapwAaB2Thmkr9uau9jgZ4sB7XtUVp3ZnYvLzDh4/w640-h293/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20regular%20workspace%202.png" width="640" /></a></div><div>But when I tried this same action later, I got the following error, which is very much helpful because it mentions the CapacityNotActive.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLKn6kUY4Y6-5OQGBhZPhVEITbjFdMwEcO3e-YdPuAdkdm01FPqmRHuQR49_DUCfDPQWMh3HrmGqFmOIcrXgxu0YktPzy8AdQO-hxaiMACn-bOF2jBK2iWNkrC4unUNcs04yuVqact6L0_Np25N9CwDgXxZXiIiQSUQIQQJYtozv8tFC79iPbvrT3DQUA/s772/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20fabric%20workspace%203.png" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="331" data-original-width="772" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLKn6kUY4Y6-5OQGBhZPhVEITbjFdMwEcO3e-YdPuAdkdm01FPqmRHuQR49_DUCfDPQWMh3HrmGqFmOIcrXgxu0YktPzy8AdQO-hxaiMACn-bOF2jBK2iWNkrC4unUNcs04yuVqact6L0_Np25N9CwDgXxZXiIiQSUQIQQJYtozv8tFC79iPbvrT3DQUA/w400-h171/Pause%20Fabric%20capacity%20-%20errors%20dq%20model%20fabric%20workspace%203.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div style="text-align: justify;"></div><div style="text-align: justify;"><br /></div>
<h3 id="importfabric" style="text-align: left;">Access Import dataset from Fabric workspace</h3><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKdQaTx_5_pPXiKfPgtWsb12fN_9BmhDVE7jVE6oJGA2c1QMfQv2Qjb6H1PJZwSPq0mHeRgAM8JeeUEn4Aw9Kc51kI6XzpZoZR9G22EZ-M5MLBvXJVpqsn9cRyqvRS3wTEg0FnCRFl2o3E9y2dcgCGcEIHogBiFVO1jmXH3BSSBuEvSvRpq7rxKbGmFPg/s770/Pause%20Fabric%20capacity%20-%20errors%20import.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="370" data-original-width="770" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKdQaTx_5_pPXiKfPgtWsb12fN_9BmhDVE7jVE6oJGA2c1QMfQv2Qjb6H1PJZwSPq0mHeRgAM8JeeUEn4Aw9Kc51kI6XzpZoZR9G22EZ-M5MLBvXJVpqsn9cRyqvRS3wTEg0FnCRFl2o3E9y2dcgCGcEIHogBiFVO1jmXH3BSSBuEvSvRpq7rxKbGmFPg/w640-h308/Pause%20Fabric%20capacity%20-%20errors%20import.png" width="640" /></a></div><div><br /></div>The error itself is helpful, because it mentions the capacity.</div><div>However, this one got me a bit surprised, because I'm accessing an imported model, so the data is no longer in OneLake. But as we'll see a bit further, nothing from a Fabric workspace can be accessed anymore when the capacity is paused.<span><br /></span></div><div><br /></div>
<h3 id="importregular" style="text-align: left;">Access Import dataset from workspace β </h3><div><span>The difference with the action above is that this is the <b>regular </b>workspace. This one succeeds, because the data is in the imported model in the regular workspace, which is active and running. It has nothing to do with the Fabric capacity.</span></div><div><br /></div>
<h3 id="downloadimport" style="text-align: left;">Download import dataset and re-publish to workspace β </h3><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf9iqsBBk1MuA7_tViz9X984CRIxuxktiR-N5kIemJ6pxZvQYPLXSj_zqqD24BwRKWcrtwY353il5vXLWZeUrSbdHdUofc0gMf-kQEARTFeIGy2P1_uxTJBf7irTqorau-9oNVtvqI3YGCycKzvyR0HESLcSreLhJtvjOzxKlWWm3YYdBwSAq7LpI4aBc/s488/Pause%20Fabric%20capacity%20-%20errors%20import%20download%201.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="177" data-original-width="488" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf9iqsBBk1MuA7_tViz9X984CRIxuxktiR-N5kIemJ6pxZvQYPLXSj_zqqD24BwRKWcrtwY353il5vXLWZeUrSbdHdUofc0gMf-kQEARTFeIGy2P1_uxTJBf7irTqorau-9oNVtvqI3YGCycKzvyR0HESLcSreLhJtvjOzxKlWWm3YYdBwSAq7LpI4aBc/s16000/Pause%20Fabric%20capacity%20-%20errors%20import%20download%201.png" /></a></div><div class="separator" style="clear: both; text-align: left;">Surprisingly (to me), I <b>can</b> still download the dataset from the Fabric workspace. So it seems the dataset itself is not stored in OneLake, since that is paused. Still a bit strange why then the import model doesn't start from this Fabric workspace.</div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgX84_lgN6CBD807IWzE1WDagz8q5r38Xkk0ZYm52EHT8uYAmM3IziOlVKpDEhSMXCIlnejFd_pb1hmG9G7Lcs7aKWLBka_XOTaBxqEk8OCex9sQhyphenhyphenPfeqyiQVffFbZSTkduTw1cl_wZjsHEw10MUvJ5WdPNysH9ffS1RrNbzh7S-4WHarIKPTiKVw4P-s/s410/Pause%20Fabric%20capacity%20-%20errors%20import%20download%202.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="77" data-original-width="410" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgX84_lgN6CBD807IWzE1WDagz8q5r38Xkk0ZYm52EHT8uYAmM3IziOlVKpDEhSMXCIlnejFd_pb1hmG9G7Lcs7aKWLBka_XOTaBxqEk8OCex9sQhyphenhyphenPfeqyiQVffFbZSTkduTw1cl_wZjsHEw10MUvJ5WdPNysH9ffS1RrNbzh7S-4WHarIKPTiKVw4P-s/s16000/Pause%20Fabric%20capacity%20-%20errors%20import%20download%202.png" /></a></div><div><br /></div>Republishing to the (regular) workspace succeeds and gives me the report below:<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhD2tWp8aq1-r0aw4MF1sa0BVFPi2XpeRPkFga4SpJM8_EtxM4c0OlKpsmfM8xLELgCumvCzPF3Ef-hd6k1crPrfIo18nYD4QnCltrRvBQnsusGXz-z9JMGX5G50H9NvhyphenhyphenKFsFZKKvjdlVbVrFcKJBqHtNMIVf8GUa4YWJjGNNcnTSYq9N_GoEF6mn3M_8/s1161/Pause%20Fabric%20capacity%20-%20import%20publish%20to%20other%20workspace.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="401" data-original-width="1161" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhD2tWp8aq1-r0aw4MF1sa0BVFPi2XpeRPkFga4SpJM8_EtxM4c0OlKpsmfM8xLELgCumvCzPF3Ef-hd6k1crPrfIo18nYD4QnCltrRvBQnsusGXz-z9JMGX5G50H9NvhyphenhyphenKFsFZKKvjdlVbVrFcKJBqHtNMIVf8GUa4YWJjGNNcnTSYq9N_GoEF6mn3M_8/w640-h222/Pause%20Fabric%20capacity%20-%20import%20publish%20to%20other%20workspace.png" width="640" /></a></div><br /><div><br /></div>
<h3 id="refreshimport" style="text-align: left;">Refresh Import dataset from workspace</h3><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXNuIqs0L9_fa-i9Dhpva3rthXKxDQw198V4X4IkzDGCdsa-ovvozvtyQABqm3LXfxwxGKOAdMwNdggdMDc_qCmlmWk1O27J0YEUiY2r3VQithi8FBlk78Br2v8ZZqqBicr2bLxhN6ayxMnKsp4mrAAMJugtGppCDn66CljcMpfNL4RQw5qpgKj5qW3uA/s1037/Pause%20Fabric%20capacity%20-%20errors%20import%20refresh.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="475" data-original-width="1037" height="293" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXNuIqs0L9_fa-i9Dhpva3rthXKxDQw198V4X4IkzDGCdsa-ovvozvtyQABqm3LXfxwxGKOAdMwNdggdMDc_qCmlmWk1O27J0YEUiY2r3VQithi8FBlk78Br2v8ZZqqBicr2bLxhN6ayxMnKsp4mrAAMJugtGppCDn66CljcMpfNL4RQw5qpgKj5qW3uA/w640-h293/Pause%20Fabric%20capacity%20-%20errors%20import%20refresh.png" width="640" /></a></div>This action pertains to refreshing the Import dataset from the regular workspace, the dataset which I could open. However, the refresh action itself fails, because it needs the lakehouse data to refresh, which is not available.<br /><span><br /></span></div>
<h3 id="moveworkspace" style="text-align: left;">Move the Fabric workspace to Pro</h3></div><div class="separator" style="clear: both; text-align: left;">When trying to move the Fabric workspace to a regular (Pro) workspace, you might be thrown off by this message in the workspace Premium settings in the bottom:</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsMpBfTS7F1RJ0t2AK1-ma3sj1YjQIBBiME9m24p7IB_uCwwXfG_Hnb7BOZYEmYu1ZrzWfXxH_kx6ZXWgdE9YVyiUcwU8ZFknbXTgtk-_STIaEYwih313GDPXD8Oly1EZuG0zF-2wwF95LYNNb4kqUuokjK9NZF-7s1qeLnwHapjIMfG_Aywwf1baQCBg/s563/Pause%20Fabric%20capacity%20-%20errors%20capacity%20workspace%20setting.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="325" data-original-width="563" height="370" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsMpBfTS7F1RJ0t2AK1-ma3sj1YjQIBBiME9m24p7IB_uCwwXfG_Hnb7BOZYEmYu1ZrzWfXxH_kx6ZXWgdE9YVyiUcwU8ZFknbXTgtk-_STIaEYwih313GDPXD8Oly1EZuG0zF-2wwF95LYNNb4kqUuokjK9NZF-7s1qeLnwHapjIMfG_Aywwf1baQCBg/w640-h370/Pause%20Fabric%20capacity%20-%20errors%20capacity%20workspace%20setting.png" width="640" /></a></div><div><br /></div>However, moving a Fabric workspace to Pro is only possible when there are no Fabric items inside:<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7gMoLBySjA5VKlYhNXKSQx7FPFsStx4Zt8GgkftW-q7wecgIn60IFrJfQarAOPt0qRV6Ki2TZUIn0Yp74XyTU8L-ZjNcyCAi87whx7nfRpSzQ-gGqITEFbOq4_uhyphenhypheni51OUSw8cAwY07ibSSg9q2vPFoqIfKfPY6wLYSAw7HM67UwURkhA5JPaHgor_9s/s593/Pause%20Fabric%20capacity%20-%20errors%20capacity%20move%20workspace.png" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="90" data-original-width="593" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7gMoLBySjA5VKlYhNXKSQx7FPFsStx4Zt8GgkftW-q7wecgIn60IFrJfQarAOPt0qRV6Ki2TZUIn0Yp74XyTU8L-ZjNcyCAi87whx7nfRpSzQ-gGqITEFbOq4_uhyphenhypheni51OUSw8cAwY07ibSSg9q2vPFoqIfKfPY6wLYSAw7HM67UwURkhA5JPaHgor_9s/s16000/Pause%20Fabric%20capacity%20-%20errors%20capacity%20move%20workspace.png" /></a></div><div style="text-align: left;"></div><div style="text-align: left;"><br /></div><div style="text-align: left;">This is also mentioned as one of the <a href="https://learn.microsoft.com/fabric/admin/portal-workspaces?WT.mc_id=DP-MVP-5003835#moving-data-around" target="_blank">current restrictions</a>.</div><div style="text-align: left;">I would urge you to carefully read those restrictions, the known issue(s) and final way of working when the known issue is resolved, especially if you plan to move items between regions after a workspace has been created.</div><div style="text-align: left;"><br /></div>
<h3 id="metricsapp" style="text-align: left;">Access the Fabric Capacity Metrics App β </h3><div>The Fabric Capacity Metrics app just keeps functioning. It doesnβt need the capacity itself to operate on, it uses the analytics/telemetry from the capacity that is logged and reports on that.<br /></div><div><br /></div>
<h3 id="editcapacitysettings" style="text-align: left;">Editing capacity settings</h3><div>The capacity settings in the Fabric Admin portal are <i>italic</i> and cannot be edited, unless you resume the capacity.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9LuIdBzxo9MG8yjBoUiFPDEwFbOtgR4ZOywoEY-JccQJZlh_N1zSaGGhbOaKbyBM2_RSgg9EljYuMvWSvWaNhFFgXBScGDHJM2DpyZ1E_UTjr-snBqDJPNl8NO8O6SzQUCTLKgkWO-0c5w71Fh1bPMBC_vb5xeyfFTNz0dnYsLzBGlSAslzuzvJgwvto/s634/Pause%20Fabric%20capacity%20-%20errors%20capacity%20edit%20settings.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="206" data-original-width="634" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9LuIdBzxo9MG8yjBoUiFPDEwFbOtgR4ZOywoEY-JccQJZlh_N1zSaGGhbOaKbyBM2_RSgg9EljYuMvWSvWaNhFFgXBScGDHJM2DpyZ1E_UTjr-snBqDJPNl8NO8O6SzQUCTLKgkWO-0c5w71Fh1bPMBC_vb5xeyfFTNz0dnYsLzBGlSAslzuzvJgwvto/s16000/Pause%20Fabric%20capacity%20-%20errors%20capacity%20edit%20settings.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div><br /></div>
<h1 id="conclusions" style="text-align: left;">Conclusion</h1><div>So to conclude: <b>all items in a Fabric workspace</b> become unavailable (for interactive opening) when a capacity is paused. Also Power BI-only items.</div><div>You <i>can </i>still download an import dataset from the workspace. You can also export the .json file of a dataflow (gen 1 and gen 2). But that's about it you can do on a workspace with a paused Fabric capacity.</div><div><br /></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDZQI3IZFBQ4ezUOtUO8_vCJrRje6crBRVgVPlAghMGa3_doxndzKlf8k51zRKnXeiqHxBdQfmruTrb4JutN0TStSkHpuL3pddaWuDQoZm3594p9wp-514To_H3RD1steCyKnp-tKD66MyDPXuWLULK5QP1kgV5CGjLCtIpHS7Hil_Pr90WutvvNI2KII/s683/Pause%20Fabric%20capacity%20-%20conclusion%20table%202.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="364" data-original-width="683" height="313" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDZQI3IZFBQ4ezUOtUO8_vCJrRje6crBRVgVPlAghMGa3_doxndzKlf8k51zRKnXeiqHxBdQfmruTrb4JutN0TStSkHpuL3pddaWuDQoZm3594p9wp-514To_H3RD1steCyKnp-tKD66MyDPXuWLULK5QP1kgV5CGjLCtIpHS7Hil_Pr90WutvvNI2KII/w586-h313/Pause%20Fabric%20capacity%20-%20conclusion%20table%202.png" width="586" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><span style="text-align: left;">1: </span><span style="font-size: x-small; text-align: left;"><i>Depending on the way you created the report, it might still have some cache, so it might work partially<br /></i></span></td></tr></tbody></table><br /><div><i>Thanks to <a href="https://datameerkat.com/" target="_blank">Ε tΔpΓ‘n ReΕ‘l</a> for pointing out the Usage Metrics report.</i></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div>So for now, it's best to separate the two, Fabric and non-Fabric items, in separate workspaces so you can always access the Power BI only items when the capacity is paused. In case you are not running your own capacity, but a free trial capacity, you don't have to take this into account for now.</div><div><br /></div><br />I hope this overview was usefull to you, I can at least use it as a reference and lookup post :-)<div>I am sure a couple of things will change in the near future, as Fabric updates keep coming out regularly.</div><div><br />If you are missing something from this overview let me know in the comments and I can see if I can add it here.</div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-25065953282653444622023-09-20T13:51:00.001+02:002023-09-20T14:21:48.685+02:00SQLBits 2024 Has Landed!<div style="text-align: left;">I've written about SQLBits before <a href="https://www.nickyvv.com/2022/03/conferences-and-speaking.html" target="">here</a> and <a href="https://www.nickyvv.com/2022/12/closing-out-on-2022.html">here</a>, but in case you still don't know what SQLBits is, it's the greatest Data conference in Europe, spanning a whopping 5 days, including the free community event on Saturday.</div><div style="text-align: left;">From the <a href="https://sqlbits.com/" target="_blank">SQLBits</a> website:</div><div style="text-align: left;"><blockquote>SQLBits is the industryβs leading Data Platform conference with over 300 sessions across 5 days covering data technologies including SQL Server, Azure, Big Data, Power BI, Machine Learning, and more.</blockquote><p>And if you need a reason (for your boss) to attend SQLBits: there are <a href="https://sqlbits.com/attend/why-attend/" target="_blank">10 reasons</a> listed on their website!</p><p>Next to all the great content, there's also lot's of extra's happening at SQLBits, like a board game night, a pub quiz, a SQLBits run and last but not least the famous Friday night party!</p><p><br /></p><h2 style="text-align: left;">Previous Editions</h2><p>I've also had the pleasure of presenting at 2 SQLBits events. In 2022 it was virtual, but last year I was excited to be attending and speaking at my first in-person SQLBits! I delivered 2 sessions, one (20-minute) lightning talk and a general session on Write-back with Power Apps in Power BI (the recording can be found <a href="https://sqlbits.com/sessions/event2023/Write-back_with_Power_Apps_in_Power_BI" target="_blank">here</a>).</p><p><br /></p><h2 style="text-align: left;">2024</h2><p>Now on to the 2024 event, last week there was a <a href="https://youtu.be/XrizElaWAaU?t=114" target="_blank">live stream</a> with Marco Russo, Alberto Ferrari (both from <a href="https://www.sqlbi.com/" target="_blank">SQLBI</a>) and Simon Sabin (founder of SQLBits) announcing the dates and location for this years event. This year SQLBits will be from March 19th - 23rd, in Farnborough.Hampshire, UK.</p><p>The theme for this year will be Aviation, because <a href="https://www.farnborough.com/" target="_blank">Farnborough</a> is <i>the birthplace of aviation and the home of pioneering spirit</i>.</p><p>The pricing and Call for Speakers for the event will be open very soon, so be sure to keep an eye on their website!</p><p>See you there? π</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr__G1k9uK-hGrXfJ513XZq6J-dLV3chwgz_7DiCiTNo-4FlLvFGZkPyLYghXzq50qZAoyoa9teN3VLWdzXUHcEFOmbdaYgt-F3C_Xi4y3SfyChs9eiSZ25tx1-NLNx4P9gmdMvz14uI3YgcxraEkNr6Ay2-Ul7Fxe-N_h-RSEoSwDOpzV_QixGA6-8Gw/s1702/SQLBits%202024%20graphic.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="630" data-original-width="1702" height="237" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr__G1k9uK-hGrXfJ513XZq6J-dLV3chwgz_7DiCiTNo-4FlLvFGZkPyLYghXzq50qZAoyoa9teN3VLWdzXUHcEFOmbdaYgt-F3C_Xi4y3SfyChs9eiSZ25tx1-NLNx4P9gmdMvz14uI3YgcxraEkNr6Ay2-Ul7Fxe-N_h-RSEoSwDOpzV_QixGA6-8Gw/w640-h237/SQLBits%202024%20graphic.png" width="640" /></a></div><br /><p><br /></p></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com1tag:blogger.com,1999:blog-7149479726422748695.post-53243921039710354512023-06-08T10:58:00.000+02:002023-06-08T10:58:12.298+02:00Power BI Desktop - Unable To Connect<p> Just a quick post on an issue I saw a few people run into lately.</p><h2 style="text-align: left;">Context</h2><div>I opened a report with a Live connection to a dataset and I was presented with the error below:</div><div><br /></div><div></div><blockquote><div>We encountered an error while trying to connect.</div>Details: "Looks like we're unable to access the dataset. Please contact the owner of the dataset."<br /><div class="separator" style="clear: both; text-align: center;"></div></blockquote><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6bwuqpM-rQ8a6_-7S2Io8B2BlR5zOXPXpkNNoCRAB4QOMw2HnKXsFAa53Dp9QkEvyfcEF_zrRWYv7BrwpQhbpuNZJqQMDXNkIA9BaZ-79vkX5-m4kvTpYzPw2ymjV1whaUZPlKXwXcAydz8nkgWvt8ENr7BmXmdG1GBEPjgPCxqlRe31mew-CPs4k/s2169/PBID%20Unable%20to%20connect.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1309" data-original-width="2169" height="386" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6bwuqpM-rQ8a6_-7S2Io8B2BlR5zOXPXpkNNoCRAB4QOMw2HnKXsFAa53Dp9QkEvyfcEF_zrRWYv7BrwpQhbpuNZJqQMDXNkIA9BaZ-79vkX5-m4kvTpYzPw2ymjV1whaUZPlKXwXcAydz8nkgWvt8ENr7BmXmdG1GBEPjgPCxqlRe31mew-CPs4k/w640-h386/PBID%20Unable%20to%20connect.png" width="640" /></a></div><br /><p>Clicking <b>Edit</b> gets you the following dialogue, which might already give you a clue what's happening,<br /></p><div class="separator" style="clear: both; text-align: center;"><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjrckDkKit9VsusYZEuKzP9WZk9np8SlWEvMM-LUq5jsB9DNBRmmhaSCLNmI41oMOTsDbNlH7iZUhNDVnE-D1lVK_aPOEDFN5XTKWzbXDLR6n0RtMS1aiDyxy8OSwx4NcLF2kWurtjRddPSeCl-Z9oloBun80AqyUSH8IzuSL3-SYe_e2oerQFGEQ7/s1133/PBID%20Unable%20to%20connect%20-%20Edit.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="636" data-original-width="1133" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjrckDkKit9VsusYZEuKzP9WZk9np8SlWEvMM-LUq5jsB9DNBRmmhaSCLNmI41oMOTsDbNlH7iZUhNDVnE-D1lVK_aPOEDFN5XTKWzbXDLR6n0RtMS1aiDyxy8OSwx4NcLF2kWurtjRddPSeCl-Z9oloBun80AqyUSH8IzuSL3-SYe_e2oerQFGEQ7/w640-h360/PBID%20Unable%20to%20connect%20-%20Edit.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><h2 style="clear: both; text-align: left;">Solution</h2><div class="separator" style="clear: both; text-align: left;">The answer here is actually really simple, if you know it! π </div><div class="separator" style="clear: both; text-align: left;">You have to login to Power BI Desktop with the right account. I was currently logged in with my Powerdobs account, while this was a customer report.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">So clicking <b>Edit</b> gave me the datasets in the Powerdobs tenant to connect to, which quickly led me to the conclusion I was logged in with the wrong account.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">So to solve this, in the top right corner, click on your name/picture and click <b>Sign in with a different account</b>.</div><div class="separator" style="clear: both; text-align: left;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLWx5NtTHqK6LKmZUMAVXDy7IXqmpcewthAFh-ePssMfwzFiY40AHdx1CMSQVDouEAOXEyK4lRS0VTxy1taRSLssdEdHFxkm6cex8OKnVv9D7Y10i2n2MdHFyWTdYrdi9xFB1Eet19A-TJESBxLoh6XUspgLO8FA8SZwZDFXtTFd3h9l5hWqVhkAvb/s1670/PBID%20Unable%20to%20connect%20-%20sign%20in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="979" data-original-width="1670" height="376" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLWx5NtTHqK6LKmZUMAVXDy7IXqmpcewthAFh-ePssMfwzFiY40AHdx1CMSQVDouEAOXEyK4lRS0VTxy1taRSLssdEdHFxkm6cex8OKnVv9D7Y10i2n2MdHFyWTdYrdi9xFB1Eet19A-TJESBxLoh6XUspgLO8FA8SZwZDFXtTFd3h9l5hWqVhkAvb/w640-h376/PBID%20Unable%20to%20connect%20-%20sign%20in.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">Open the report again and it should connect immediately!</div><div class="separator" style="clear: both; text-align: left;">Everyone happy :-)</div></div><p></p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-6895296776853883792023-05-29T22:08:00.003+02:002023-09-29T13:07:46.567+02:00What Is Microsoft Fabric and Why Should I Care?<p>As I mentioned in my <a href="https://www.nickyvv.com/2023/05/microsoft-build-data-announcements.html" target="">Build Announcement Summary</a>, <a href="https://learn.microsoft.com/en-us/fabric/" target="_blank">Microsoft Fabric</a> has been announced!</p><p>In short, Fabric covers the complete spectrum of services including data movement, data lake, data engineering, data integration and data science, real time analytics, and business intelligence.</p><p>Straight to <a href="https://www.nickyvv.com/2023/05/what-is-microsoft-fabric-and-why-should-i-care.html#nextup">Next up</a>.</p><p>It promises to offer end to end analytics from the data lake to the business user, covering the following pillars:</p><p></p><ul style="text-align: left;"><li>Complete Analytics Platform</li><li>Lake-Centric and Open</li><li>Empower Every Business User</li><li>AI Powered</li></ul>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSLjhhQvvOjqiZSDXjFVooL24y3s7NvWkerQ2DkzkhFGz597PdsEabVjBB092gdkVEqjJK_1okmy8XAD9b1Qpc5g5iaRhvdz5R2WisWoQVVhEosH0WRav-J8DUJvQrQ6Z-tRsd3fLXDydtso4Ol7o6LeZXlra6ZWSj8OfjFElA4Cct7TxaLi8zYP-_/s2085/image.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1151" data-original-width="2085" height="354" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSLjhhQvvOjqiZSDXjFVooL24y3s7NvWkerQ2DkzkhFGz597PdsEabVjBB092gdkVEqjJK_1okmy8XAD9b1Qpc5g5iaRhvdz5R2WisWoQVVhEosH0WRav-J8DUJvQrQ6Z-tRsd3fLXDydtso4Ol7o6LeZXlra6ZWSj8OfjFElA4Cct7TxaLi8zYP-_/w640-h354/image.png" width="640" /></a></div><br /><div><div><br /></div><div>In my opinion this provides the following benefits:</div><div><ul style="text-align: left;"><li>A broad set of deeply integrated analytics </li><li>Shared experiences that are familiar and easy to learn across all the products</li><li>All assets to be easily discovered and reused by all developers</li><li>OneLake, a unified data lake, Microsoft calls it the "OneDrive for data", allowing customers to keep one copy of the data while using the analytics tools of choice </li><li>Centralized administration and governance across all workloads</li></ul></div><div><br /></div><div>As mentioned in <a href="https://www.nickyvv.com/2023/05/microsoft-build-data-announcements.html">my blog</a>, Fabric is turned off by default, until July 1st, so you will have to enable it to start using it! </div><div><br /></div><div><br /></div><div>The new Fabric / Power BI home page when you switch on Fabric looks like this:</div></div><div><br /></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8QhCI6itFnMD0vjRNiDTP9c--07Yd30mP-z2NPOP1UyZKsV8vC7AjTTF9yU4Ujnifcf-0w-xBkAeGe10mfbXszxrKNItk8ATejdWfowW1ztouywikGg3-lSw9hbi2cIk3ngb3gawe0QZ2qZzbfXPX0yJJEL-csVFruBtr45G8pHGMpr0o3F3NhRlY/s1053/Fabric%20home%20page.png" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="886" data-original-width="1053" height="538" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8QhCI6itFnMD0vjRNiDTP9c--07Yd30mP-z2NPOP1UyZKsV8vC7AjTTF9yU4Ujnifcf-0w-xBkAeGe10mfbXszxrKNItk8ATejdWfowW1ztouywikGg3-lSw9hbi2cIk3ngb3gawe0QZ2qZzbfXPX0yJJEL-csVFruBtr45G8pHGMpr0o3F3NhRlY/w640-h538/Fabric%20home%20page.png" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><i>Fabric home page</i></td></tr></tbody></table><br /><div>And with the button in the left bottom corner you can switch between the different persona's/workloads:</div><div><br /></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsLT2h6hyUDWhf4RfdqtdXxLilQek-RsXPx5tLqpmFhsGNnZfcZ8rQhrHYLF0sIvd7Q44734Vfv3DLkFa08-7SBub9ZWiw3RPkY0oWcJwD_uLHCc7NXtU1sWcgV0JhwdaTRPANjZiiDuOBSEzcXRPpoNqK73f3QPnngN8MQN5txRlPs_cFKcS8N1Qw/s327/Fabric%20workload%20switcher.png" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="279" data-original-width="327" height="341" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsLT2h6hyUDWhf4RfdqtdXxLilQek-RsXPx5tLqpmFhsGNnZfcZ8rQhrHYLF0sIvd7Q44734Vfv3DLkFa08-7SBub9ZWiw3RPkY0oWcJwD_uLHCc7NXtU1sWcgV0JhwdaTRPANjZiiDuOBSEzcXRPpoNqK73f3QPnngN8MQN5txRlPs_cFKcS8N1Qw/w400-h341/Fabric%20workload%20switcher.png" width="400" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><i>Fabric workload switcher</i></td></tr></tbody></table><br /><div><br /></div><div><br /></div><div>Microsoft also states clearly that standalone PaaS products will stay untouched and remain active. So there's no need for existing customers to worry about solutions currently in production.</div><div><div><br /></div><div><blockquote><i>"Existing Microsoft products such as Azure Synapse Analytics, Azure Data Factory, and Azure Data Explorer will continue to provide a robust, enterprise-grade platform as a service (PaaS) solution for data analytics. Fabric represents an evolution of those offerings in the form of a simplified SaaS solution that can connect to existing PaaS offerings. Customers will be able to upgrade from their current products into Fabric at their own pace." </i>by Arun Ulag</blockquote></div><div>I'm also pretty sure that existing customer will be able to migrate to the new SaaS-solution.</div><div>If you are familiar with the current Synapse offerings, you might find the following mapping table interesting to have as a reference.</div><div><br /></div><div><table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody><tr>
<td style="background: gray; border: 1pt solid windowtext; mso-background-themecolor: background1; mso-background-themeshade: 128; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 225pt;" valign="top" width="250">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><b><span style="color: white; mso-themecolor: background1;">Synapse<o:p></o:p></span></b></p>
</td>
<td style="background: gray; border-left: none; border: 1pt solid windowtext; mso-background-themecolor: background1; mso-background-themeshade: 128; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 200pt;" valign="top" width="150">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><b><span style="color: white; mso-themecolor: background1;">Fabric<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Pipelines<o:p></o:p></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Data
Pipelines<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Data Flows<o:p></o:p></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Dataflows<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">SQL Pools<o:p></o:p></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Data
Warehouse<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Spark<o:p></o:p></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Spark<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Notebooks<o:p></o:p></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;">Notebooks<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Azure Data Explorer (ADX/Kusto)<o:p></o:p></span></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Real-time Analytics<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">SQL Serverless<o:p></o:p></span></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Lakehouse<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Synapse Workspace<o:p></o:p></span></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Power BI Workspace<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">ADLS Gen2<o:p></o:p></span></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">OneLake<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Linked Services<o:p></o:p></span></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Connections<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Datasets<o:p></o:p></span></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Sources/Destinations<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Self-Hosted Integration Runtime
(SHIR)<o:p></o:p></span></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">Power BI Gateway<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="border-top: none; border: 1pt solid windowtext; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">CI/CD, Git<o:p></o:p></span></p>
</td>
<td style="border-bottom: 1pt solid windowtext; border-left: none; border-right: 1pt solid windowtext; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt; width: 226.55pt;" valign="top" width="302">
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="EN-US">ALM<o:p></o:p></span></p>
</td>
</tr>
</tbody></table></div><div><br /></div></div><div><br /></div><div><div>Although Fabric is still in preview, I would encourage you to try out features and look at the use cases, because:</div><div><ul><li>Fabric is based on the serverless paradigm. You don't have to start clusters or manage resource in Azure anymore. Instead, Fabric delivers capacities as a SaaS resource. You can spin up analytics solutions faster and more easily.</li><li>OneLake makes it easier to:</li><ul><li>Store large amounts of data</li><li>Use one accurate, certified and real-time unified source of truth</li><li>Use shortcuts / mounts to leverages existing data from Azure, AWS or OneLake</li></ul><li>Analysts can leverage their best skills, be it SQL, Spark or DAX</li><li>Performance benefits<br />Microsoft is working on performance improvements, 1 example is DirectLake, the new storage mode for Power BI. Everyting in OneLake is now in the same open Delta Parquet format.</li><li>Simplified billing and management of runtime components<br />Fabric now brings capacities with compute instead of activities per pipeline or TeraBytes/s. That means we don't have to include multiple factors into the equation anymore<br />Instead of managing every resource individually, putting it on pause when you don't need it, you can now provision Fabric capacities, which start at a much smaller price point then a Power BI Premium capacity. Exact pricing will be announced later.</li><li>AI will become a bigger part of our daily work, with the integration of Copilot inside Microsoft Fabric and Power BI</li><ul><li>Generate code and queries</li><li>Turn words into dataflows and data pipelines</li><li>Create Power BI reports in seconds</li><li>Generate DAX calculations</li><li>Create narrative summaries</li></ul></ul><div>This post by Kim Manis has some more details from Microsoft's point of view: <a href="https://powerbi.microsoft.com/en-us/blog/introducing-microsoft-fabric-and-copilot-in-microsoft-power-bi/" target="_blank">Introducing Microsoft Fabric</a>.</div><br /></div></div>
<h2 id="nextup" style="text-align: left;">Next up?</h2><div>There are still quite some questions around Fabric that will be answered in the near future I assume, a few that I'm thinking of are:</div><div><ul style="text-align: left;"><li>Is the performance of Direct Lake really going to be that good?</li><li>What is V-order with regards to parquet files and how can we influence/handle that?</li><li>How will the Processing Units for the Fabric capacities hold up for specific workloads? It will be interesting to see what an F2 capacity can handle for example.</li></ul><div>On Microsoft Learn, there are also 4 <a href="https://learn.microsoft.com/fabric/get-started/end-to-end-tutorials?WT.mc_id=DP-MVP-5003835" target="_blank">End-to-end tutorials</a> available to get you started with learning Fabric:</div></div><div><ul style="text-align: left;"><li>Lakehouse</li><li>Data Science</li><li>Real-Time Analytics</li><li>Data Warehouse</li></ul><div>But also on more experience-specific topics like <a href="https://learn.microsoft.com/en-us/power-bi/fundamentals/fabric-get-started?WT.mc_id=DP-MVP-5003835" target="_blank">Power BI</a>, <a href="https://learn.microsoft.com/fabric/data-factory/tutorial-end-to-end-introduction?WT.mc_id=DP-MVP-5003835" target="_blank">Data Factory</a> and <a href="https://learn.microsoft.com/fabric/data-science/r-avocado?WT.mc_id=DP-MVP-5003835" target="_blank">Price prediction with R for Data Science</a>.</div></div><div>I see you thinking: "So now I need to learn all these new products/services with all the accompanying languages, like T-SQL, Python, R, KQL and what have you...?"<br /></div><div>Can you do it? Of course! But I certainly don't think it's a necessity to get to know everything.</div><div><br /></div><div>For example:</div><div>If today you are a Power BI developer, you might want to familiarize yourself with the Data Warehouse load and maybe learn the basics of T-SQL. But with the default dataset that comes with the Warehouse (as is the case with a Datamart), you could as well create a basic and fast report out of that to do some basic visualizations to familiarize yourself with the data, so T-SQL is also optional. </div><div><br /></div><div>I'm still very excited with this next step forward by Microsoft and I'm eager to start learning more of Fabric. And also to learn the use cases and all the questions that our customers have!</div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-83080062509112032632023-05-24T09:11:00.003+02:002023-05-24T09:11:54.921+02:00Microsoft Build - Data Announcements Summary<div>During Build we heard a lot of announcements around data, analytics and AI. Let me give you my summary and take on the things I heard and saw!</div><div><br /></div><div><div>In general, AI is going to exist in more and more places in our daily work. Earlier, Copilot was already announced in <a href="https://powerapps.microsoft.com/en-us/blog/announcing-a-next-generation-ai-copilot-in-microsoft-power-apps-that-will-transform-low-code-development/" target="_blank">Power Apps</a> and <a href="https://powerautomate.microsoft.com/en-us/blog/automate-smarter-than-ever-before-with-ai-builder-and-copilot-in-power-automate/" target="_blank">Power Automate</a>, <a href="https://blogs.microsoft.com/blog/2023/03/16/introducing-microsoft-365-copilot-your-copilot-for-work/" target="_blank">Outlook and Office products</a>, but also <a href="https://github.com/features/copilot" target="_blank">GitHub</a>. I wouldnβt be surprised if it will be embedded in almost every part of our daily work in the future, at least to some extend.</div><div><br /></div><div>These were my favorite announcements:</div><div><ul style="text-align: left;"><li><span style="white-space: normal;"><b>Microsoft Fabric</b> delivers an integrated and simplified experience for all analytics workloads</span></li><li><span style="white-space: normal;"><div></div></span></li><li><b>Data Activator</b> is a new detection system for alerting and taking actions (and part of Fabric)</li><li><b>Git Integration</b>: delivered as part of the new Fabric workloads</li><li><b>Power BI Desktop Developer Mode</b> will deliver a better experience for developers with a new Power BI Project file-type (PBIP)</li></ul></div><div><div>Let's dive into a little bit more details about the above topics.</div></div></div><div><br /></div><div><h2 style="text-align: left;">Microsoft Fabric</h2><div>Fabric promises to offer end to end analytics from the data lake to the business user, covering the following pillars:</div><div><ul style="text-align: left;"><li><span style="white-space: normal;">Complete Analytics Platform</span></li><li><span style="white-space: normal;">Lake-Centric and Open</span></li><li><span style="white-space: normal;">Empower Every Business User</span></li><li><span style="white-space: normal;">AI Powered</span></li></ul></div><div>Fabric covers the complete spectrum of services including data movement, data lake, data engineering, data integration and data science, real time analytics, and business intelligence.</div></div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjGmt_AWr_o_98qqKWbPgLeOLhl7PeX6LQCiTdE2zi80vxn32WGANIbOHYQX5jX2fFc8nYLCyLXuqdt7sSiwmfuA30HNFC0cqKW9r-_3uYDzh-mD_M2fBNrrmiyjnx7anELWWYzJ7dC_53P3OAJSKrwapwVrk6tPyqCuZOOsgKS2AxtYGKFBzlpBQM2" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="1306" data-original-width="2437" height="342" src="https://blogger.googleusercontent.com/img/a/AVvXsEjGmt_AWr_o_98qqKWbPgLeOLhl7PeX6LQCiTdE2zi80vxn32WGANIbOHYQX5jX2fFc8nYLCyLXuqdt7sSiwmfuA30HNFC0cqKW9r-_3uYDzh-mD_M2fBNrrmiyjnx7anELWWYzJ7dC_53P3OAJSKrwapwVrk6tPyqCuZOOsgKS2AxtYGKFBzlpBQM2=w640-h342" width="640" /></a></div><br /><br /></div><div><div>Fabric makes life simpler for customers with its unified and comprehensive platform. Fabric architecture is based on Software as a Service (SaaS) foundation instead of the traditional Platform as a Service (PaaS), to take simplicity and integration to the next level.</div><div>This SaaS experience makes sure that all the data and services used within Fabric are pre-wired together and share the same user experience, much as with Office today. </div><div><br /></div><div>But of course, Microsoft Fabric was not the only announcement at Build.</div></div><div><br /></div><div><br /></div><div><h2 style="text-align: left;">Power BI Desktop Developer Mode</h2><div>Power BI Desktop Developer Mode is here, at least it will be very soon ! In a nutshell, "Developer Mode" enables you to save a Power BI Desktop file into a Power BI Project (PBIP) and operate on the artifacts stored as a folder in your file system.</div><div>Power BI Desktop is expanding to serve a better experience for developers, with capabilities like:</div><div><ul style="text-align: left;"><li><span style="white-space: normal;">Source Control for version history and diffs</span></li><li><span style="white-space: normal;">CI/CD for e.g. Pull Requests</span></li><li><span style="white-space: normal;">Text editor support</span></li></ul></div><div><br /></div><div>Developer Mode also ties into the next point: Git integration in the service!</div></div><div><br /></div><div><h2 style="text-align: left;">Git Integration</h2><div>The long-awaited source control integration!</div><div>Next to Developer Mode in Desktop and an easier and better way to merge changes into source control, Microsoft has also started working on source control integration on the workspace level.</div><div>Be aware that this is a Premium feature, so only workspaces with a Power BI Premium capacity license can connect to source control.</div><div><br /></div><h2 style="text-align: left;">Data Activator</h2><div>This is actually a new name we haven't heard that much about.</div><div>"It will help customers respond to changes in their data instantly by setting up a system of detection that automatically alerts the team with the right context to take action."</div><div> It looks like a low code/no-code way to take actions on your data. It's only in private preview at the moment, so we'll have to wait a bit to get more info on this. In the meanwhile, you can read the <a href="https://aka.ms/Fabric-DA-Blog" target="_blank">announcement blog</a>.</div><div><br /></div><div><br /></div><h2 style="text-align: left;">Conclusion</h2><div>There's a lot of exciting news shared during Microsoft Build!</div><div><br /></div><div>Also be mindful that until July 1st, Fabric is disabled by default. After that date, it will be enabled by default, so you (as an admin) have some time to prepare your users or only give a small group of people access to Fabric for example. Thank you Microsoft for listening to the community! You can also start a free 60 day trial: <a href="http://aka.ms/Try-Fabric" target="_blank">aka.ms/Try-Fabric</a>.</div><div>A tenant admin can enable Fabric workloads manually by switching the tenant setting to on.</div></div><div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjBs38FsniX1Pvc5P0BGR_2LjDw2RALE2RIyNVxGiwhOjvtxzmKVmMO2p_1QLz2ewr7NqtqOQdRnJrJHtRULq5laX_BaW2s-jA7lzMPK5GKOSuknrQKcG0z7n7EpUYKI01odCj6HLp4TNTTfB-80X0urNWNGPBENLmQmtHuduaiQt0aVyvjRQdIm1sN" style="margin-left: auto; margin-right: auto;"><img alt="" data-original-height="1415" data-original-width="2103" height="430" src="https://blogger.googleusercontent.com/img/a/AVvXsEjBs38FsniX1Pvc5P0BGR_2LjDw2RALE2RIyNVxGiwhOjvtxzmKVmMO2p_1QLz2ewr7NqtqOQdRnJrJHtRULq5laX_BaW2s-jA7lzMPK5GKOSuknrQKcG0z7n7EpUYKI01odCj6HLp4TNTTfB-80X0urNWNGPBENLmQmtHuduaiQt0aVyvjRQdIm1sN=w640-h430" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><div class="separator" style="clear: both; text-align: center;"><i>Taken from the Power BI blog</i></div><br /></td></tr></tbody></table><br /><div>If you want a complete (textual) overview of all announcements during Build, have a look at the <a href="https://news.microsoft.com/build-2023-book-of-news/" target="_blank">Build Book of News 2023</a>.</div><div><br /></div><div>If you want to know more details about Microsoft Fabric and the other announcements, or if you want to watch the recordings of other sessions, I suggest starting with the below sessions to get an overview.</div><div>A few important sessions to start with:</div><div><ul style="text-align: left;"><li><span style="white-space: normal;"><a href="https://build.microsoft.com/en-US/sessions/49e81029-20f0-485b-b641-73b7f9622656?source=sessions" target="_blank">General opening Keynote</a> by Satya Nadella</span></li><li><span style="white-space: normal;"><a href="https://build.microsoft.com/en-US/sessions/bb8f9d99-0c47-404f-8212-a85fffd3a59d?source=sessions" target="_blank">The era of the AI Copilot</a>: follow-up keynote</span></li><li><span style="white-space: normal;"><a href="https://build.microsoft.com/en-US/sessions/b1445158-aff5-44e8-b336-e1550770f028?source=sessions" target="_blank">Next generation AI for developers with the Microsoft Cloud</a>: Data & AI related keynote by Scott Guthrie</span></li><li><span style="white-space: normal;"><a href="https://build.microsoft.com/en-US/sessions/852ccf38-b07d-4ddc-a9fe-2e57bdaeb613?source=sessions" target="_blank">Analytics in the Age of AI</a> by Arun Ulag and Amir Netz and the Synapse/Power BI team. </span>This session delivers the basic understandings of Fabric.</li><li><span style="white-space: normal;"><a href="https://build.microsoft.com/en-US/sessions/8b23c96e-7c35-463d-88b4-564d23dc14a5?source=sessions" target="_blank">Empower every BI professional to do more with data</a> by Zoe Douglas and Christian Wade from the Power BI / Analysis Services team</span></li></ul></div><div>Blog posts:</div><div><ul style="text-align: left;"><li><span style="white-space: normal;"><a href="https://powerbi.microsoft.com/en-us/blog/introducing-microsoft-fabric-and-copilot-in-microsoft-power-bi/" target="_blank">Introducing Microsoft Fabric and Copilot in Microsoft Power BI</a></span></li><li><span style="white-space: normal;"><a href="https://azure.microsoft.com/en-us/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/" target="_blank">Introducing Microsoft Fabric: Data analytics for the era of AI</a></span></li><li><span style="white-space: normal;">As you know Governance and Administration is dear to my heart, I'm going to specifically mention this blog: <a href="https://aka.ms/Fabric-Admin-Gov-Blog" target="_blank">Administration and governance in Fabric</a></span></li></ul></div><div><span style="white-space: normal; white-space: pre;"> </span></div><div><br /></div><div>After hearing all this exciting news, I'll dive into more details on separate blogs on the above topics.</div></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-60979954422044488042023-05-11T12:49:00.005+02:002023-05-11T12:50:06.293+02:00Microsoft Build Is Around The Corner<p><span style="font-family: inherit; font-size: medium;"> <span color="rgba(0, 0, 0, 0.9)" face="-apple-system, system-ui, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif" style="background-color: white; white-space: pre-wrap;">I think I already shared it earlier, but in case you missed it: </span></span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://build.microsoft.com/en-US/home" style="margin-left: 1em; margin-right: 1em;" target="_blank"><span style="font-family: inherit; font-size: medium;"><img border="0" data-original-height="382" data-original-width="1205" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0ERdi52klRpmoVMVm3XfSBWYxfS_W98yndTfadKsRREaUV0xyOYagvQkKCtgurDlwSQbDWRTnw1Fc6VX5E0mKcjlX4k0x00wZX1LaY-m_UJVPgYs_cFsD9lvuhRize6JcI5najcJHmGSJ4zkjUV_33PUQVhynEIdK8WxURkLNia8DhD_PV7qJaxhV/w640-h203/MS%20Build.png" width="640" /></span></a></div><span style="font-family: inherit; font-size: medium;"><br /></span><p style="--artdeco-reset-typography_getfontsize: 1.6rem; --artdeco-reset-typography_getlineheight: 1.5; background-color: white; border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; color: rgba(0, 0, 0, 0.9); counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; cursor: text; line-height: var(--artdeco-reset-typography_getLineHeight); margin: 0px; padding: 0px; vertical-align: var(--artdeco-reset-base-vertical-align-baseline); white-space: pre-wrap;"><span style="font-family: inherit; font-size: medium;"><br style="box-sizing: inherit;" /></span></p><p style="--artdeco-reset-typography_getfontsize: 1.6rem; --artdeco-reset-typography_getlineheight: 1.5; background-color: white; border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; color: rgba(0, 0, 0, 0.9); counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; cursor: text; line-height: var(--artdeco-reset-typography_getLineHeight); margin: 0px; padding: 0px; vertical-align: var(--artdeco-reset-base-vertical-align-baseline); white-space: pre-wrap;"><span style="font-family: inherit; font-size: medium;">In just under 2 weeks, <a href="https://build.microsoft.com/en-US/home" target="_blank">Microsoft Build</a> (in-person and online conference) is happening with a lot of exciting Power BI and data related updates. You should definitely watch it, either live or the recordings afterwards! It starts at Tuesday, May 23rd, 6PM CEST.</span></p><p style="--artdeco-reset-typography_getfontsize: 1.6rem; --artdeco-reset-typography_getlineheight: 1.5; background-color: white; border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; color: rgba(0, 0, 0, 0.9); counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; cursor: text; line-height: var(--artdeco-reset-typography_getLineHeight); margin: 0px; padding: 0px; vertical-align: var(--artdeco-reset-base-vertical-align-baseline); white-space: pre-wrap;"><span style="font-family: inherit; font-size: medium;">More info and registration: <a href="https://build.microsoft.com/en-US/home">build.microsoft.com</a></span></p><p style="--artdeco-reset-typography_getfontsize: 1.6rem; --artdeco-reset-typography_getlineheight: 1.5; background-color: white; border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; color: rgba(0, 0, 0, 0.9); counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; cursor: text; line-height: var(--artdeco-reset-typography_getLineHeight); margin: 0px; padding: 0px; vertical-align: var(--artdeco-reset-base-vertical-align-baseline); white-space: pre-wrap;"><span style="font-family: inherit; font-size: medium;"><br /></span></p><p style="--artdeco-reset-typography_getfontsize: 1.6rem; --artdeco-reset-typography_getlineheight: 1.5; background-color: white; border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; color: rgba(0, 0, 0, 0.9); counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; cursor: text; line-height: var(--artdeco-reset-typography_getLineHeight); margin: 0px; padding: 0px; vertical-align: var(--artdeco-reset-base-vertical-align-baseline); white-space: pre-wrap;"><span style="font-family: inherit; font-size: medium;">A few important sessions to start with:</span></p><p style="--artdeco-reset-typography_getfontsize: 1.6rem; --artdeco-reset-typography_getlineheight: 1.5; background-color: white; border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; color: rgba(0, 0, 0, 0.9); counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; cursor: text; line-height: var(--artdeco-reset-typography_getLineHeight); margin: 0px; padding: 0px; vertical-align: var(--artdeco-reset-base-vertical-align-baseline); white-space: pre-wrap;"></p><ul style="text-align: left;"><li><span style="font-family: inherit; font-size: medium;"><span style="background: var(--artdeco-reset-base-background-transparent); border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; font-size: var(--artdeco-reset-base-font-size-hundred-percent); font-weight: var(--artdeco-reset-typography-font-weight-bold); margin: var(--artdeco-reset-base-margin-zero); outline: var(--artdeco-reset-base-outline-zero); padding: var(--artdeco-reset-base-padding-zero); vertical-align: var(--artdeco-reset-base-vertical-align-baseline);"><a href="https://build.microsoft.com/en-US/sessions/49e81029-20f0-485b-b641-73b7f9622656?source=sessions" target="_blank">General opening Keynote</a></span> by <b>Satya Nadella</b></span></li><li><span style="font-family: inherit; font-size: medium;"><span style="background: var(--artdeco-reset-base-background-transparent); border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; font-size: var(--artdeco-reset-base-font-size-hundred-percent); font-weight: var(--artdeco-reset-typography-font-weight-bold); margin: var(--artdeco-reset-base-margin-zero); outline: var(--artdeco-reset-base-outline-zero); padding: var(--artdeco-reset-base-padding-zero); vertical-align: var(--artdeco-reset-base-vertical-align-baseline);"><a href="https://build.microsoft.com/en-US/sessions/bb8f9d99-0c47-404f-8212-a85fffd3a59d?source=sessions" target="_blank">The era of the AI Copilot</a>,</span> follow-up keynote</span></li><li><span style="font-family: inherit; font-size: medium;"><span style="background: var(--artdeco-reset-base-background-transparent); border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; font-size: var(--artdeco-reset-base-font-size-hundred-percent); font-weight: var(--artdeco-reset-typography-font-weight-bold); margin: var(--artdeco-reset-base-margin-zero); outline: var(--artdeco-reset-base-outline-zero); padding: var(--artdeco-reset-base-padding-zero); vertical-align: var(--artdeco-reset-base-vertical-align-baseline);"><a href="https://build.microsoft.com/en-US/sessions/b1445158-aff5-44e8-b336-e1550770f028?source=sessions" target="_blank">Next generation AI for developers with the Microsoft Cloud</a></span> > Data & AI related keynote by <b>Scott Guthrie</b></span></li><li><span style="font-family: inherit; font-size: medium;">β <span style="background: var(--artdeco-reset-base-background-transparent); border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; font-size: var(--artdeco-reset-base-font-size-hundred-percent); font-weight: var(--artdeco-reset-typography-font-weight-bold); margin: var(--artdeco-reset-base-margin-zero); outline: var(--artdeco-reset-base-outline-zero); padding: var(--artdeco-reset-base-padding-zero); vertical-align: var(--artdeco-reset-base-vertical-align-baseline);"><a href="https://build.microsoft.com/en-US/sessions/852ccf38-b07d-4ddc-a9fe-2e57bdaeb613?source=sessions" target="_blank">Analytics in the Age of AI</a></span> by <b>Arun Ulag</b> and <b>Amir Netz</b> and the Synapse/Power BI team<br />This is a <b>MUST WATCH</b> for every Power BI developer and data engineer, currently working with Synapse, Data Factory and/or Power BI!</span></li><li><span style="font-family: inherit; font-size: medium;">β<a href="https://build.microsoft.com/en-US/sessions/8b23c96e-7c35-463d-88b4-564d23dc14a5?source=sessions" target="_blank">Empower every BI professional to do more with data</a> by <b>Zoe Douglas</b> and <b>Christian Wade</b> from the Power BI / Analysis Services team<br />This is a <b>MUST WATCH </b>for every Power BI developer!<br /></span></li></ul><p></p><p style="--artdeco-reset-typography_getfontsize: 1.6rem; --artdeco-reset-typography_getlineheight: 1.5; background-color: white; border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; color: rgba(0, 0, 0, 0.9); counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; cursor: text; line-height: var(--artdeco-reset-typography_getLineHeight); margin: 0px; padding: 0px; vertical-align: var(--artdeco-reset-base-vertical-align-baseline); white-space: pre-wrap;"><span style="font-family: inherit; font-size: medium;"><br style="box-sizing: inherit;" /></span></p><p style="--artdeco-reset-typography_getfontsize: 1.6rem; --artdeco-reset-typography_getlineheight: 1.5; background-color: white; border: var(--artdeco-reset-base-border-zero); box-sizing: inherit; color: rgba(0, 0, 0, 0.9); counter-reset: list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; cursor: text; line-height: var(--artdeco-reset-typography_getLineHeight); margin: 0px; padding: 0px; vertical-align: var(--artdeco-reset-base-vertical-align-baseline); white-space: pre-wrap;"><span style="font-family: inherit; font-size: medium;">I will also share an update shortly after Build to summarize the news and give my feedback on it, so stay tuned!</span></p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-23725499973940451812023-04-07T19:51:00.004+02:002023-04-07T19:51:46.405+02:00MVP Global Summit 2023 here we come!<p>Hey there, fellow Power BI, Power Platform and tech enthusiasts! </p><p>I'm excited to share with you that I'll be attending the MVP summit on April 18-20 for the first time in-person as an MVP. It's been a long time since there was an in-person MVP Summit, so I'm looking forward to the experience!</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhiPee8t_7-HkPZMPUKwGpf6wYgD49lbR_gkT0GsPEZE0ddMCj8mu3QmKi-fTVVDSWr8dhkEmMHnappXFCNoNIyQkHrMdATZjwUpGW48acAXp1YrM4ePbn_10Rgh4zGcwrl4YqLLRBReQvAkjo1ad9bzQC801K8Ayh-VWLs71pEENzTvEE1q8vtt_JV" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="290" data-original-width="471" height="291" src="https://blogger.googleusercontent.com/img/a/AVvXsEhiPee8t_7-HkPZMPUKwGpf6wYgD49lbR_gkT0GsPEZE0ddMCj8mu3QmKi-fTVVDSWr8dhkEmMHnappXFCNoNIyQkHrMdATZjwUpGW48acAXp1YrM4ePbn_10Rgh4zGcwrl4YqLLRBReQvAkjo1ad9bzQC801K8Ayh-VWLs71pEENzTvEE1q8vtt_JV=w472-h291" width="472" /></a></div><br /><br /><p></p><p>For those of you who may not be familiar with the <a href="https://mvp.microsoft.com/" target="_blank">MVP program</a>, it stands for Most Valuable Professional. It's a program run by Microsoft, celebrating 30 years this year, that recognizes exceptional technical community leaders who share their passion, expertise, and real-world knowledge of Microsoft products with others.</p><p><br /></p><p>Being selected as an MVP is a great honor, and I'm humbled to be part of such a fantastic community. The MVP summit is an annual event where MVPs from around the world gather to meet with Microsoft product teams, provide feedback on upcoming products, and share ideas and best practices.</p><p><br /></p><p>This year's summit will be a hybrid event, meaning that some attendees will be joining virtually, while others will be attending in person. I'm grateful to have the opportunity to attend in person and to meet with other MVPs and members of the (Power BI) product team face-to-face!</p><p><br /></p><p>As a first-time attendee, I'm not entirely sure what to expect, but I'm eager to learn, network, and share my experiences with others. I'm also excited to hear from the product teams about what's coming next in the world of Microsoft products.</p><p><br /></p><p>I also want to thank everyone supporting me in my journey, my family, readers of my blog, attendees at conferences and also my employer <a href="https://powerdobs.nl/" target="_blank">Powerdobs B.V.</a>.</p><p><br /></p><p>Overall, I'm thrilled to be attending the MVP summit and grateful for the opportunity to connect with others in the tech community. I'll be sure to share my experiences with you all once the event is over, so stay tuned!</p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-2379548023317730712023-01-10T12:38:00.003+01:002023-01-10T12:45:18.315+01:00Power BI 2022 In Review: My Favourite FeaturesLast night we had a work meeting at <a href="https://www.powerdobs.nl" target="_blank">Powerdobs</a>, with a few presentations about business updates, new joiners in the coming months and Power BI projects. I had the pleasure of closing the evening with a presentation on Power BI.<div>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKH_XRQu6BV0hX7V7L_-XH2YVNTkhnYp5pd85IyF5HDzrweGDjAotxqndciUrq_ZWxsh60IdhvmR870OxtTv1cPaQ5Cf6YbRlyggOBuZGtZGiSCWLFk8j2XxH70Qx7IYMiN-m9TtJiobmR4VsCi4XoWK3dD6M-zQsVPWMBMkgrWlQT4tvqhYls_gHJ/s831/Power%20BI%202022%20in%20review.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="801" data-original-width="831" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKH_XRQu6BV0hX7V7L_-XH2YVNTkhnYp5pd85IyF5HDzrweGDjAotxqndciUrq_ZWxsh60IdhvmR870OxtTv1cPaQ5Cf6YbRlyggOBuZGtZGiSCWLFk8j2XxH70Qx7IYMiN-m9TtJiobmR4VsCi4XoWK3dD6M-zQsVPWMBMkgrWlQT4tvqhYls_gHJ/s320/Power%20BI%202022%20in%20review.png" style="display: none;" width="320" /></a></div>
<br /><div><br /><div>
So I decided to do a presentation on my favourite additions to Power BI over the past year.
But instead of doing a regular PowerPoint presentation, I decided to do an all-Power-BI presentation. It was very well received and I was encouraged to share it here!</div><div>Without further ado, here is the report: π <div><br /></div><div><br /></div>
<div>
<iframe allowfullscreen="true" frameborder="0" height="486" src="https://app.powerbi.com/view?r=eyJrIjoiY2FhOWI4MDUtYTY5My00MGE0LWExNmYtNTZjNDFmZTE5YzAxIiwidCI6IjNmYTllOGFkLTYxZTEtNDYwYy05NjhhLTU4MDFjOGE2YTg0ZiIsImMiOjl9&embedImagePlaceholder=trueamp;pageName=ReportSection36bd7b511000439ca0be" title="Power BI 2022 in review" width="600"></iframe>
</div>
<div><br /></div><div>In future posts I will dig into the details of this report and let you know how I created it.</div><div>I'll also explain why I did (not) include certain features.</div><div><br /></div><div>For writing this post I was inspired by Kasper's <a href="https://www.youtube.com/watch?v=UgOkBiPLN9c" target="_blank">Power BI year 2022 in review</a> and Marco's <a href="https://www.sqlbi.com/blog/marco/2022/12/30/what-happened-in-the-dax-world-in-2022/" target="_blank">What happened in the DAX world in 2022</a>.</div><div><br /></div><div><div>Let me know what you think, any comments/additions/improvements are welcome!</div><div>Do you think I missed features in this review from the last year?</div></div></div></div></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-3381583861154178512022-12-30T15:14:00.010+01:002022-12-30T15:56:47.754+01:00Closing out on 2022<div style="text-align: left;">It's the holiday season again. This year flew by if you ask me.</div><div style="text-align: left;">As I did <a href="https://www.nickyvv.com/2021/12/closing-out-on-2021.html">last year</a>, I like to close this year with a little review and mention a few of the things I did.<br /></div>
<div><img border="0" data-original-height="926" data-original-width="1280" height="464" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTpuIrgr32pUvjTlZv1D00GgixlqSsNa9IzyB9omYN7ymROBgxtxP6a34Ugjik2OWpRukCpkq8aaezKtsQu4AifDBJ1uELHuorm-VmcziJ2CNrXmrECGHuB43iWx5JTanE250yXhpMgPneVFEV1T5IH1iEUtDECHvhsDMfQUSl4vhMqtLEuuMYUr5I/w640-h464/fireworks-180553_1280.jpg" style="display: none;" width="640" /></div>
<div style="text-align: left;"><br /></div><h3 style="text-align: left;">Blogging</h3><div><span style="font-family: inherit;">I can at least say I did a bit better than last year, writing a total of 12 posts this year. I still like to get some more time for writing posts, but <a href="https://www.nickyvv.com/2021/12/finding-and-keeping-motivation-is-hard-you-are-not-alone.html">motivation is still not easy</a>... On the kind of posts: I like in-depth technical ones, where I explain a specific problem or solution I've come across.</span></div><div><span style="font-family: inherit;">And I've also written a lot about Administration and Governance type of topics, like:</span></div><div><ul style="text-align: left;"><li><a href="https://www.nickyvv.com/2022/09/power-bi-governance-administration-naming-conventions.html">Naming Conventions</a><br /></li><li>Installing the <a href="https://www.nickyvv.com/2020/04/installing-powershell-power-bi-management-cmdlets.html">PowerShell commandlets</a> to <a href="https://www.nickyvv.com/2020/06/refresh-a-power-bi-dataset-with-powershell-and-a-service-principal.html">Refresh a Dataset with PowerShell</a><br /></li><li>But also a <a href="https://www.nickyvv.com/2022/12/a-no-code-method-to-refresh-one-table-from-a-powerbi-dataset.html">No-Code Method to Refresh One Table From a Power BI Dataset in the Service</a></li></ul></div><div><br /></div><h3 style="text-align: left;">Speaking</h3><div><span style="font-family: inherit;">Luckily, in-person speaking has returned again. I think I can speak for everyone if I say that we missed that very much the last year(s).<br />I've had some great speaking gigs this year, like a virtual presence at SQLBits, The Dutch Power BI User Day (Deep Dive as well as the free Saturday), DataGrillen, and (both virtual) New Zealand Business Applications Summit and the Pakistan Power Platform Bootcamp.</span></div><div><span style="font-family: inherit;">While I didn't have the pleasure to speak at dataMinds Connect this year, I did attend it with a few <a href="https://powerdobs.nl/blog/powerdobs-heading-for-mechelen/" target="_blank">colleagues</a>, which was again awesome!</span></div><div><br /></div><h3 style="text-align: left;">MVP</h3><div><span style="font-family: inherit;">I've been awarded Microsoft </span><a href="https://mvp.microsoft.com/en-us/PublicProfile/5003835?fullName=Nicky%20van%20Vroenhoven" style="font-family: inherit;" target="_blank">Most Valuable Professional</a><span style="font-family: inherit;"> in the Data Platform category for the 3rd time in a row now! </span></div><div><br /></div><h3 style="text-align: left;">Learning goals</h3><div>In May, I took the (then beta) exam DP-500 (<a href="https://learn.microsoft.com/certifications/azure-enterprise-data-analyst-associate/?WT.mc_id=DP-MVP-5003835" target="_blank">Azure Enterprise Data Analyst Associate</a>) and in early July I got the confirmation of receiving the certification!</div><p>Are you still interested in taking this exam? Have a look at my <a href="https://www.nickyvv.com/2022/05/mastering-the-role-based-dp-500-exam.html.html">overview post</a>.</p><p>I didn't do much reading, in books that is. I've read numerous blog posts, but not really any books. Let's up that game in 2023 and put in effort to do more reading.</p><p>I do like listening to podcasts, ranging from running (<a href="https://www.runnersworld.com/nl/podcast/" target="_blank">Susy Q&A</a>, <a href="https://open.spotify.com/show/6jSdjO5ht0eqgrHF7Qvhh7" target="_blank">Klaas en Koen lopen weg</a>) to tech (<a href="https://www.kneedeepintech.com/" target="_blank">Knee-Deep in Tech</a>, <a href="https://www.kasperonbi.com/kasper-on-bi-podcast/" target="_blank">Kasper on BI</a>, <a href="https://powerbi.tips/explicit-measures-power-bi-podcast/" target="_blank">Explicit Measures</a>). I like to listen to them during my morning or lunch walks and sometimes during running also.</p><div><br /></div><h3 style="text-align: left;">Powerdobs</h3><div>In February of this year, I started my job as the Unit Lead Power BI at <a href="https://www.powerdobs.nl" target="_blank">Powerdobs B.V.</a> It's a small consultancy company based in 's-Hertogenbosch, focused on the Azure Data Platform and Power BI. We now have 8 consultants (in one month 9 π), with some backend, some front-end and a few both.</div><div>As the Unit Lead for Power BI (<a href="https://www.linkedin.com/in/sjoerddonker" target="_blank">Sjoerd Donker</a> is Unit Lead Data Engineering), next to client engagements, I am responsible for spreading knowledge about Power BI and also getting my colleagues excited about sharing knowledge, inside but also outside the company, through blogs and presentations.</div><div><br /></div><div>I definitely thought my move to Van Lanschot Kempen (my previous employer) was the best I would ever make, because of the permanent employenent, less travelling and building a solid relationship and solutions inside one company.<br />However, I missed the point of being with <i>my hands on the buttons</i> of Power BI a bit, so I couldn't resist taking the chance to join this family of Power BI enthusiasts at Powerdobs. And it truely feels like a little family here! π</div><div><br /></div><h3 style="text-align: left;">Sports/health</h3><div>With a last year of running just over 1800 km's, I was a bit fed up with running in the first quarter of this year.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPqoxPM_avCFXm9Eunj2YQ5V1o_-pD3jPR49JS852XtalT64pSbE0ZApzWGV6KWE8CPVbUBWuSP5G_akXvFgJoSSiIO_nPx4iEScNT3czppjS3Wtg6yKJVgc9KYdwuRkAHnZ-r8ElkyJ6LQcGY4dDxs20J0ZYLthGOwSUQtqF0oA9FumHs5I7ndxkQ/s662/runkeeper%202022.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="182" data-original-width="662" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPqoxPM_avCFXm9Eunj2YQ5V1o_-pD3jPR49JS852XtalT64pSbE0ZApzWGV6KWE8CPVbUBWuSP5G_akXvFgJoSSiIO_nPx4iEScNT3czppjS3Wtg6yKJVgc9KYdwuRkAHnZ-r8ElkyJ6LQcGY4dDxs20J0ZYLthGOwSUQtqF0oA9FumHs5I7ndxkQ/w640-h176/runkeeper%202022.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div>This year my total will be around 1120 km, so a lot less then last year, but I can definitely say I ran much more effectively. For example: I used to go running to and from the interval training at the club (4.5K), just to get more K's in. Now I take the bike to the training, so the training itself can be more effective, especially with an interval training.<div>On the half marathon goal (of 90 minutes): I had one try in October in Eindhoven, but that didn't go as planned. π</div><div>
<blockquote class="twitter-tweet"><p dir="ltr" lang="en">I did a half marathon today! Not the wanted PR, but still satisfied I completed it! <a href="https://twitter.com/hashtag/runhappy?src=hash&ref_src=twsrc%5Etfw">#runhappy</a> <a href="https://t.co/rJ2sEsnVIF">pic.twitter.com/rJ2sEsnVIF</a></p>β Nicky van Vroenhoven (@NickyvV) <a href="https://twitter.com/NickyvV/status/1579151656805359617?ref_src=twsrc%5Etfw">October 9, 2022</a></blockquote> <script async="" charset="utf-8" src="https://platform.twitter.com/widgets.js"></script>
<div><div>I still love the fact that all the <a href="https://twitter.com/NickyvV/status/1532600105919995904" target="_blank">#runhappy</a> buddies are going strong!</div><div></div></div><div><br /></div><div>Next to running I've also been doing a bit more workouts at home, being mainly pilates and strength exercises (with the Skimble app) to complement the running, and the last monhts also some yoga to start the day.<br /><p>I've also been doing some cold showers and <a href="https://www.wimhofmethod.com/" target="_blank">Wim Hof</a> (a.k.a. the Iceman) breathing exercises once in a while the last year. But in the beginning of October I've had the pleasure of attending a Wim Hof (half day) workshop, on mindset, breathing and cold. So I took an ice bath! π</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnrMMb94fr_W-Z8oCHxEVj__Gl9ppqf3yttuVHBZhJOhyxkrKS-0QGwtiumCL98k2GRnAdMWJdsPPYewJrNvnFYJhDqBtf5vV0OpOPc4rmE1CBYeItkaHHK0KQduzy6CSXrUbgIvLrqVmpTTFegWq7smtjm3Clbbu5GCGMsLXnFZkpEUKhM6GYG7C7/s1024/WhatsApp%20Image%202022-10-08%20at%2019.01.48-blur.jpeg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1024" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnrMMb94fr_W-Z8oCHxEVj__Gl9ppqf3yttuVHBZhJOhyxkrKS-0QGwtiumCL98k2GRnAdMWJdsPPYewJrNvnFYJhDqBtf5vV0OpOPc4rmE1CBYeItkaHHK0KQduzy6CSXrUbgIvLrqVmpTTFegWq7smtjm3Clbbu5GCGMsLXnFZkpEUKhM6GYG7C7/w400-h300/WhatsApp%20Image%202022-10-08%20at%2019.01.48-blur.jpeg" width="400" /></a></div><br /><p>After that day, I've been consistently doing a cold shower every morning now! It feels amazing going through that stress and adrenaline rush in the morning, and feeling relaxed after a few seconds of focussing on my breathing.<br />I just have to get the breathing exercises incorporated more into my daily routine also.</p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTpuIrgr32pUvjTlZv1D00GgixlqSsNa9IzyB9omYN7ymROBgxtxP6a34Ugjik2OWpRukCpkq8aaezKtsQu4AifDBJ1uELHuorm-VmcziJ2CNrXmrECGHuB43iWx5JTanE250yXhpMgPneVFEV1T5IH1iEUtDECHvhsDMfQUSl4vhMqtLEuuMYUr5I/s1280/fireworks-180553_1280.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="926" data-original-width="1280" height="464" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTpuIrgr32pUvjTlZv1D00GgixlqSsNa9IzyB9omYN7ymROBgxtxP6a34Ugjik2OWpRukCpkq8aaezKtsQu4AifDBJ1uELHuorm-VmcziJ2CNrXmrECGHuB43iWx5JTanE250yXhpMgPneVFEV1T5IH1iEUtDECHvhsDMfQUSl4vhMqtLEuuMYUr5I/w640-h464/fireworks-180553_1280.jpg" width="640" /></a></div><br /><p>That's all for this year. I whish everyone the best New Year's Eve and a great start of 2023!</p><p><br /></p><p>Nicky. Out.<br /></p></div></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-22848118542768558812022-12-19T13:49:00.002+01:002022-12-30T16:01:19.436+01:00SSMS Error when refreshing a Power BI Table: Paramter name already exists<p>2 weeks ago I talked about <a href="https://www.nickyvv.com/2022/12/a-no-code-method-to-refresh-one-table-from-a-powerbi-dataset.html">A No-Code Method to Refresh One Table From a Power BI Dataset in the Service</a>. I recently ran into an error using this method, so I thought it was worth sharing this error, and the solution π, with you.</p>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPvkFPkD81HHVMzMzhvkSFE46nTZ0ExLtT4JupqJB_oTNJf5yiNxMX4WSNMPRrmIXM-KNqgYczhrAeOVmwUcmMyVZBJznIlXgSFjcTc0JwsKJgGvXRkErM9gNBMHnqxx5L517cziZSAoZgTEIS-JVhURvciJBkMuNGNlbD701TTufLPy-L4jwLf4w5/s684/SSMS%20refresh%20error.png" style="margin-left: 1em; margin-right: 1em;">
<img border="0" data-original-height="286" data-original-width="684" height="168" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPvkFPkD81HHVMzMzhvkSFE46nTZ0ExLtT4JupqJB_oTNJf5yiNxMX4WSNMPRrmIXM-KNqgYczhrAeOVmwUcmMyVZBJznIlXgSFjcTc0JwsKJgGvXRkErM9gNBMHnqxx5L517cziZSAoZgTEIS-JVhURvciJBkMuNGNlbD701TTufLPy-L4jwLf4w5/w400-h168/SSMS%20refresh%20error.png" style="display: none;" width="400" />
</a>
</div>
<h2 style="text-align: left;">TL;DR</h2><div><b>Don't use the initial catalog when you're connecting to a Power BI dataset with SQL Server Management Studio (SSMS).</b></div><div>If you want to now more details about the exact problem and solution, please read on below.</div><div><br /></div><h2 style="text-align: left;">Problem</h2><div>In my previous post I mentioned:</div><div><br /></div><div><blockquote>"With some tools it might be necessary to also provide the Initial Catalog (the dataset to connect to in your workspace). The datasets in your workspace will eventually show as databases under your AS-server:"</blockquote>
<div style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.2px;"><div class="separator" style="clear: both; text-align: center;"><blockquote><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhJbdc7-lxOVbfFQIVjcVb7C5UBBxZDzTzEwtN2a4Ew-EKUvsEqhuF-4ZFXy2Gch8UFG1kfaWNvKKQ3eWCUmziETZgLy-FmNJiSLHObRo5wVcr3QhDzTgVw4gK1JCkduNWB8Ep-v4zx-7Q1RKK6joB5uwbDNmIxd-32MchjMRxLli7ti0lV2GMUpwwD" style="color: #5c91c2; margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="266" data-original-width="477" height="223" src="https://blogger.googleusercontent.com/img/a/AVvXsEhJbdc7-lxOVbfFQIVjcVb7C5UBBxZDzTzEwtN2a4Ew-EKUvsEqhuF-4ZFXy2Gch8UFG1kfaWNvKKQ3eWCUmziETZgLy-FmNJiSLHObRo5wVcr3QhDzTgVw4gK1JCkduNWB8Ep-v4zx-7Q1RKK6joB5uwbDNmIxd-32MchjMRxLli7ti0lV2GMUpwwD=w400-h223" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.1) 1px 1px 5px; padding: 5px; position: relative;" width="400" /></a></blockquote></div></div></div><div><br /></div><div>I did specifically say <i>some tools</i>, and <i>might</i>. π</div><div>So, to be even more specific, when using SSMS Γ‘nd the option for initial catalog, you run into the below error message:</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEidBhsHpnzRMbmzOFahR45Hp-pMLYXVhz2_buQLcaNIgn8YLJtuxEYdekm2V0sOhjMb010ExKPR_0-aaS0v6XDsy_RrQeWY82Of3nGv_borECf08IZ-SF3OQrEQLP9wBzHfsgVJI-tplsg7FNG0zTWeAab1Jjvz8g5_kSboa8snaVlgQHRqewGWiXhM" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="821" data-original-width="1032" height="509" src="https://blogger.googleusercontent.com/img/a/AVvXsEidBhsHpnzRMbmzOFahR45Hp-pMLYXVhz2_buQLcaNIgn8YLJtuxEYdekm2V0sOhjMb010ExKPR_0-aaS0v6XDsy_RrQeWY82Of3nGv_borECf08IZ-SF3OQrEQLP9wBzHfsgVJI-tplsg7FNG0zTWeAab1Jjvz8g5_kSboa8snaVlgQHRqewGWiXhM=w640-h509" width="640" /></a></div><br /><br /><div>I tried a few things before I <strike>got</strike> asked for some (external) help. A little bit of context around the problem:<br /><div><ul style="text-align: left;"><li>Note that the message itself also has a typo in it (paramter π).</li><li>It happens to every table in every dataset (I tried so far) in this workspace. I tried another workspace and that refreshed fine from the UI.</li><li>A colleague is getting the same error message in the UI for this particular workspace.</li><li>Looking at the error I checked if there are params called <i>name</i> in the datasets, but there aren't.</li><li>It's a test workspace in a deployment pipeline.</li></ul><div><br /></div></div><p></p><h2 style="text-align: left;">Solution</h2><div>Luckily the solution is very simple! </div><ul style="text-align: left;"><li>Don't use the Initial Catalog option in combination with SSMS, leave it at <i><default></i></li><li>Or, if for any reason you need the above option selected, install <a href="https://learn.microsoft.com/sql/ssms/release-notes-ssms-19?view=sql-server-ver16&WT.mc_id=DP-MVP-5003835#current-ssms-preview-release" target="_blank">SSMS 19 Preview 4</a></li><ul><li>This preview version is a side-by-side installation, so it installs next to SSMS 18.x</li></ul></ul><div><br /></div><div>I hope this helped you if you encountered the same problem.</div><p></p></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com1tag:blogger.com,1999:blog-7149479726422748695.post-6225989767279990212022-12-05T15:31:00.003+01:002022-12-19T13:56:09.543+01:00A No-Code Method to Refresh One Table From a Power BI Dataset in the Service<h2 style="text-align: left;">Context</h2><p>A few weeks back I was working on a dataset at a client where I needed to import Excel files from a folder into said dataset. I filtered the files on a prefix and loaded around 30 files of the same structure to a table in my dataset. The Excel files are exports from a budgetting system (I know, right?) that have to be updated multiple times in the next coming weeks on an ad-hoc basis.</p><p>After the Excel files are updated I currently have 2 choices:</p><p></p><ul style="text-align: left;"><li>Open the pbix-file and refresh the specific table that loads the files, and then publish to the service. This however again triggers a refresh in the service after publishing. Depending on the connection I have in the pbix (subset of rows from dev/test/prod) I might have to wait for the refresh in the service anyhow</li><li>Refresh the dataset in the service and wait for that to finish</li></ul><div>And it's not that the dataset is thΓ‘t big, but of course waiting (for 20 to 30 minutes) for a refresh would be a waste of time. And it doesn't really matter how long it exactly takes, if you're waiting for something, it always takes too long, right?</div><div><br /></div><h2 style="text-align: left;">Solution</h2><p></p><p>But as you might have noticed from the title of this blog, there is also another solution π.<br /><i>Spoiler alert: you do need <b>a Premium license</b>.</i></p><p>Marc Lelijveld previously talked about the automation of <a href="https://data-marc.com/2021/02/18/trigger-a-single-table-to-refresh-in-the-power-bi-service/" target="_blank">triggering a single table to refresh in the Power BI Service</a>, with PowerShell and a TMSL script. </p><p>But what if you're not (that) familiar with PowerShell and / or TMSL? And maybe it's not going to be part of an automated schedule, but you just want to be able to execute it ad-hoc, when necessary?</p><p>Luckily there's the XMLA endpoint to the rescue. You can connect to any Premium (Capacity or Per User) workspace via the XMLA endpoint with SQL Server Management Studio (SSMS) to do a (single) table refresh.</p><p><br /></p><p>There's a few things you'll have to consider before being able to do this..</p><p></p><ul style="text-align: left;"><li>Enable XMLA read-write</li><li>Get the XMLA endpoint connection string</li><li>Connect via SSMS</li><li>Refresh your table(s)</li><li>Check the outcome of the refresh in SSMS</li><ul><li>Or alternatively check the refresh history in the service</li></ul></ul><div>Let's look at the individual steps in more detail.</div><div><br /></div><p></p><p></p><h3 style="text-align: left;">Enable XMLA read-write</h3><div><br /></div><div style="text-align: left;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjE_Cku78DKnAtH5LEOgVtJdnpEWSUpSstin1Otc1K40b-qAn6Zi9cdiEBPP4ts5dOQSh1m8jsEd1lO_PtXklCD1W890gbwnGPeo0FMA8_tLIfUhaoQMY2NdO9tiGA-MFNdhbmbcET8hmN_WsFIcqkNUeqA5ryf6OvEfo7-Bz2gzakBce8oxpkbp7d6" style="clear: left; display: inline; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img alt="" data-original-height="133" data-original-width="140" src="https://blogger.googleusercontent.com/img/a/AVvXsEjE_Cku78DKnAtH5LEOgVtJdnpEWSUpSstin1Otc1K40b-qAn6Zi9cdiEBPP4ts5dOQSh1m8jsEd1lO_PtXklCD1W890gbwnGPeo0FMA8_tLIfUhaoQMY2NdO9tiGA-MFNdhbmbcET8hmN_WsFIcqkNUeqA5ryf6OvEfo7-Bz2gzakBce8oxpkbp7d6=s16000" /></a></div><div><div><br /></div>The first thing you <b>need</b> to do is to enable the option Read Write on the XMLA Endpoint of your Premium capacity.</div><div><br /></div><div>This setting is available in the Admin Portal, either under Capacity settings or Premium Per User, depending on your license.<br /></div><div><br /></div><div><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><h3 style="text-align: left;">XMLA Endpoint connection</h3><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhgLEHTkqdlsIg2U4dHrSJkbeJHio6tkE1vge9YkMMZn4sdPYjoam4KEx4Yqa4NwbWJM_Tbp0d4HLlpUC4hltJwKySXvHP2wrcd2TuyeOq8gDud-WhPTdhDX2gndPwUpDNgkezN_Y69BVG80KKA_PDTb6aFUcWMCNGbhaN8f8YTFdaj-0QgCxGP03m5" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="" data-original-height="517" data-original-width="388" src="https://blogger.googleusercontent.com/img/a/AVvXsEhgLEHTkqdlsIg2U4dHrSJkbeJHio6tkE1vge9YkMMZn4sdPYjoam4KEx4Yqa4NwbWJM_Tbp0d4HLlpUC4hltJwKySXvHP2wrcd2TuyeOq8gDud-WhPTdhDX2gndPwUpDNgkezN_Y69BVG80KKA_PDTb6aFUcWMCNGbhaN8f8YTFdaj-0QgCxGP03m5=s16000" /></a></div><br /><br /></div><br /><br /></div><div><br /><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><span style="font-family: inherit;">You can get the connection URL from the workspace Settings page, under the Premium tab.</span></div><div>More info on the <a href="https://learn.microsoft.com/power-bi/enterprise/service-premium-connect-tools?WT.mc_id=DP-MVP-5003835#to-get-the-workspace-connection-url" target="_blank">documentation page</a>.</div><div><br /></div><div><span style="font-family: inherit;"><b>Note</b>: Connecting to a <b>My Workspace</b> by using the XMLA endpoint is currently not supported.</span></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><h3 style="text-align: left;">Connect via SSMS</h3><div><br /></div><div>Use SQL Server Management Studio to connect to the URL obtained in the previous step. Just be aware that you need version 18.9 or higher to do so.</div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgkp6PHEkx2Gh2_AYmSv8b_3erTx3hol2v53CGMUD4k5lKXU5RalovIy2tn4DyWtJWn764rpz9PG15IckH7kqvcSSx87zWJ1eV5cl-3y9G3VF644BSSW6QE1-b7GexbHR6RzVKMbJL7E5Yyp_magmQJBmJnZS2GvsModY4DxQK6ZLDrwJ-vBWcJX6vd" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="473" data-original-width="716" height="264" src="https://blogger.googleusercontent.com/img/a/AVvXsEgkp6PHEkx2Gh2_AYmSv8b_3erTx3hol2v53CGMUD4k5lKXU5RalovIy2tn4DyWtJWn764rpz9PG15IckH7kqvcSSx87zWJ1eV5cl-3y9G3VF644BSSW6QE1-b7GexbHR6RzVKMbJL7E5Yyp_magmQJBmJnZS2GvsModY4DxQK6ZLDrwJ-vBWcJX6vd=w400-h264" width="400" /></a></div><br /><br /></div><div>Make sure you use the following option for Authentication:</div><div><ul style="text-align: left;"><li>Azure Active Directory - Universal with MFA</li></ul></div><div>Next to connecting to and looking at properties of your Power BI models, this method also supports executing DAX, MDX, and XMLA queries.</div><div><br /></div><div>SSMS isn't the only tool supported by the XMLA endpoint, you can pick any of the tools <a href="https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools?WT.mc_id=DP-MVP-5003835#client-applications-and-tools" target="_blank">mentioned here</a>, e.g. Excel, SQL Server Profiler, DAX Studio or Tabular Editor to name a few of them.</div><div><br /></div><div></div><div><br /></div><div>With some tools it might be necessary to also provide the Initial Catalog (the dataset to connect to in your workspace). The datasets in your workspace will eventually show as databases under your AS-server:</div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhJbdc7-lxOVbfFQIVjcVb7C5UBBxZDzTzEwtN2a4Ew-EKUvsEqhuF-4ZFXy2Gch8UFG1kfaWNvKKQ3eWCUmziETZgLy-FmNJiSLHObRo5wVcr3QhDzTgVw4gK1JCkduNWB8Ep-v4zx-7Q1RKK6joB5uwbDNmIxd-32MchjMRxLli7ti0lV2GMUpwwD" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="266" data-original-width="477" height="223" src="https://blogger.googleusercontent.com/img/a/AVvXsEhJbdc7-lxOVbfFQIVjcVb7C5UBBxZDzTzEwtN2a4Ew-EKUvsEqhuF-4ZFXy2Gch8UFG1kfaWNvKKQ3eWCUmziETZgLy-FmNJiSLHObRo5wVcr3QhDzTgVw4gK1JCkduNWB8Ep-v4zx-7Q1RKK6joB5uwbDNmIxd-32MchjMRxLli7ti0lV2GMUpwwD=w400-h223" width="400" /></a></div></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;"><i>UPDATE December 19th 2022:</i></div><div class="separator" style="clear: both; text-align: left;"><i>When using SSMS and the option to use an Initial Catalog, you (might) run into an error, read <a href="https://www.nickyvv.com/2022/12/ssms-error-when-refreshing-power-bi-table-paramter-name-already-exists.html">my update post</a> how to avoid this.</i></div><div class="separator" style="clear: both; text-align: left;"><i><br /></i></div><h3 style="text-align: left;">Refresh your table(s)</h3><div><br /></div>Now onto the actual refreshing of my tables. <br /><ul style="text-align: left;"><li>Right-click the table you want to refresh and select <b>Process Table</b></li></ul><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgA_hj-xT6IY9sSSguPP84W5JNwPldTzuuXSUcBKZQyeAb9P7HyBX8lgtIeuvq7vvXSMnIvZUiIFlVVAmUjsZSG1Zt_NKjaPlAjcCztzPdVjVwDiTmDeJINCD0DV5t2YR6jrafbnN00gfXUgG-6F_g5ohZLIuN7ZSJ6UH81zoQjdL3F7OzDjDuRKzWw" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img alt="" data-original-height="429" data-original-width="388" height="240" src="https://blogger.googleusercontent.com/img/a/AVvXsEgA_hj-xT6IY9sSSguPP84W5JNwPldTzuuXSUcBKZQyeAb9P7HyBX8lgtIeuvq7vvXSMnIvZUiIFlVVAmUjsZSG1Zt_NKjaPlAjcCztzPdVjVwDiTmDeJINCD0DV5t2YR6jrafbnN00gfXUgG-6F_g5ohZLIuN7ZSJ6UH81zoQjdL3F7OzDjDuRKzWw" width="217" /></a></div><div style="text-align: left;"></div><div><div style="text-align: center;"><br /></div><p></p><p></p><ul style="text-align: left;"><li>Select the right <a href="https://learn.microsoft.com/en-us/analysis-services/tabular-models/process-database-table-or-partition-analysis-services?view=asallproducts-allversions&WT.mc_id=DP-MVP-5003835#bkmk_process_table" target="_blank">processing option</a> depending on your needs, I used a full refresh</li><li>Optionally select other tables to refresh</li><li>Click OK and wait for the refresh to complete.</li></ul><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhjSf3doBaR8HUpqxLOlTMEutJBPa5TDbFRgC-CrULlQmfWqQpaw9B28FTJz86Kj-0It5DyLmHQnWWVScEcUUVCWcapU1bWG0-vu6AQ_4-QVF7lCe0g8d4qQvBmFy9jhJHizeN9hvXNB_-BY-BwyDOtfG-kqeM75lawOc9WGQRAA4xJ-vO6mCwExOGx" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="322" data-original-width="697" height="148" src="https://blogger.googleusercontent.com/img/a/AVvXsEhjSf3doBaR8HUpqxLOlTMEutJBPa5TDbFRgC-CrULlQmfWqQpaw9B28FTJz86Kj-0It5DyLmHQnWWVScEcUUVCWcapU1bWG0-vu6AQ_4-QVF7lCe0g8d4qQvBmFy9jhJHizeN9hvXNB_-BY-BwyDOtfG-kqeM75lawOc9WGQRAA4xJ-vO6mCwExOGx" width="320" /></a></div><div><br /></div><div><br /></div><div>Next to refreshing your table(s) in SSMS, you could also script out the refresh command and use it to automate the process. Because I only need to refresh it on an ad-hoc basis I'm good with my solution for now.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjQT2JOiGGeW5Za1xXXGlG30Pi1p9gHD8IRBdb-Jc-V0VgFyv1rZmUmCFvSgWa4_o8TnfpSYQSVhoJ86Eg76_lbyh8eMAmYy7Yr79rsn_KGL86mf3cmjF271aGKEPJh0yr-ZLjw72L4l5_qehGCVUqJBcaamrr7JWjiWcAKFmXgLH6PaQU0ebGKaN6x" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="425" data-original-width="1045" height="130" src="https://blogger.googleusercontent.com/img/a/AVvXsEjQT2JOiGGeW5Za1xXXGlG30Pi1p9gHD8IRBdb-Jc-V0VgFyv1rZmUmCFvSgWa4_o8TnfpSYQSVhoJ86Eg76_lbyh8eMAmYy7Yr79rsn_KGL86mf3cmjF271aGKEPJh0yr-ZLjw72L4l5_qehGCVUqJBcaamrr7JWjiWcAKFmXgLH6PaQU0ebGKaN6x" width="320" /></a></div><br /><br /><p></p><h3 style="text-align: left;">Refresh history</h3><div><br /></div><p>This type of refresh shows as a <i>Via XMLA Endpoint</i> in the Refresh History of your dataset properties in the service.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6APKxS1wMyMNXEC0V2tTJiXoUTTDPJiDX009jsM2SEPelyYa-IxWYjpebnx5lQ9aVqlNPfDgSLg4Q4JfY3T8sMUjmw_6-BiteehxlznI0gZ91TUEJMRSlibdHf2EBgcpWlfn0LMvBJGc9Txvwoy9perIpk7IgIKT9cN4YLpYoxz2t5Khtt0J5qrEL/s520/Refresh%20history.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="329" data-original-width="520" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6APKxS1wMyMNXEC0V2tTJiXoUTTDPJiDX009jsM2SEPelyYa-IxWYjpebnx5lQ9aVqlNPfDgSLg4Q4JfY3T8sMUjmw_6-BiteehxlznI0gZ91TUEJMRSlibdHf2EBgcpWlfn0LMvBJGc9Txvwoy9perIpk7IgIKT9cN4YLpYoxz2t5Khtt0J5qrEL/s16000/Refresh%20history.png" /></a></div><br /><p><br /></p><p>In any case you ever want to cancel a running refresh, also with Premium and the XMLA endpoint set to Read/Write, have a look at this post how to <a href="https://www.elegantbi.com/post/canceldatarefresh" target="_blank">Cancel a refresh with a SessionID (instead of SPID) and DAX Studio</a>.</p><p><br /></p><h2 style="text-align: left;">Conclusion</h2><p><br /></p><p>In this post I provided a UI-only solution to refreshing a single table in your Power BI dataset. Hopefully this post gave you some insights.<br />Have you already used this method before?<br />Do you use it often?<br />Do you use other methods to refresh a table in a dataset?</p><p>I'd love it when you provide more details in the comments!</p><p><br /></p><p><br /></p></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com6tag:blogger.com,1999:blog-7149479726422748695.post-36954679418668781892022-10-31T13:16:00.001+01:002022-10-31T13:27:08.727+01:00Let Me Google That For You<p></p><div>In case you're not familiar, let me first explain what I mean with the title.</div><div><br /></div><div><a href="https://letmegooglethat.com/">Let Me Google That For You</a> is a website, that let's you create a demo of how to do a user-specified Google search. It was designed for tech-savvy people that are frequently asked for help. Its purpose is to gently, but sarcastically, point out that by searching for the problem yourself first, you'd probably come a long way to the answer.</div><div><br /></div><div>While Google is the brand name of a leading internet search engine company, it's also quite commonly used as a verb:</div><div><i><blockquote><span face="Arial, sans-serif" style="background-color: white; color: #1a1a1a; font-style: normal;">To search the internet for information about (a person, topic, etc.):</span><span class="luna-example italic" data-linkid="nn1ov4" data-term="check" face="Arial, sans-serif" style="background-color: white; box-sizing: border-box; color: #4a4a4a; display: block;">We googled the new applicant to check her background.</span></blockquote></i></div><div>And of course, there's also a Bing alternative: <a href="https://letmebingthatforyou.com/" target="_blank">Let Me Bing That For You</a>.</div><div>Or even <a href="https://lmddgtfy.net/" target="_blank">Let Me DuckDuckGo That For You</a> π</div><div><br /></div><h2 style="text-align: left;">How to google</h2><div>Because once in a while I see people ask questions that I can (easily) google, I thought it might be worth writing down how I like to perform my searches. <br />It might be obvious already, but I like to use Google for that. I find it to be better at its job than others, even for Microsoft tech like Power BI and Power Platform.</div><div><br /></div><div>When searching for information, there are a few things I like to do:</div><div><br /></div><h3 style="text-align: left;">Start with the topic</h3><div>Start with a <b>1 or 2 word</b>, preferably as short as possible, topic, like:</div><ul style="text-align: left;"><ul><li>Power BI</li><li>Power Query</li><li>DAX</li><li>(Power BI) REST API</li><li>PowerShell Power BI</li></ul></ul><div><br /></div><h3 style="text-align: left;">Keep it short/to the point</h3><div>After that, add your question on the topic, but also <b>as short as possible</b>. Try not to add too much filler words like <i>and</i>, <i>or</i>, <i>the</i> and <i>a(n)</i>. I also tend to stay away from <i>How do I</i> type of questions.</div><div><br /></div><div>So instead of asking: <a href="https://www.google.com/search?q=how+do+i+use+the+power+bi+rest+api+with+an+authorization+header" target="_blank">how do i use the power bi rest api with an authorization header</a></div><div>I like to keep it short and to the point: <a href="https://www.google.com/search?q=power+bi+rest+api+authorization+header" target="_blank">power bi rest api authorization header</a></div><div><br /></div><div>While the search results might not differ thΓ‘t much, the most important thing to me is that Google suggests search words for you. That way you will get the most commonly asked questions to choose from. That's particularly usefull when you don't know exactly what you are looking for.<br />In case of an error message it's often quite clear, but if you're looking for more general things, or for authorization with an API, you might not know it's called a <b>bearer token</b>.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUi3XnpfxE9SILyiwRf3Ysup2-ooAwbtoiT0JzRuM1-f3ZSP3thGuJtqC5uvSxGRIEfpXJFrJMITC0AFzw1RnyUlcYDh_xDgGi_Cck13OUvalTHAwaOpY-Bac1qlpQr6l81VcbVuxq1w_iNICi97As3vPGrd-6gM19G7TTDKoqGhUho_0BaqkXsn_P/s528/google.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="224" data-original-width="528" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUi3XnpfxE9SILyiwRf3Ysup2-ooAwbtoiT0JzRuM1-f3ZSP3thGuJtqC5uvSxGRIEfpXJFrJMITC0AFzw1RnyUlcYDh_xDgGi_Cck13OUvalTHAwaOpY-Bac1qlpQr6l81VcbVuxq1w_iNICi97As3vPGrd-6gM19G7TTDKoqGhUho_0BaqkXsn_P/s16000/google.png" /></a></div><br /><div><br /></div><h3 style="text-align: left;">Errors</h3>In my line of job I unfortunately quite often run into errors. I always use the exact error message that I encounter: word for word. If the error is too long I might try the first part/sentence of it. But keep it exactly as it is. But again, I <b>start with a 1 or 2 word topic</b>, followed by the error message.<br />A good habit was to create a blog post on the topic if I couldn't find a solution easily. Mainly back in the days when I used to work a lot with <a href="https://www.nickyvv.com/2017/11/ssrs-hidden-expression-for-tablix-has.html">SSRS</a> and <a href="https://www.nickyvv.com/2017/04/ssdt-error-message-unable-to-cast-com.html">SSDT</a>.<br /><p></p><p><br /></p><h2 style="text-align: left;">Ask for help</h2><p>Sometimes you just can't find it on the interwebs. Then your best bet is to <b>ask for help</b>! There's quite a good chance someone has run into that same problem before.<br />Ask you co-workers, use Twitter, the <a href="https://community.powerbi.com/" target="_blank">Power BI Community</a>, Reddit, a private or public Slack group, whatever works for you.</p><p>I'm quite active on Twitter (<a href="https://twitter.com/NickyvV" target="_blank">@NickyvV</a>) and have been using that for over a decade. If you are not, I highly recommend to start doing that. Not only for asking for help, but surely also for the amazing community of Power BI and SQL Server people hanging out there.</p><p>There are even specific hashtags you can incorporate in your search: <a href="https://twitter.com/hashtag/sqlhelp" target="_blank">#sqlhelp</a>, <a href="https://twitter.com/hashtag/powerbihelp" target="_blank">#powerbihelp</a>, <a href="https://twitter.com/hashtag/pbihelp" target="_blank">#pbihelp</a><br />Those are monitored throughout they day by a bunch of people that want to give others a hand.<br />And it's still Twitter, so sometimes you come accross some people that are, let's say, a bit less welcoming.. π </p><p>The majority of interactions is however positive, it's an amazing community!</p><p><br /></p><h2 style="text-align: left;">Searching for Call for Speakers</h2><p>Because I'm also active in the speaking community, I sometimes like to search for places where I can submit my talks. In my opinion <a href="https://sessionize.com/" target="_blank">Sessionize</a> is the best platform to use, for speakers as well as conferences. It quickly let's you make a public speaker profile with presentations you can give, but also submit those presentations to conferences without the need to re-enter all the same details over and over again.</p><p>Since a while, the website has this <a href="https://sessionize.com/app/speaker/discover" target="_blank">Discover events</a> tab which you can use to search for open <i>call for speakers</i>. Before this option was available, and I still do it sometimes to make sure I'm not missing anything on Sessionize itself, I used the option to search for keywords on a specific site on Google:</p><p><a href="https://letmegooglethat.com/?q=site%3Asessionize.com+power+bi" target="_blank"></a></p><blockquote><a href="https://letmegooglethat.com/?q=site%3Asessionize.com+power+bi" target="_blank">site:sessionize.com power bi</a></blockquote><p></p><p><br /></p><h2 style="text-align: left;">Closing</h2><p>With this write-up, I hope I gave you some insights in my daily routine of getting help with things I run into. And to be clear, me having xx years of experience, having a certain title on LinkedIn or being a Microsoft MVP has nothing to do with my amount of searches or things I have to look up.<br />Sometimes we like to think we do, but we can't know everything. Also, Power BI (and Power Platform) is constantly changing. I would say I'm probably looking for some sort of help more than 20 times a day, every day!</p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-1336804092844244592022-09-22T16:32:00.000+02:002022-09-22T16:32:14.043+02:00Power BI Governance & Administration - Naming Conventions<div><div style="margin: 0in; text-align: left;"><p> </p><blockquote>Governance and administration, quite the exciting and popular topic. No? Well, it should be!<br>As I mentioned in my previous post about <a href="https://www.nickyvv.com/2022/06/power-bi-governance-administration.html">Governance and Administration</a>, I have quite some experience and ideas around this topic. I thought it was time to share some of this knowledge and write it down.<br>I did a few posts on the topic already, including on <a href="https://www.nickyvv.com/2020/04/installing-powershell-power-bi-management-cmdlets.html" style="font-family: inherit;" target="_blank"><span style="font-family: inherit;">PowerShell</span></a><span>, the </span><a href="https://www.nickyvv.com/2020/07/using-power-bi-rest-api-as-admin.html" target="_blank"><span style="font-family: inherit;">Power BI REST API</span></a><span> and </span><a href="https://www.nickyvv.com/2020/05/power-bi-governance-administration-organizational-visuals.html" target="_blank">organizational visuals</a><span>.</span></blockquote><span></span></div><p></p><div class="separator" style="clear: both; text-align: center;"><br></div><br><br><p style="font-size: 11pt; margin: 0in;"><br></p></div><h2 style="text-align: left;">Let's Talk Naming Conventions</h2><div>So let's start with the question:</div><div><br></div><h3 style="text-align: left;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL5CH6TOZI_jgaTnPS2k7NWz_ZCJXaT7AAxAug4tOMZ0mxPhUuLo0LcVu2jypdoStXld-HbZQqkAKgLN7qhGLDSFwgqcj1Tw9KTQtSjRO_av1CZ-4U1Tn-jS3YNRNot4AuwipgSd7q2XQJxOUWJsHCjp1s16MyCVY4uz0MLOLWLNLber-qk82svygZ/s1280/Contract.png" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="1280" data-original-width="1280" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL5CH6TOZI_jgaTnPS2k7NWz_ZCJXaT7AAxAug4tOMZ0mxPhUuLo0LcVu2jypdoStXld-HbZQqkAKgLN7qhGLDSFwgqcj1Tw9KTQtSjRO_av1CZ-4U1Tn-jS3YNRNot4AuwipgSd7q2XQJxOUWJsHCjp1s16MyCVY4uz0MLOLWLNLber-qk82svygZ/w320-h320/Contract.png" width="320"></a></div>What is a naming convention?</h3><div><blockquote><i>"Naming conventions are general rules applied when creating text scripts for software programming."</i></blockquote></div><div><br></div><div>That's the <a href="https://www.techopedia.com/" target="_blank">Techopedia</a> definition, which mostly applies to (traditional) software programming. This still applies to using it while programming SQL, M or DAX for example.</div><div>It can be any agreed syntax like one of the following:</div><div><ul style="text-align: left;"><li>ThisIsPascalCase</li><li>thisIsCamelCase</li><li>this-is-kebab-case</li><li>this_is_snake_case</li></ul><div><br></div>But I think it's <b>much broader than using only programming</b> naming conventions these days.</div><div>In the context of Power BI, you can use naming conventions in (literally) all things that need a name, like gateways, workspaces, apps, etc.</div><div><br></div><h3 style="text-align: left;">Why</h3><div>So <b>why</b> would you want to set up a naming convention for anything?</div><div></div><blockquote><div><i>"They have many different purposes, such as adding clarity and uniformity [to scripts], readability for third-party applications, and functionality in certain languages and applications."</i></div><div></div></blockquote><div>That still mostly applies to programming. I'd argue that in the context of Power BI it's also easier to find things in your Power BI ecosystem. Not only for Power BI/IT Admins, but also for report builders and end users.</div><div><br></div><h3 style="text-align: left;">How</h3><div>And <b>how</b> do we set up a naming convention? I would say "it depends". π Take a look at the never ending discussion around <a href="https://softwareengineering.stackexchange.com/questions/57/tabs-versus-spaces-what-is-the-proper-indentation-character-for-everything-in-e" target="_blank">spaces or tabs</a>.</div><div><br></div><div>I think it's not a matter of how you implement it, but the fact that you think about it, implement it and enforce and/or govern it. It's better to actually think about and agree upon a certain convention then to do nothing.</div><div><br><div><h3 style="text-align: left;">Where</h3><div>And where do we use naming conventions? Because they started in traditional programming languages the logical place(s) to start are M and DAX.</div><div><span style="font-family: inherit;">I think the below 2 are the best known once for DAX:</span></div><div><div><ul style="text-align: left;"><li><span style="font-family: inherit;">Always write a Column in the format TableName[Column Name]</span></li><li><span style="font-family: inherit;">Always write a Measure in the format [Measure Name]</span></li></ul></div></div><div>There are already quite some good resources available that talk about M and DAX:</div><ul style="text-align: left;"><li><a href="https://xxlbi.com/blog/power-bi-antipatterns-13/" target="_blank">Power BI Antipatterns #13: Naming conventions</a> in DAX by Daniil Maslyuk (<a href="https://twitter.com/DMaslyuk" target="_blank">@DMaslyuk</a> | <a href="https://xxlbi.com/" target="_blank">B</a>)</li><li><a href="https://blog.enterprisedna.co/power-bi-datasets-types-and-naming-conventions/" target="_blank">Power BI Datasets: Types And Naming Conventions</a> by Sam McKay<br></li><li><a href="https://blog.crossjoin.co.uk/2020/06/28/naming-tables-columns-and-measures-in-power-bi/" target="_blank">Naming Tables, Columns And Measures In Power BI</a> by Chris Webb (<a href="https://twitter.com/cwebb_bi" target="_blank">@cwebb_bi</a> | <a href="https://blog.crossjoin.co.uk/" target="_blank">B</a>), on using <b>human-readable</b> names, <b>correct business terminology</b> and being <b>consistent</b>.</li><li><a href="https://exceleratorbi.com.au/best-practices-power-pivot-power-query-power-bi/" target="_blank">Power BI Best Practices</a> by Matt Allington (<a href="https://twitter.com/ExceleratorBI" target="_blank">@ExceleratorBI</a> | <a href="https://exceleratorbi.com.au/" target="_blank">B</a>), where he talks about naming conventions in the 1st paragraph</li><li><a href="https://www.sqlbi.com/articles/naming-temporary-columns-in-dax/" target="_blank">Naming temporary columns in DAX</a> by SQLBI.com</li><li><a href="https://www.sqlbi.com/blog/marco/2019/01/15/naming-variables-in-dax/" target="_blank">Naming variables in DAX</a> by Marco Russo (<a href="https://twitter.com/marcorus" target="_blank">@marcorus</a> | <a href="https://www.sqlbi.com/blog/marco/" target="_blank">B</a>)</li></ul><div><br></div><div>But besides using naming conventions in programming languages, good places to (start) using them are also:</div><ul style="text-align: left;"><li>Gateways</li><ul><li>Gateway cluster/installations itself</li><li>But also the Data sources in the gateway</li><ul><li>I like to include the type of gateway (File/SQL/...), location/server/database and the username, because that's still not visible in the new Power Platform Admin Center...<br>You can vote for the idea <a href="https://ideas.powerbi.com/ideas/idea/?ideaid=465aea7f-b208-494b-8155-26faeaa21af7" target="_blank">View Username Of A Gateway In Data Source Settings</a> :-) </li></ul></ul><li>Workspaces</li><ul><li>Marc Lelijveld (<a href="https://twitter.com/MarcLelijveld" target="_blank">@MarcLelijveld</a> | <a href="https://data-marc.com/" target="_blank">B</a>) already did a comprehensive overview of workspace setup and naming conventions in <a href="https://data-marc.com/2022/01/18/power-bi-workspace-setup-part-1/" target="_blank">this blog post</a>.</li><li>The name of a workspace can be 256 characters long, but just because you can, doesn't mean you should, right?!</li><li>I also find the <i><a href="https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-workspaces-tenant-level-planning?WT.mc_id=DP-MVP-5003835#workspace-naming-conventions" target="_blank">Implementation Planning docs</a></i> very helpful, especially the don'ts in a workspace name:</li><ul><li>The word <i>workspace</i></li><li>The words <i>Power BI</i></li><li>The name of the organization, unless B2B is used</li></ul></ul><li>Apps</li><ul><li>These don't always have to be the same name as the workspace, as the App is usually what all end-users see, and the workspace access is limited to a subset of people.</li><li>Melissa Coates (<a href="https://twitter.com/SQLChick" target="_blank">@SQLChick</a> | <a href="https://www.coatesdatastrategies.com/" target="_blank">B</a>) does a great job explaing <a href="https://www.coatesdatastrategies.com/blog/why-use-a-power-bi-app" target="_blank">Why to Use a Power BI App</a></li></ul><li>Dataflows</li><ul><li>Have a look at Marc's post <a href="https://data-marc.com/2020/06/09/how-to-keep-your-power-bi-dataflows-organized-and-optimized/" target="_blank">How to keep your Power BI dataflows organized and optimized</a></li></ul><li>AAD-groups (used for Power BI)</li><ul><li>If the groups are used in a workspace, try to include the name/naming convention of the workspace itself, and maybe add the group(s) of users, like [workspace name]-admins/members/viewers</li></ul><li>Premium Capacities</li><ul><li>In case you only have 1, then it might make less sense, but in case you have multiple capacities, for me it makes sense to incorporate the type of the capacity in the name. So either P1/2 or the number of v-Cores asigned to that instance</li></ul><li>Identity & Access Management</li><ul><li>This might slightly be off-topic for most Power BI users, but if Power BI Admins are working closely with the IT/IAM team/system, and users need to get access to workspaces/apps via IAM, syncing the naming between Power BI, AAD(-groups) and IAM requests might be a good case</li></ul><li>...?</li></ul><br><div><br></div>
<h3 style="text-align: left;">Closing</h3><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgo31LhejaOYeaWBB66tSN4pfxZT_PdGpo7GckxtjmmCX-qFS597foTWNpdKwWqFxtB0sRFrf_v1Ee0hO7EvlkReD5tZtVJlDtv6uga7o_Kwi4brHlECr8jS9QVCIFPreIyN6jfis07EjXbawLIVE-G6ErslAaszXvS2-8VrEU_ypB6P3GixrgXVgCD/s1280/Governance%20courthouse.png" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="1225" data-original-width="1280" height="191" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgo31LhejaOYeaWBB66tSN4pfxZT_PdGpo7GckxtjmmCX-qFS597foTWNpdKwWqFxtB0sRFrf_v1Ee0hO7EvlkReD5tZtVJlDtv6uga7o_Kwi4brHlECr8jS9QVCIFPreIyN6jfis07EjXbawLIVE-G6ErslAaszXvS2-8VrEU_ypB6P3GixrgXVgCD/w200-h191/Governance%20courthouse.png" width="200"></a></div>I mentioned a lot of places where naming conventions can be beneficial. I use them because they promote consistency, and can provide more readability and clarity.</div><div>Have you implemented naming conventions anywhere? How do you use them? Or why not?</div><div><br></div></div></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-59247271182067174592022-07-12T15:41:00.001+02:002022-07-12T15:58:35.558+02:00Certification Updates!<span style="font-size: medium;"><br />Last week was already a great week with these amazing things:</span><div><ul style="text-align: left;"><li><span style="font-size: medium;">My Microsoft Data Platform <a href="https://www.linkedin.com/feed/update/urn:li:activity:6950115244681662464/" target="_blank">MVP renewal</a></span></li><li><span style="font-size: medium;">The delivery of an MVP thank you kit, containing an MVP mug, hoody and sticker, by the MVP team</span></li></ul>
<blockquote class="twitter-tweet"><p dir="ltr" lang="en">Thanks <a href="https://twitter.com/Microsoft?ref_src=twsrc%5Etfw">@Microsoft</a> <a href="https://twitter.com/MS_KellyKaye?ref_src=twsrc%5Etfw">@MS_KellyKaye</a> and <a href="https://twitter.com/TinaStenderup?ref_src=twsrc%5Etfw">@TinaStenderup</a> for this amazing MVP gift package! <a href="https://t.co/HprkpcYF1n">https://t.co/HprkpcYF1n</a> <a href="https://t.co/3V8hhg9EW4">pic.twitter.com/3V8hhg9EW4</a></p>β Nicky van Vroenhoven (@NickyvV) <a href="https://twitter.com/NickyvV/status/1544652865603600386?ref_src=twsrc%5Etfw">July 6, 2022</a></blockquote> <script async="" charset="utf-8" src="https://platform.twitter.com/widgets.js"></script>
<div><span style="font-size: medium;"><br /></span></div><div><span style="font-size: medium;">But aparently there was more! π</span></div><div><span style="font-size: medium;"><br /></span></div><span style="font-size: medium;"><div style="text-align: center;"><img border="0" data-original-height="347" data-original-width="580" height="382" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFG836hB2HcRC220Wgxx0rx9jbo6PFcJ1XaQZKVila3384iKvcgaNKcehF05TrB89J-YCiIMDQISRca6H3kqSlxO0zCO596Nh7sW5o5xRGGHRXVL_QQ0HrucFIu_AL3o2s9M6iROO_qn2Xvwe9dppAewilpfmZgX1foUVsBJbOK-nyDAHeIZuvKLwT/w640-h382/DP-500.png" width="640" /></div><br /><br />I noticed this weekend that several other people received their results on the DP-500 exam: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI, so I thought I'd check out mine too.</span></div><div><span style="font-size: medium;">And you might have already guessed it: <b>I passed</b>! π₯³</span><div><span style="font-size: medium;"><br /></span></div><h1 style="text-align: left;">DP-500 History</h1><div><span style="font-size: medium;">Almost 2 months ago I took the (<a href="https://techcommunity.microsoft.com/t5/microsoft-learn-blog/exam-dp-500-beta-prove-your-skills-as-an-azure-enterprise-data/ba-p/3279435?WT.mc_id=DP-MVP-5003835" target="_blank">then beta</a>) exam DP-500, on which I <a href="https://www.nickyvv.com/2022/05/mastering-the-role-based-dp-500-exam.html.html">wrote about earlier how to master this exam</a>.</span></div><div><span style="font-size: medium;">As the name of the exam suggests, this is not an exam for beginners. To recap a little bit from my previous blog post, the exam covers the following products/services:</span></div><div><ul><li><span style="font-size: medium;">Microsoft Power BI, including some external tools</span></li><li><span style="font-size: medium;">Microsoft Purview (a.k.a. <a href="https://azure.microsoft.com/en-us/blog/azure-purview-is-now-microsoft-purview/?WT.mc_id=DP-MVP-5003835">Azure Purview</a>)</span></li><li><span style="font-size: medium;">Azure Synapse Analytics</span></li><li><span style="font-size: medium;">Azure Data Lake Gen2</span></li><li><span style="font-size: medium;">DevOps</span></li></ul></div><div><span style="font-size: medium;"><br />At the end of June, the <a href="https://docs.microsoft.com/learn/certifications/exams/dp-500?WT.mc_id=DP-MVP-5003835" target="_blank">exam</a> went live, so it's no longer in beta. This also means there is now an <a href="https://docs.microsoft.com/learn/certifications/courses/dp-500t00?WT.mc_id=DP-MVP-5003835" target="_blank">official course</a> available. Although I think you could manage just fine with all the online material there is already. I mentioned quite a few in my last post. And new materials have already been added to that list, for example the newest course on PluralSight, called <a href="https://www.pluralsight.com/courses/optimize-enterprise-scale-data-models-dp-500?exp=2" target="_blank">Optimize Enterprise-scale Data Models - DP-500</a>, by friend and fellow MVP Nikola Ilic (<a href="https://twitter.com/DataMozart" target="_blank">@DataMozart</a>, <a href="https://data-mozart.com/" target="_blank">B</a>).</span></div><div><span style="font-size: medium;">But depending on the type of learner you are, you might do better with an in-class training, so it all depends... π<br /><br /></span><h1 style="text-align: left;">Never stop learning</h1></div><div style="text-align: left;"><span style="font-size: medium;">I honoustly did not think I passed the exam, because it covers quite a few topics I do not master yet, or haven't touched that often. </span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4Q6HlwgtRIL6W86GzMZ9PaSF7FF96Vxl4I90UDD5eL2R7TuSwDeSauL0woH10SlG129v1clrR3WHtdvxIl7MY9K2O2nM_-3KNUslEaFwdd_ULUk2Sj7-pIhWAoNSUqlYatwpkqQv8Vkx2W1bP2Ot4pwp4wUwNfHuwSHeFAjAGbo4hXIk-_MHvuCqD/s549/DP-500%20scorereport.png" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="185" data-original-width="549" height="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4Q6HlwgtRIL6W86GzMZ9PaSF7FF96Vxl4I90UDD5eL2R7TuSwDeSauL0woH10SlG129v1clrR3WHtdvxIl7MY9K2O2nM_-3KNUslEaFwdd_ULUk2Sj7-pIhWAoNSUqlYatwpkqQv8Vkx2W1bP2Ot4pwp4wUwNfHuwSHeFAjAGbo4hXIk-_MHvuCqD/w640-h216/DP-500%20scorereport.png" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">DP-500 Score report</td></tr></tbody></table><br /><span style="font-size: medium;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;">And according to the scoring report I received, I still have some things to do on the following topics:</span></div><div class="separator" style="clear: both; text-align: left;"><ul style="text-align: left;"><li><span style="font-size: medium;">Query and transform data (mainly Synapse questions for me I <strike>think</strike> hope π)<br />This part of the exam covers:</span></li><ul><li><span style="font-size: medium;">Query data by using Azure Synapse Analytics</span></li><li><span style="font-size: medium;">Ingest and transform data by using Power BI</span></li></ul><li><span style="font-size: medium;">Explore and visualize data (also mainly Synapse, and some R/Python in Power BI probably)<br />This part covers:</span></li><ul><li><span style="font-size: medium;">Explore data by using Azure Synapse Analytics</span></li><li><span style="font-size: medium;">Visualize data by using Power BI
</span></li></ul></ul><span style="font-size: medium;">You can check out the detailed outline and all the subtopics off the exam <a href="https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RWVbXM" target="_blank">here</a>.</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;"><br /></span></div><h1 style="text-align: left;">Renewed Certification</h1><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;">Last but not least, I also renewed my PL-300 certification (a.k.a. DA-100), the Power BI Data Analyst Associate. I got a notification that renewal was possible. It only took me 15-20 minutes, online behind my laptop. So no exam site or proctored exam room this time.</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;">I made it with 96% of the questions right, I missed (I think) 1 question in data modeling π</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSJnbmMY8hvgB3zBRcjq9zRMBVM1F19D0L5ys-fOzE28rfNgIQco1RFvJjnpilA1w_u48qVnQnuH7MoK_fsIqnHQqzkv7_vPeTK8-3xLYoLEAd_7zfgrKJ5onKv6jGim-S0jV1G2NrZLNabY9ATIfobobKI_3ZAdaPldH2BVv_SLqlOrt2kjX2hCTA/s972/PL-300%20renewed.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="736" data-original-width="972" height="485" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSJnbmMY8hvgB3zBRcjq9zRMBVM1F19D0L5ys-fOzE28rfNgIQco1RFvJjnpilA1w_u48qVnQnuH7MoK_fsIqnHQqzkv7_vPeTK8-3xLYoLEAd_7zfgrKJ5onKv6jGim-S0jV1G2NrZLNabY9ATIfobobKI_3ZAdaPldH2BVv_SLqlOrt2kjX2hCTA/w640-h485/PL-300%20renewed.png" width="640" /></a></div><br /><span style="font-size: medium;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;">Do you have any plans for exams? Did you get any certifications lately?</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-size: medium;">If you have any remarks and/or questions about one of these topics I mentioned, please let me know!</span></div></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-46556733701630742002022-06-24T23:45:00.005+02:002022-06-24T23:45:52.484+02:00Power BI Governance & Administration<p style="margin: 0in;">Today I'm writing a short post to try to get back into the habbit of writing. Because <a href="https://www.nickyvv.com/2021/12/finding-and-keeping-motivation-is-hard-you-are-not-alone.html">finding (and keeping) motivation can be hard</a>, you know. </p><p style="margin: 0in;">I've actually started writing several posts, but I either hit a wall, found other (short-term) inspiration to start another post, or just never finished it. </p><p style="margin: 0in;"><br /></p><p style="margin: 0in;">Now to the post of today. <span lang="" style="font-family: inherit;">I've worked as a Power BI Service (and Power Platform) Administrator quite a while. I started doing admin tasks when I was working for Van Lanschot Kempen, and now at <a href="https://www.nickyvv.com/2022/01/starting-new-adventure.html">Powerdobs</a> I'm often asked similar questions at clients. So I often run into things related to g</span><span lang="nl" style="font-family: inherit;">overnance and administration of Power BI and Power Platform environments.</span></p><p style="margin: 0in;"><span lang="nl" style="font-family: inherit;"><br /></span></p><p style="margin: 0in;"><span lang="nl" style="font-family: inherit;">Earlier, I already wrote quite a few posts around these topics:</span></p><p style="margin: 0in;"></p><ul><li><span lang="nl" style="font-family: inherit;"><a href="https://www.nickyvv.com/2020/04/installing-powershell-power-bi-management-cmdlets.html" target="_blank"><span style="font-family: inherit;">Installing the PowerShell Power BI Manageme</span>nt cmdlets</a><br /></span></li><ul><li><span lang="nl" style="font-family: inherit;">and how to use those cmdlets to <a href="https://www.nickyvv.com/2020/06/refresh-a-power-bi-dataset-with-powershell-and-a-service-principal.html" target="_blank">Refresh a Dataset with PowerShell</a></span></li></ul><li><span lang="nl" style="font-family: inherit;"><a href="https://www.nickyvv.com/2020/05/power-bi-governance-administration-organizational-visuals.html" target="_blank">How To Administer Organizational Visuals in Your Tenant</a></span></li><li><span><a href="https://www.nickyvv.com/2020/03/my-first-look-at-readwrite-xmla-endpoints-in-power-bi-premium.html">My First Look at Read/Write XMLA Endpoints in Power BI Premium</a> when that went in preview a while ago, which has gone <a href="https://powerbi.microsoft.com/en-us/blog/announcing-the-general-availability-of-read-write-xmla-endpoints-in-power-bi-premium/" target="_blank">GA</a> in January of last year</span></li><li><a href="https://www.nickyvv.com/2020/07/using-power-bi-rest-api-as-admin.html" target="_blank"><span style="font-family: inherit;">Using the Power BI REST API as Admin</span></a></li></ul><p></p><p style="margin: 0in;"><span lang="nl" style="font-family: inherit;"><br /></span></p><p style="margin: 0in;"><span lang="nl" style="font-family: inherit;">I plan on doing more of these posts, including the following topics:</span></p><ul><li><span style="font-family: inherit;">Power BI Premium</span></li><ul><li><span style="font-family: inherit;">New and/or interesting features</span></li><li><span style="font-family: inherit;">How to Monitor Power BI Premium</span></li></ul><li><span style="font-family: inherit;">Workspace and Gateway administration</span></li><ul><li>Managing data sources</li><li>Naming conventions</li></ul><li><span>Tenant settings</span></li><li><span style="font-family: inherit;">Power Platform environments for the Power BI Admin</span></li></ul><ul style="direction: ltr; margin-bottom: 0in; margin-left: 0.375in; margin-top: 0in; unicode-bidi: embed;" type="disc"><ul style="direction: ltr; margin-bottom: 0in; margin-left: 0.375in; margin-top: 0in; unicode-bidi: embed;" type="circle"></ul></ul><ul style="direction: ltr; margin-bottom: 0in; margin-left: 0.375in; margin-top: 0in; unicode-bidi: embed;" type="disc"></ul><p><span style="font-family: inherit;"><span>If you're interested in any of these or other related topics, please let me know.<br /></span></span><span style="font-family: inherit;">You can do that below in the comments or on </span><a href="https://www.twitter.com/NickyvV" style="font-family: inherit;" target="_blank">Twitter</a><span style="font-family: inherit;">!</span></p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com2tag:blogger.com,1999:blog-7149479726422748695.post-55489411189569137042022-05-09T13:37:00.001+02:002022-05-09T13:37:50.653+02:00Mastering The Role-based DP-500 Exam<p><span style="font-family: inherit;">In our world of data, I don't think we ever stop learning. In January 2021 I got both the <a href="https://docs.microsoft.com/en-us/learn/certifications/exams/da-100?WT.mc_id=DP-MVP-5003835" target="_blank">DA-100</a> (now <a href="https://docs.microsoft.com/en-us/learn/certifications/exams/pl-300?WT.mc_id=DP-MVP-5003835" target="_blank">PL-300</a>) and <a href="https://docs.microsoft.com/en-us/learn/certifications/exams/pl-900?WT.mc_id=DP-MVP-5003835" target="_blank">PL-900</a> certifications. But lately I've been busy learning again for a specific purpose. That purpose is the <a href="https://docs.microsoft.com/en-us/learn/certifications/exams/dp-500?WT.mc_id=DP-MVP-5003835" target="_blank">DP-500</a> exam, which I have scheduled to take for next week.<br /></span><span style="font-family: inherit;">In case you are wondering: DP-500, is that a new exam? Yes it is! </span><span style="font-family: inherit;">However, it's still in <a href="https://docs.microsoft.com/en-us/learn/certifications/beta-exams?WT.mc_id=DP-MVP-5003835" target="_blank">beta</a>. That doesn't have to be an issue, there are just a few things you need to be aware of.</span></p><p><span style="font-family: inherit;">First, you will not immediately get your score after you take the exam, these will only be calculated when it goes out of beta. The exam is still in beta because they want to gather feedback on the quality of the exam and the questions. They might need to fix questions, or improve the quality or accuracy based on the data and comments from the participants. Usually, the scores to the exam will be released <a href="https://docs.microsoft.com/en-us/learn/certifications/beta-exams?WT.mc_id=DP-MVP-5003835#beta-exam-scoring-and-results" target="_blank">10 business days</a> after the exam goes live.</span></p><p>Second<span style="font-family: inherit;">, the exam details page will list the skills measured, as well as a more detailed <a href="https://aka.ms/dp-500examguide" target="_blank">PDF</a>, but there are no preparation materials, like learning paths, modules or instructor-led training. However, our amazing Power BI community already got you covered for a large part, more on that later.</span></p><p>Next, a good thing: you mostly get a nice discount to beta exams, if you act in time that is π. On April 19th, a post went out on the <a href="https://techcommunity.microsoft.com/t5/microsoft-learn-blog/exam-dp-500-beta-prove-your-skills-as-an-azure-enterprise-data/ba-p/3279435?WT.mc_id=DP-MVP-5003835" target="_blank">Tech Community site</a> announcing the new exam and a discount code for the first 300 people scheduling it.</p><h1 style="text-align: left;">Azure Enterprise Data Analyst Associate</h1><p>Now onto the exam, its full name is: <b>Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI</b>.</p><p>Let that sink in for a while. Designing, implementing, an enterprise-scale solution, with Azure and Power BI. That means it will cover the following products/services:</p><p></p><ul style="text-align: left;"><li>Microsoft Power BI, including some external tools</li><li>Microsoft Purview (a.k.a. <a href="https://azure.microsoft.com/en-us/blog/azure-purview-is-now-microsoft-purview/?WT.mc_id=DP-MVP-5003835" target="_blank">Azure Purview</a>)</li><li>Azure Synapse Analytics</li><li>Azure Data Lake Gen2</li><li>DevOps</li></ul><p></p><p>This exam is required for the new <a href="https://docs.microsoft.com/en-us/learn/certifications/azure-enterprise-data-analyst-associate/?WT.mc_id=DP-MVP-5003835" target="_blank"><span style="font-family: inherit;">Microsoft Certified: Azure Enterprise Data Analyst Associate</span></a> certification.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigF5vPfU_BSIi-e1WkQNnY794B8gpG0XdQiGs9HNGqVn-TYUjlrt64Rc7DChHBUVw71PVI0dLI6JGAp4QVWRQ2h5qCk5b3yCw3eQbS_37hwvFBn30DpXWJJy9A2Knf5t8B5dFRfa3iv9dZnT0NhYztnk3-6_VRiuJMETOSb15vm_GAPL3Kc1wTTC6K/s629/dp500%20exam.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="166" data-original-width="629" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigF5vPfU_BSIi-e1WkQNnY794B8gpG0XdQiGs9HNGqVn-TYUjlrt64Rc7DChHBUVw71PVI0dLI6JGAp4QVWRQ2h5qCk5b3yCw3eQbS_37hwvFBn30DpXWJJy9A2Knf5t8B5dFRfa3iv9dZnT0NhYztnk3-6_VRiuJMETOSb15vm_GAPL3Kc1wTTC6K/s16000/dp500%20exam.png" /></a></div>Are you interested to know where this certification/exam fits into the bigger picture, or are you interested in other certifications? Have a look at the <a href="https://aka.ms/traincertposter" target="_blank">Microsoft Certification poster</a>.<p></p><h1 style="text-align: left;">Skills measured</h1><p><span style="font-family: inherit;">This is the overview of the skills measured, you can download a detailed PDF <a href="https://aka.ms/dp-500examguide" target="_blank">here</a>.</span></p><p></p><ul style="text-align: left;"><li>Implement and manage a data analytics environment (25β30%)</li><li>Query and transform data (20β25%)</li><li>Implement and manage data models (25β30%)</li><li>Explore and visualize data (20β25%)</li></ul><div>I'm not going into more detail, because Andy Cutler and Nikola Ilic teamed up and did a great job already: <a href="https://www.serverlesssql.com/certification/new-certification-microsoft-certified-azure-enterprise-data-analyst-associate/" target="_blank">New Certification: Microsoft Certified Azure Enterprise Data Analyst Associate</a>.</div><div>He also lists resources for studying for every subject in the skills measured section.</div><p></p><p></p><h1 style="text-align: left;"><span style="font-family: inherit;">Resources for studying</span></h1><p><span style="font-family: inherit;">Next to the <a href="https://www.serverlesssql.com/certification/new-certification-microsoft-certified-azure-enterprise-data-analyst-associate/" target="_blank">curated page</a> by Andy, I find the below resources to be very helpful during my learning journey:</span></p><p></p><ul style="text-align: left;"><li><span style="font-family: inherit;">Nikola Ilic (<a href="https://twitter.com/DataMozart" target="_blank">@DataMozart</a>) has some <a href="https://data-mozart.com/dp-500-certification/" target="_blank">great posts</a> already on his blog, more are added every week</span></li><li>Andy Cutler (<a href="https://twitter.com/MrAndyCutler" target="_blank">@MrAndyCutler</a>) has a <a href="https://www.youtube.com/c/DatahaiBI" target="_blank">YouTube channel</a> and a <a href="https://www.serverlesssql.com/blog/" target="_blank">blog</a></li><li>Andy and Nikola are also doing a session at <a href="https://www.dataweekender.com/schedule" target="_blank">Dataweekender</a> covering the skills needed for this exam: <b>The Essential Guide to the new Azure Enterprise Data Analyst Associate Certification</b></li><li><span style="font-family: inherit;">Wolfgang Strasser (<a href="http://twitter.com/wstrasser" style="background: rgb(255, 255, 255); border: 0px; color: #0066cc; font-size: 16px; margin: 0px; padding: 0px; vertical-align: baseline;" title="@wstrasser">@wstrasser</a>) has a section on <a href="https://workingondata.wordpress.com/category/azure-purview/" target="_blank">Purview on his blog</a></span></li><li><span style="font-family: inherit;">Erwin de Kreuk (<a href="https://twitter.com/ErwindeKreuk" target="_blank">@ErwindeKreuk</a>) also has great content on <a href="https://erwindekreuk.com/" target="_blank">Purview and Synapse</a></span></li><li><span style="font-family: inherit;"><a href="https://docs.microsoft.com/en-us/learn/browse/?expanded=azure%2Cpower-platform&products=azure-purview%2Cazure-synapse-analytics%2Cpower-bi%2Cpower-query&WT.mc_id=DP-MVP-5003835" target="_blank">MS Learn content</a> around the skills and products</span></li><ul><li><span style="font-family: inherit;">I created my own <a href="https://docs.microsoft.com/en-us/users/nickyvanvroenhoven-0908/collections/2xrnbor1e85zgq?WT.mc_id=DP-MVP-5003835" target="_blank">DP-500 collection</a></span></li></ul></ul><div><br /></div><div>Are you interested in taking this exam, or maybe you already took it?</div><div>What do you think of it and would it be a good fit for you?</div><div>Let me know if you have any questions or comments.</div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com1tag:blogger.com,1999:blog-7149479726422748695.post-3842012567423095572022-03-29T12:10:00.002+02:002022-03-30T14:27:12.521+02:00Conferences and Speaking<p>It's a busy time, but there is also lots of fun stuff happening! Besides my move to <a href="https://www.nickyvv.com/2022/01/starting-new-adventure.html" target="">Powerdobs</a> earlier this year, there are also several interesting conferences that caught my attention! Let me tell you about them.</p><h1 style="text-align: left;">SQLBits</h1><p>For starters, at the beginning of this month there was SQLBits, were I (virtually) presented a session called Power Platform Better Together: Create a Scoring App with a Live Dashboard.<br />In this session I showed how to use Power BI, Power Automate and Power Apps to create an interactive application. While I loved to be there in-person, I made the decision earlier this year to present virtual due to all the uncertainty back then. Although I do regret it after seeing all the excitement on social media, I still have some travel plans to other conferences this year.</p><p>If you don't know SQLBits, it's probably the greatest Data conference in Europe, spanning a whopping 5 days, including the free community event Saturday.</p><p>Here's a few stats from the conference this year:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjnuVNgL97qAXgxY4GQ-4t3Quz1mt9HO--9-rmJEn4fGrhXybk9V0pSbdXMRhsRNuBPcrRBq35FKEklzX2vvD7ExMxTOvF3pjhJBw10alIaCu8wc3DrfMR_8Bf4tEYVLu2azbuLg8n9cDgIL2f-xxkIZVd0XN2qAJ5Odhyc116_FZZzUp2wb0GkRl5l" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Thank you for attending SQLBits 2022, see you next year! It shows 3 arcade-like pictures of puppets (like Mario and Sonic)." data-original-height="900" data-original-width="1600" height="180" src="https://blogger.googleusercontent.com/img/a/AVvXsEjnuVNgL97qAXgxY4GQ-4t3Quz1mt9HO--9-rmJEn4fGrhXybk9V0pSbdXMRhsRNuBPcrRBq35FKEklzX2vvD7ExMxTOvF3pjhJBw10alIaCu8wc3DrfMR_8Bf4tEYVLu2azbuLg8n9cDgIL2f-xxkIZVd0XN2qAJ5Odhyc116_FZZzUp2wb0GkRl5l=w320-h180" width="320" /></a></div><p></p><ul style="text-align: left;"><li>Over 450 hours of training delivered</li><li>232 speakers, over 25% of whom identify as diverse in our industry</li><li>67 helpers</li><li>Over 1600 attendees Tue-Fri, with almost 2/3 in-person</li><li>Plus another 900 registrations for the free Saturday</li><li>Attendees from 38 countries</li><li>Over Β£8K raised for Ukraine, in support of two Ukrainian speakers and a Ukrainian helper</li></ul><div>Session recordings are still being worked on and will become available for registered attendees. But, in case you missed out, slides are already available at their <a href="https://arcade.sqlbits.com/session-list/" target="_blank">website</a>.</div><div><br /></div><p></p><h1 style="text-align: left;">Power BI Global Summit</h1><div>I bet the Power BI Summit is known you all, it is the biggest Power BI conference in the world. A multi-day event with speakers from the Microsoft Power BI teamβs product group, community experts and MVPs from all around the world. This time I had the honor of hosting a Table Talk around the topic of <b>Power BI Service Administration and beyond</b> at the Global Power BI Summit, with my friends Tom Martens ( <a href="https://www.minceddata.info/" target="_blank">B</a> | <a href="https://twitter.com/tommartens68" target="_blank">@tommartens68</a>), Ε tΔpΓ‘n ReΕ‘l ( <a href="http://www.jaknapowerbi.cz/" target="_blank">B</a> | <a href="https://twitter.com/tpnRel1" target="_blank">@tpnRel1</a>) and Benni De Jagere ( <a href="https://bennidejagere.com/" target="_blank">B</a> | <a href="https://twitter.com/BenniDeJagere" target="_blank">@BenniDeJagere</a>). We actually did it twice that day, in the morning and the evening, to accommodate all time zones across the world.</div><div>There was a lot of interaction, people asking questions in chat but also coming on camera for a live chat. We even got some people answering questions from time to time, which is great for the engagement. And that way I also learned some new things!</div><div><br /></div><h1 style="text-align: left;">MVP Summit</h1><div>Although every conference has its perks, I am pretty sure this is the one I'm most excited about!</div><div>As a <a href="https://mvp.microsoft.com/" target="_blank">Microsoft Most Valuable Professional</a>, you are eligible to attend the <a href="https://mvp.microsoft.com/en-US/Summit" target="_blank">MVP Global Summit</a> once a year, The event features a large catalog of in-depth technical discussions and feedback sessions, directly with the Microsoft product teams and engineers.</div><div><blockquote><i>The MVP Award is a global program of recognized technology experts and community leaders who actively support technical communities through unique, innovative, and consistent knowledge sharing. These community leaders actively contribute to support the developer and IT Pro communities worldwide, helping them learn, build, and use our products.</i></blockquote><p>My expectations are high! There will be a lot of demonstrations of functions and features that are not yet publicly available. Of course there are strict Non-disclosure agreements on all sessions on the MVP Summit, but that won't spoil the fun.</p><p>Due to the fact that the world is still not 100% back to normal, this year the Summit is still virtual, so the organizers are trying to accommodate all time zones. Most sessions are roughly from 4 PM until 5 AM here in Europe, so that's going to be a tough three days ahead... π΄</p><p><br /></p></div><h1 style="text-align: left;">Power BI Gebruikersdag</h1><p>Last but not least, this week also marks the start of the famous annual Dutch Power BI User Day: <a href="https://pbig.nl/" target="_blank">Power BI Gebruikersdag</a>. Itβs a great community event with lot's of local attendees and speakers.</p><p>You can have a look at a recap of one of the earlier conferences:</p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="337" src="https://www.youtube.com/embed/7p9-M_eI79E" width="405" youtube-src-id="7p9-M_eI79E"></iframe></div><br /><p>The association behind this user day has had a major overhaul, with 4 new board members, so I'm excited to see what they have been up to!</p><p>I'm also delighted to be presenting 2 sessions there:</p><p></p><ul style="text-align: left;"><li>A (big) look into Query Folding on Deep Dive Friday! I've done Query Folding before, but this is a 2-hour long session going into (all) the depths! π</li><li>Write-back with Power Apps in Power BI on Saturday, which is a new session, showing off how to use Power Apps inside Power BI to edit data in the backend.</li></ul><p></p><p>Check the full <a href="https://pbig.nl/programma/" target="_blank">schedule</a> for all the sessions!</p><p><br /></p><h1 style="text-align: left;">Closing</h1><p>My very last point then, because in June I'll also be attending and speaking at <a href="https://datagrillen.com/" target="_blank">DataGrillen</a>, the only conference (I know of) that has Data, Bratwurst and Beer. π But more about that later.</p><p>For everyone attending one of the conferences above, please come and say hi, ask a question, tell a story or just grab a drink and hang out! π</p><p><br /></p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-31822651078180168002022-02-23T21:27:00.003+01:002022-02-23T21:28:21.476+01:00My Favorite Power BI Desktop February 2022 New Features<p>Last week it was that time of the month again! No not that time.<br />I mean time for the <a href="https://powerbi.microsoft.com/en-us/blog/power-bi-february-2022-feature-summary/" target="_blank">Power BI February 2022 Feature Summary</a> blog post by Jeroen ter Heerdt of course.</p><h1 style="text-align: left;">Dynamic M Query Parameters</h1><p>The new thing is that dynamic M Query Parameters now supports SQL Server (and more data sources). There are several use cases that come to mind and a few people have already blogged about this:</p><p></p><ul><li>Teo Lachev (<a href="https://twitter.com/tlachev" target="_blank">@tlachev</a>) talks about calling a <a href="https://prologika.com/power-bi-dynamic-m-query-parameters-reloaded/" target="_blank">Stored Procedure with a parameter</a>, and the requirements you need to meet and consider to pull this off</li><li>Chris Webb (<a href="https://twitter.com/cwebb_bi" target="_blank">@cwebb_bi</a>) has a <a href="https://blog.crossjoin.co.uk/2022/02/20/tsql-table-valued-functions-and-dynamic-m-parameters-in-power-bi-directquery/" target="_blank">similar approach</a>, but uses a T-SQL Table-Valued Function with 2 parameters</li></ul><div>The high level steps to dynamic M query parameters are:</div><ul><li>The source (SP/TVF) has to be in DirectQuery mode</li><li>Create a parameter(s) in PQ</li><li>In the model view, bind that parameter(s) to the column in your datamodel</li><li>And then use the parameter(s) in your source in PQ</li></ul><div>If you want to read up on all the features, supported datasources, limitations and risks, go read the documentation on how to <a href="https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters?WT.mc_id=DP-MVP-5003835" target="_blank">use dynamic M query parameters</a>.</div><div><br /></div><div><h1 style="background-color: white; box-sizing: inherit; font-family: "Segoe UI Condensed", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 30px; line-height: 1.18; margin: 0px 0px 12px; text-align: left;">New mobile formatting options</h1></div><div>If you're into mobile formatting for Power BI, you're going to love <a href="https://powerbi.microsoft.com/en-us/blog/create-stunning-mobile-optimized-power-bi-reports-with-mobile-layouts-new-visual-formatting-pane-preview/" target="_blank">this update</a>. There's a lot more you can configure, now also independently from the web version.</div><div>To enable the new mobile formatting pane, the blog post says you'll have to enable the preview feature under Options, but after my installation of the February update it was already enabled:</div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><br /><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiT19LXIaosd2_9ABj0D1UX0HaN-PKDmJa8cnKelzTiuxDPca2f8mOTZipRLdnfPEi-FicpOE1L5JjK9vvhL9ghmBfCnR19zUtxaoFDiOeyeQR40yxuEylLUfHu2o66OaXb1MBa9fh3Ui2lIocTEsgVe4GfpBfYHSpzjq8k0Dr-G4lyo3g8B8fKILq1=s334" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="123" data-original-width="334" src="https://blogger.googleusercontent.com/img/a/AVvXsEiT19LXIaosd2_9ABj0D1UX0HaN-PKDmJa8cnKelzTiuxDPca2f8mOTZipRLdnfPEi-FicpOE1L5JjK9vvhL9ghmBfCnR19zUtxaoFDiOeyeQR40yxuEylLUfHu2o66OaXb1MBa9fh3Ui2lIocTEsgVe4GfpBfYHSpzjq8k0Dr-G4lyo3g8B8fKILq1=s16000" /></a></div><h1 style="clear: both; text-align: left;">And more...</h1><div class="separator" style="clear: both; text-align: left;">Of course there's a lot more in the <a href="https://powerbi.microsoft.com/en-us/blog/power-bi-february-2022-feature-summary/" target="_blank">February update</a>, to mention a few:</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">If you haven't started using <b>Goals</b>, there are more updates to it, including:</div><div class="separator" style="clear: both; text-align: left;"><ul style="text-align: left;"><li>Teams notifications integration,</li><li>Multiple owners for a single goal and </li><li>The ability to create scorecards in <i>My Workspace</i></li></ul><b>Deployment Pipelines </b><a href="https://powerbi.microsoft.com/en-us/blog/deployment-pipelines-azure-devops-extension-multiple-pipelines-working-together-dataflows-ga/" target="_blank">enhancements</a>: there's a (fairly) new Azure DevOps extension and multiple pipelines working together, for example for disconnected reports and datasets</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><b>Download .pbix improvements</b>: starting with this release you can download a .pbix file in more scenario's. Specifically, if a report is connected to a dataset that is configured for large models, incremental refresh or has been modified using the XMLA endpoint, you are now able to download that (connected) report, so not the dataset itself π<ul style="text-align: left;"><ul></ul></ul><ul style="text-align: left;"><ul></ul></ul></div>Read up on all the gotcha's and limitations of this <a href="https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix?WT.mc_id=DP-MVP-5003835" target="_blank">export to PBIX</a>.</div><div><br /></div><div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEifpQKC94KaDEOKKEhbm8QZkJfVnvD8c0VC4YShG2aCabqdeOI9DquJKk0X1ncq1KjFKDxsCXeqHtlOMsZQUwhtSRwNXelXW7CHuPT_1D9S-OqagDq4wLLlYVqAqQQ0Me0hyeOvm6GYbNjpiSbH3MIiy1aMkzyCpQViWhBvbOKZUFY2Hykwodu0txD4=s1920" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1280" data-original-width="1920" height="267" src="https://blogger.googleusercontent.com/img/a/AVvXsEifpQKC94KaDEOKKEhbm8QZkJfVnvD8c0VC4YShG2aCabqdeOI9DquJKk0X1ncq1KjFKDxsCXeqHtlOMsZQUwhtSRwNXelXW7CHuPT_1D9S-OqagDq4wLLlYVqAqQQ0Me0hyeOvm6GYbNjpiSbH3MIiy1aMkzyCpQViWhBvbOKZUFY2Hykwodu0txD4=w400-h267" width="400" /></a></div></div><div style="text-align: center;">Now go <a href="https://powerbi.microsoft.com/desktop?WT.mc_id=Blog_Desktop_Update" target="_blank">download</a> that new update and check it out ourself! π</div><div><br /></div><div><br /></div><div></div><p></p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-52419430061160836812022-02-10T10:04:00.001+01:002022-02-10T10:04:53.880+01:00Book Review: Expert Data Modeling with Power BI<p>Somewhere last year I started reading this book on Power BI. It actually took me quite a while to finish it, because of [reasons]. π<br />But now that I finally finished it, I thought it would be good to write a short review on my thougths about the book, so you know if it is worth your time and money.</p><p>The book is from fellow-MVP Soheil Bakhshi (<a href="https://twitter.com/biinsightnz" target="_blank">@biinsightnz</a> | <a href="https://www.biinsight.com/" target="_blank">B</a>) called <a href="https://amzn.to/3IYiSJG" target="_blank">Expert Data Modeling with Power BI</a>. </p><p></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEih5uSH90iUFyWR-nHaFONMrF7m4VGvo6eTnIH3Uymmgk3UQmsN2n4CCX8QM9EMjaE2X5cYvqFUcFDyWImYPPVNJei-0Jih8_Ll9k_xknt4uTDJ1gjH10NF9U-yC93nuMSxE5gX9MWPOPvzvsYH78sH9x_OPvocI-z6RsVzuXxArThzpwriji-7CPRv" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="571" data-original-width="516" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEih5uSH90iUFyWR-nHaFONMrF7m4VGvo6eTnIH3Uymmgk3UQmsN2n4CCX8QM9EMjaE2X5cYvqFUcFDyWImYPPVNJei-0Jih8_Ll9k_xknt4uTDJ1gjH10NF9U-yC93nuMSxE5gX9MWPOPvzvsYH78sH9x_OPvocI-z6RsVzuXxArThzpwriji-7CPRv=w361-h400" width="361" /></a></div><br /><div style="text-align: left;"><h1>TL;DR</h1><p>Yes, it is definitely worth it! π</p><h1 style="text-align: left;">The long version</h1></div></div>I think the combination of good, practical examples and in-depth coverage of (Power BI) features is the best about this book. You can also follow along with the step-by-step examples, as I think going hands-on is the best way of learning things. With reading you can only pick up so much knowledge, while putting it in practice right away enriches the learning experience much more.<div>Next to that, the book is also filled with best practices for data preparation as well as data modeling.<p>Soheil is not afraid of touching upon and explaining more advanced and complex topics, like:</p><p></p><ul style="text-align: left;"><li>Incremental refresh</li><li>Calculation groups</li><li>Aggregations</li><li>The <i>new</i> composite models</li><li>Slowly changing dimensions</li></ul><p></p><p>One point of critique if you will: sometimes I felt that adding color to an image in the book, could get the message across better. But I also get that this makes the pages more crowded, and probably also more expensive, and is not the way Packt publishes their books π</p><p>All in all I very much enjoyed reading this book! And I definitely learned a lot.<br />I think I knew, or at least have heard of, all the features that were explained in the book. But if you've never used/implemented RLS you don't really know what you're up against. The same goes for aggregations or calculation groups for example. So reading up on those features with good examples has definitely enriched my knowledge.</p><p>I've already started reading my next book, so stay tuned for another review!</p></div>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0tag:blogger.com,1999:blog-7149479726422748695.post-66425358724494088912022-01-31T22:27:00.000+01:002022-01-31T22:27:05.916+01:00Starting A New Adventure<p></p><h1 style="clear: both; text-align: left;">Van Lanschot Kempen</h1><div class="separator" style="clear: both; text-align: left;">Last Thursday I had my last day working at Van Lanschot Kempen (VLK), where I worked roughly 4 years. I did great things and also had a great time.</div><div class="separator" style="clear: both; text-align: left;">Amongst others, I...</div><div class="separator" style="clear: both; text-align: left;"><ul style="text-align: left;"><li>...had a great time working with my colleagues, especially our <a href="https://twitter.com/NickyvV/status/1486760302674907145" target="_blank">coffee moments</a> walking to the 12th floor!</li><li>...started getting more and more involved with Power BI inside VLK</li><li>...organized a <a href="https://www.nickyvv.com/2019/01/19th-power-bi-ug-netherlands-november.html" target="">Power BI meeting at our office</a> together with <a href="https://pbig.nl/events/dutch-data-dude-farewell-tour/#description_hook" target="_blank">PBIG</a>, and did an intro into what VLK is doing at the data and Power BI level together with <a href="https://twitter.com/jeroenschalken" target="_blank">@JeroenSchalken</a></li><li>...started a running club with my department, which lasted roughly for a year π</li><li>...started speaking (with Jeroen) at <a href="https://sessionize.com/power-bi-gebruikersdag-2019/" target="_blank">PBIG 2019</a> with an extended version of our intro talk</li><li>...went to <a href="https://www.nickyvv.com/2019/09/speaking-at-sql-saturday-prague-2019.html">Prague</a> (with Jeroen), <a href="https://www.nickyvv.com/2019/10/speaking-at-dataminds-connect-in-belgium.html">Mechelen</a>, Dublin, Mechelen again π, and then everything went virtual...</li><li>...got a promotion to Lead Expert within VLK</li><li>...started going physical again to <a href="https://www.nickyvv.com/2021/09/back-in-business-power-bi-next-step.html">Copenhagen</a>! Hopefully this will be the new norm again in 2022</li><li>And even received my MVP award!</li></ul><div>How I enjoyed that trip! Thank you everyone who contributed to this time! π</div><div><br /></div></div><h1 style="clear: both; text-align: left;">Powerdobs</h1><div class="separator" style="clear: both; text-align: left;">Tomorrow will be the start of a new trip, together with my colleagues at <a href="https://powerdobs.nl" target="_blank">Powerdobs</a>. It's a small consultancy firm located in Den Bosch (Netherlands), focused on delivering solutions through quality, craftsmanship, long-term relationships and being sober and caring.</div><div class="separator" style="clear: both; text-align: left;">As the Unit Lead Power BI I'll be responsible for taking Power BI to the next level, both internally and externally. So expect to find me writing more blogs and doing more presentations!</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">Will the road<span style="font-family: inherit;"> ahead be straight and paved? I doubt that.</span> There'll be enough bends, sidetracks and obstacles and bumps. That's where others pick me up. That's where I learn and come back stronger. </div><div class="separator" style="clear: both; text-align: left;">And it will for sure be a great adventure!</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgNmhVOoWG5W5Rt8qJp3tW69NYNHYIEWm__1i9ylGmnvLjZ4GB2FRjGxgid7gv5r0T25KS_K41rmcR_4elxPgDoG66ZVohmeX3Pdsim4Hn_GepHVKHRev-iINeNYHHBYsXGunkzg7tSITvNzOr_rbpNmi4rIZ6vl8RiS24eT2yjcd4lRd_Wjh6SOiqn=s1920" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1280" data-original-width="1920" height="427" src="https://blogger.googleusercontent.com/img/a/AVvXsEgNmhVOoWG5W5Rt8qJp3tW69NYNHYIEWm__1i9ylGmnvLjZ4GB2FRjGxgid7gv5r0T25KS_K41rmcR_4elxPgDoG66ZVohmeX3Pdsim4Hn_GepHVKHRev-iINeNYHHBYsXGunkzg7tSITvNzOr_rbpNmi4rIZ6vl8RiS24eT2yjcd4lRd_Wjh6SOiqn=w640-h427" width="640" /></a></div><br /><p></p>Nicky van Vroenhovenhttp://www.blogger.com/profile/18287588824535462833noreply@blogger.com0