{"id":5355,"date":"2017-03-10T12:00:18","date_gmt":"2017-03-10T17:00:18","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/azuregov\/?p=5355"},"modified":"2017-03-10T12:00:18","modified_gmt":"2017-03-10T17:00:18","slug":"building-a-solution-on-azure-government-part-iii-power-bi","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azuregov\/building-a-solution-on-azure-government-part-iii-power-bi\/","title":{"rendered":"Building a solution on Azure Government Part III: Power BI"},"content":{"rendered":"

Now that we\u2019ve done our text analysis using HDInsight<\/a>, let\u2019s add some high-quality visualizations using Power BI for Azure Government. Let\u2019s first log into Power BI for Azure Gov<\/a>. Here we are presented with our initial options. Let\u2019s connect to a database by clicking the \u201cGet\u201d button in the \u201cDatabase\u201d tile:<\/p>\n

\"1\"<\/a><\/p>\n

In the next screen, we can see that we have an option for Spark on Azure HDInsight:<\/p>\n

\"2\"<\/a><\/p>\n

Once we select Spark, we need to specify the server we want to connect to (we can get this value directly from the URL for the HDInsight cluster in the Azure Government portal):<\/p>\n

\"3\"<\/a><\/p>\n

We use the credentials we setup during provisioning to connect. Once we\u2019re connected, we\u2019ll see a new Spark tile in our Dashboard. We can click on this to configure and provide visualizations:<\/p>\n

\"4\"<\/a><\/p>\n

We\u2019ll see an empty design surface, as well as the \u201cTopResults\u201d table that we created when we were in the Jupyter notebook in HDInsight:<\/p>\n

\"5\"<\/a><\/p>\n

There are a number of visualizations in Power BI that we might use to display our data. Let\u2019s bring in a custom visualization \u2013 the Word Cloud Power BI Visualization<\/a>. We\u2019ll follow the standard steps to import a custom visual and click to add it to the design surface. We\u2019ll also select the \u201ccount\u201d and \u201cword\u201d columns in our \u201cTopResults\u201d data source. This will give us our preliminary visualization:<\/p>\n

\"6\"<\/a><\/u><\/strong><\/p>\n

Our visualization looks good. However, the words that are showing up most frequently are \u201cfiller\u201d words such as \u201cthe\u201d, \u201cto\u201d, \u201cand\u201d, etc. Let\u2019s filter these out by turning on the default \u201cStop Words\u201d in Power BI:<\/p>\n

\"7\"<\/a><\/p>\n

Now our visualization is yielding interesting results! We can clearly see that the word \u201cenemy\u201d shows up more than any other word in the book!<\/p>\n

Summary<\/h2>\n

This walkthrough is just one example of the power that Azure Government can unleash for your organization. The services in Azure Government, while powerful individually, can be seamlessly combined to create even more compelling solutions!<\/p>\n

We welcome your comments and suggestions to help us continually\u00a0improve your Azure Government experience. To stay up to date on all things Azure Government, be sure to subscribe to our RSS feed<\/a> and to receive emails, click \u201cSubscribe by Email!\u201d on the Azure Government Blog<\/a>. To experience the power of Azure Government for your organization, sign up for an Azure Government Trial<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Now that we\u2019ve done our text analysis using HDInsight, let\u2019s add some high-quality visualizations using Power BI for Azure Government. Let\u2019s first log into Power BI for Azure Gov. Here we are presented with our initial options. Let\u2019s connect to a database by clicking the \u201cGet\u201d button in the \u201cDatabase\u201d tile: In the next screen, […]<\/p>\n","protected":false},"author":1789,"featured_media":4625,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[25],"tags":[95,188,327,457],"class_list":["post-5355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portalpreview","tag-azure-government","tag-cognitive-services","tag-hdinnsight","tag-power-bi"],"acf":[],"blog_post_summary":"

Now that we\u2019ve done our text analysis using HDInsight, let\u2019s add some high-quality visualizations using Power BI for Azure Government. Let\u2019s first log into Power BI for Azure Gov. Here we are presented with our initial options. Let\u2019s connect to a database by clicking the \u201cGet\u201d button in the \u201cDatabase\u201d tile: In the next screen, […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/5355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/users\/1789"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/comments?post=5355"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/5355\/revisions"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media?parent=5355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/categories?post=5355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/tags?post=5355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}