{"id":22530,"date":"2020-12-29T10:07:26","date_gmt":"2020-12-29T10:07:26","guid":{"rendered":"https:\/\/www.experfy.com\/blog\/hitchhikers-guide-azure-purview-power-bi-professionals\/"},"modified":"2023-09-13T13:21:27","modified_gmt":"2023-09-13T13:21:27","slug":"hitchhikers-guide-azure-purview-power-bi-professionals","status":"publish","type":"post","link":"https:\/\/www.experfy.com\/blog\/ai-ml\/hitchhikers-guide-azure-purview-power-bi-professionals\/","title":{"rendered":"Hitchhikers Guide To Azure Purview For Power BI Professionals"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Quick intro to the latest Microsoft data governance solution, and how it integrates with Power BI<\/p>\n\n

If you\u2019ve carefully followed the latest data news, you should have noticed that Microsoft made two important announcements a few weeks ago: the first, Azure Synapse Analytics<\/a> became GA, while the other also caused a lot of interest: by introducing Azure Purview as the evolution of Azure Data Catalog<\/a>, Microsoft proclaimed that this new solution will serve as a unified data governance and data management platform.<\/p>\n\n

At the moment of writing, Purview is still in preview, so we can expect that specific features will evolve over time, and that some new features will find their place under the Purview umbrella.<\/p>\n\n

As someone who spends most of my time working with Power BI, I was curious to explore how Purview looks from the perspective of a Power BI professional. So, here are my thoughts\u2026<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

Setting things up<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

For the starter, we need to create a Purview account within the Azure Subscription. If you get some errors while configuring Purview, don\u2019t be scared, it\u2019s completely fine (yeah, I know that you think I\u2019m crazy \u2014 how could the error be ok)\u2026<\/p>\n\n

But, in order for this to work, the EventHub service needs to be enabled in the first place. This way, Purview will be able to perform the scans of your data sources. So, let\u2019s go and register EventHub service:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"Hitchhikers\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

After successful registration of the EventHub service, you should be able to create a Purview account.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"Hitchhikers\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Now, before we start exploring our Power BI<\/a> resources in Purview, some additional configuration needs to be done on the Power BI tenant\u2019s side.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

Configuring Power BI Tenant<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

I will open my Power BI Admin portal<\/em>, and under Tenant settings<\/em>, find Developer settings<\/em> property. Here, you will find an Allow service principals to use Power BI APIs<\/em>, and you need to enable this option:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"Hitchhikers\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

I\u2019ve applied this to the entire organization, as this is my private Power BI tenant, but you should tend to follow the recommended option here, and apply access to specific groups only.<\/p>\n\n

Once this setting had been applied, I will navigate back to my Purview account and register my Power BI tenant within Purview:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"Hitchhikers\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

As soon as you click on Register, you will see a bunch of available sources. Since I want to register and scan my Power BI tenant, I will choose the Power BI icon:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"Power\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

I will specify the name for my Power BI service, and you should spot that Purview automatically discovered and populated your tenant\u2019s ID!<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"populated\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

And once I click on my newly created resource, I will be able to see some statistics based on scanning history. Since it is my first scan, there is nothing so far, so let\u2019s set inaugural scanning of the Power BI tenant:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"inaugural\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

In the next step, you can specify the schedule for your scans (recurring vs once). Additionally, for recurring scans, you are able to set the frequency that best suits your needs. This reminds me of a schedule set for SQL Agent Jobs (for those of you who are familiar with SQL Server, you would know what I\u2019m talking about:))<\/p>\n\n

As I just want to do some testing here, I will choose to scan my Power BI tenant only once:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"choose\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Once the scan is completed, I will go back to the Home tab of the Purview Studio and choose Browse Assets, and finally Power BI:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"Purview\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

From there, I can explore my Power BI assets in a whole bunch of different ways. In the first place, I see all of my reports, dashboards, and datasets listed and classified:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"my\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

My preferred way so far is Lineage mode, which gives me a nice visual overview of how different elements relate to each other within my Power BI workspace:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\"Power\t\t\t\t\t\t\t\t\t\t\t
Image by author<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

In the end, as you are probably aware, there is no free lunch! So, you\u2019re probably asking yourself how much would it cost to use Azure Purview. At the moment of writing, since the product is still in preview, some features are free to use, such as scanning and classification of Power BI Service and SQL Server on-prem.<\/p>\n\n

In any case, please refer to this official pricing list <\/a>for the Azure Purview.<\/p>\n\n

Thanks for reading!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

You should have noticed that Microsoft made two important announcements a few weeks ago: the first, Azure Synapse Analytics became GA, while the other also caused a lot of interest: by introducing Azure Purview as the evolution of Azure Data Catalog, Microsoft proclaimed that this new solution will serve as a unified data governance and data management platform.<\/p>\n","protected":false},"author":1003,"featured_media":17009,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[183],"tags":[1193,94,1063,836],"ppma_author":[3718],"class_list":["post-22530","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-ml","tag-azure-purview","tag-data-science","tag-microsoft-azure","tag-power-bi"],"authors":[{"term_id":3718,"user_id":1003,"is_guest":0,"slug":"nikola-ilic","display_name":"Nikola Ilic","avatar_url":"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/Nikola-Ilic-150x150.jpeg","user_url":"https:\/\/data-mozart.com\/","last_name":"Ilic","first_name":"Nikola","job_title":"","description":"Nikola Ilic is Business Intelligence Developer at ITSP Services GmbH and Pluralsight Author."}],"_links":{"self":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/users\/1003"}],"replies":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/comments?post=22530"}],"version-history":[{"count":4,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22530\/revisions"}],"predecessor-version":[{"id":32925,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22530\/revisions\/32925"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media\/17009"}],"wp:attachment":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media?parent=22530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/categories?post=22530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/tags?post=22530"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=22530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}