{"id":21793,"date":"2018-07-30T03:45:46","date_gmt":"2018-07-30T03:45:46","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=21793"},"modified":"2018-09-11T22:10:35","modified_gmt":"2018-09-11T16:40:35","slug":"connect-to-data-in-power-bi-desktop","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/","title":{"rendered":"Connect to Data in Power BI Desktop in 10 Min."},"content":{"rendered":"

1. Objective<\/h2>\n

In this Power BI tutorial<\/strong>,<\/a> we will learn about Interface with information in Power BI work area. Moreover, we will learn how to connect to data in Power BI Desktop<\/strong><\/a>.
\nSo, let’s start How to Connect to Data in Power BI.<\/p>\n

\"Connect<\/a>

Connect to data in Power BI Desktop in 10 Min.<\/p><\/div>\n

2.\u00a0Power BI Work Area<\/h2>\n

With Power BI Work area, you can without much of a stretch associated with the consistently extending universe of information. In the event that you don’t have Power BI Work area, you can download and introduce it.
\nDo you know the Integration of Power Bi and Excel – With Existing Dashboard<\/a><\/strong><\/p>\n

3. Connect to Data in Power BI Desktop<\/h2>\n

There is a wide range of information sources accessible in Power BI Work area. The accompanying picture demonstrates to associate with information, by choosing the Record strip, at that point Get Information > More<\/strong>.<\/p>\n

\"Connect<\/a>

Step -1 Connect to Data in Power BI Desktop<\/p><\/div>\n

For this illustration, we’ll interface with an Internet information source.
\nEnvision you’re resigning \u2013 you need to live where there’s heaps of daylight, ideal expenses, and great human services. Or then again\u2026 maybe you’re an information expert, and you need that data to help your clients \u2013 as in, help your waterproof shell producing customer target deals where it rains a considerable measure.
\nIn any case, you discover an Internet asset that has fascinating information about those subjects, and that’s only the tip of the iceberg:
\nhttp:\/\/www.bankrate.com\/fund\/retirement\/best-places-resign how-state-ranks.aspx<\/b>
\nYou select Get Information > Web and sort the address.<\/strong><\/p>\n

\"Connect<\/a>

Step – 2 Connect to Data in Power BI Desktop<\/p><\/div>\n

When you select alright, the Inquiry usefulness of Intensity BI Work area goes to work. Power BI Work area contacts the Internet asset, and the Guide window restores the aftereffects of what it found on that site page. For this situation, it found a (Table 0) and the General Report. We’re occupied with the table, so we select it from the rundown. The Guide window shows a review.
\nDo you know How to Download & Install Power Bi in 7 Simple Steps <\/a><\/strong><\/p>\n

\"Connect<\/a>

Step – 3 Connect to Data in Power BI Desktop<\/p><\/div>\n

Now we can alter the inquiry before stacking the table, by choosing Alter from the base of the window, or we can stack the table.
\nOn the off chance that we select Alter, the table stack and Question Editorial manager. The Inquiry Settings sheet is shown (if it’s not, you can choose View from the lace, at that point<\/strong> Show > Question Settings<\/strong> to show the Inquiry Settings sheet). This is what that resembles.<\/p>\n

\"Connect<\/a>

Step – 4 Connect to Data in Power BI Desktop<\/p><\/div>\n

Each one of those scores is content instead of numbers, and we require them to number. Forget about it \u2013 without flaw tap the section header, and select Change Write > Entire Number<\/strong> to transform them.
\nLet’s Read How to Create ArcGIS Maps For Power BI with ESRI<\/strong><\/a>
\nTo pick in excess of one section, first select a segment at that point hold down Move, select extra contiguous segments, and after that right-click a segment header to change every chosen segment. Utilize CTRL to pick sections that are not contiguous.<\/p>\n

\"Connect<\/a>

Step – 5 Connect to Data in Power BI Desktop<\/p><\/div>\n

In Inquiry Settings, the Connected Advances will mirror any progressions that were made. As you roll out extra improvements to the information, the Question Editorial manager will record those adjustments in the Connected Advances segment, which you can modify, return to, rework, or erase as essential.<\/p>\n

\"Connect<\/a>

Step – 6 Connect to Data in Power BI Desktop<\/p><\/div>\n

Extra changes to the table can, in any case, made after it’s stacked. However, for the present, this will do. When we’re set we select Close and Apply from the Home lace, and Power BI Work area applies our progressions and closes Inquiry Supervisor.<\/p>\n

\"Connect<\/a>

Step – 7 Connect to Data in Power BI Desktop<\/p><\/div>\n

Let’s explore\u00a0How to Create Power BI Funnel Charts (Custom Visuals)<\/strong>
\nWith the information shown stacked, in Report see in Power BI Work area, we can start making representations by hauling fields onto the canvas.<\/p>\n

\"Connect<\/a>

Step – 8 Connect to Data in Power BI Desktop<\/p><\/div>\n

Obviously, this is a basic model with a solitary information association; most Influence BI Work area reports will have associations with various information sources, formed to address your issues, with connections that create a rich information display.
\nSo, this was all about How to Connect to data in Power BI Desktop.<\/p>\n

4. Conclusion<\/h2>\n

Hence, in this Power BI tutorial, we learned How to Connect to data in Power BI Desktop. If you feel any query, ask in the comment section.
\nRelated Topic- Area Chart in Power BI<\/strong><\/a>
\nFor reference<\/strong><\/a>

1. Objective In this Power BI tutorial, we will learn about Interface with information in Power BI work area. Moreover, we will learn how to connect to data in Power BI Desktop. So, let’s...<\/p>\n","protected":false},"author":5,"featured_media":21814,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[2893,2900,3459,9878],"class_list":["post-21793","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-connect-to-data-in-power-bi-desktop","tag-connecting-to-data-in-power-bi-desktop","tag-data-source-connect-in-power-bi-desktop","tag-power-bi-work-area"],"yoast_head":"\nConnect to Data in Power BI Desktop in 10 Min. - DataFlair<\/title>\n<meta name=\"description\" content=\"How to Connect to data in Power BI Desktop, Power BI Work Area, Data Source Connect in Power BI Desktop, Steps to connect to Data In Power Bi Desktop\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect to Data in Power BI Desktop in 10 Min. - DataFlair\" \/>\n<meta property=\"og:description\" content=\"How to Connect to data in Power BI Desktop, Power BI Work Area, Data Source Connect in Power BI Desktop, Steps to connect to Data In Power Bi Desktop\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-30T03:45:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-11T16:40:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Connect-to-data-in-Power-BI-Desktop-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect to Data in Power BI Desktop in 10 Min. - DataFlair","description":"How to Connect to data in Power BI Desktop, Power BI Work Area, Data Source Connect in Power BI Desktop, Steps to connect to Data In Power Bi Desktop","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Connect to Data in Power BI Desktop in 10 Min. - DataFlair","og_description":"How to Connect to data in Power BI Desktop, Power BI Work Area, Data Source Connect in Power BI Desktop, Steps to connect to Data In Power Bi Desktop","og_url":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-07-30T03:45:46+00:00","article_modified_time":"2018-09-11T16:40:35+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Connect-to-data-in-Power-BI-Desktop-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Connect to Data in Power BI Desktop in 10 Min.","datePublished":"2018-07-30T03:45:46+00:00","dateModified":"2018-09-11T16:40:35+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/"},"wordCount":863,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Connect-to-data-in-Power-BI-Desktop-01.jpg","keywords":["Connect to data in Power BI Desktop","Connecting to data in Power BI Desktop","Data Source Connect in Power BI Desktop","Power BI Work Area"],"articleSection":["Power BI Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/","url":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/","name":"Connect to Data in Power BI Desktop in 10 Min. - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Connect-to-data-in-Power-BI-Desktop-01.jpg","datePublished":"2018-07-30T03:45:46+00:00","dateModified":"2018-09-11T16:40:35+00:00","description":"How to Connect to data in Power BI Desktop, Power BI Work Area, Data Source Connect in Power BI Desktop, Steps to connect to Data In Power Bi Desktop","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Connect-to-data-in-Power-BI-Desktop-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Connect-to-data-in-Power-BI-Desktop-01.jpg","width":1200,"height":628,"caption":"Connect to data in Power BI Desktop in 10 Min."},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/connect-to-data-in-power-bi-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAS Foundation Tools Certifications","item":"https:\/\/data-flair.training\/blogs\/tag\/sas-foundation-tools-certifications\/"},{"@type":"ListItem","position":3,"name":"Connect to Data in Power BI Desktop in 10 Min."}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=21793"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21793\/revisions"}],"predecessor-version":[{"id":32531,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21793\/revisions\/32531"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/21814"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=21793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=21793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=21793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}