Installation:<\/p>\n
Download and install the preview from Microsoft Download Center<\/a><\/p>\n Once the feature is installed open Excel and go to File, Options, Add-Ins. Select COM Add-Ins and click Go.<\/p>\n Now that we have Data Explorer installed and enabled we can get to the fun stuff.<\/p>\n To see a detailed list of each element you can visit Microsoft Data Explorer Help<\/a><\/p>\n If you click on the Data Explorer tab you will notice Get External Data. Just like Excel and PowerPivot, this is where our data source will come from. There are multiple data sources to choose from including websites, files, databases, Active Directory, and even Facebook. Yes….Facebook.<\/p>\n In this tip, I’ll show you examples of two data sources. We’ll pull data from a website and create a map report using PowerView and we’ll pull data from Facebook and make a report using PowerPivot.<\/p>\n In the first example, I’ll pull table data from the web using Wikipedia. Choose “From Web” from the Get External Data section and use the following URL:http:\/\/en.wikipedia.org\/wiki\/List_of_countries_by_population<\/a><\/p>\n Click OK<\/p>\n In the Query Editor under Navigator, select Countries. This will display rank, country, population, date, % of world population and source. We can filter columns just like in Excel by selecting the header arrow and choosing the appropriate filter. In this example, we’ll filter Source to only includes records that are an official estimate.<\/p>\n In this post, I’ll discuss the prerequisites and how to install and enable Power Query (Data Explorer) and I’ll show you how to use this new feature. Prerequisites: Requires Microsoft Office 2010 SP1 or Microsoft Excel 2013 32-bit or 64-bit Requires Windows Vista (with .Net 3.5 SP1 or greater), Windows Server 2008 (with .Net 3.5 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,71],"tags":[35,106,59,66,72,111],"class_list":["post-304","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-power-query","tag-bi","tag-business-intelligence","tag-development","tag-excel","tag-facebook","tag-power-query"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=304"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/304\/revisions"}],"predecessor-version":[{"id":311,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/304\/revisions\/311"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"SQL](\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Query.png\")
<\/a>
\nCheck Microsoft “Data Explorer” Preview for Excel and click OK.
\n![\"SQL](\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Query-1.png\")
<\/a>
\nOnce Data Explorer has been enabled, the tab will appear above the Office ribbon.<\/p>\n![\"SQL](\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Query-2.png\")
<\/a><\/p>\n![\"SQL](\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Query-3.png\")
<\/a><\/p>\nWeb Data Source<\/h3>\n
![\"SQL](\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Query-4.png\")
\n<\/a><\/p>\n![\"SQL](\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Power-Query-5.png\")
\n<\/a>Click here to view the rest of this post.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"