{"id":174285,"date":"2023-11-30T08:56:00","date_gmt":"2023-11-30T07:56:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=174285"},"modified":"2023-11-28T21:13:02","modified_gmt":"2023-11-28T20:13:02","slug":"connecting-power-bi-and-sql-server-how-do-i-do-it","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it","title":{"rendered":"Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"174285\" class=\"elementor elementor-174285\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6fcb21f e-flex e-con-boxed e-con\" data-id=\"6fcb21f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0e280aa elementor-widget elementor-widget-heading\" data-id=\"0e280aa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">SQL Server and Power BI are two complementary tools for data analysis. On one hand, SQL Server is a database management system (DBMS) that allows for storing, controlling, sorting, and updating databases using the SQL language. On the other hand, Power BI is a business intelligence tool designed to help organizations make informed decisions using data. So, how can you connect SQL Server and Power BI? Discover three approaches to achieve your goals.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bddcd4f e-flex e-con-boxed e-con\" data-id=\"bddcd4f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-67920e0 elementor-widget elementor-widget-heading\" data-id=\"67920e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">SQL Server and Power BI connected by a script<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a5386a8 elementor-widget elementor-widget-text-editor\" data-id=\"a5386a8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>To connect <strong>Power BI and SQL<\/strong> Server using a script, you can <a href=\"https:\/\/datascientest.com\/en\/avoid-these-top-5-common-python-coding-mistakes\">use R or Python.<\/a> Here, you will find a method based on the Python language.<\/p><h3><strong>Step 1: Install these libraries using Pip in the command terminal:<\/strong><\/h3><p><strong>pip install pyodbc<\/strong><\/p><p><strong>pip install pandas<\/strong><\/p><p><strong>pip install matplotlib<\/strong><\/p><ul><li>The <strong>pyodbc library<\/strong> provides access to ODBC (Open Database Connectivity) databases.<\/li><li>The pandas library allows for data manipulation and analysis.<\/li><li>Finally, matplotlib allows you to <a href=\"https:\/\/datascientest.com\/en\/pandas-the-python-library\">plot graphs and charts directly from pandas.<\/a><\/li><\/ul><p>Make sure to check where the <strong>Python Home Directory<\/strong> points to. To do this, go to &#8216;Files&#8217; and then &#8216;Options and Settings&#8217;. Click on &#8216;Python Scripting&#8217; and verify that &#8216;Python Home Directory&#8217; points to your Local Python Installation Path and your &#8216;<strong>Python IDE<\/strong>&#8216; on which the system executes the script.<\/p><h3><strong>Step 2: Select &#8216;Get Data&#8217; from the panel at the top of your screen.<\/strong><\/h3><p>The &#8216;Get Data&#8217; panel opens. Then, select &#8216;Other&#8217; and then &#8216;Python script&#8217;. Click on &#8216;Connect&#8217;.<\/p><h3>Step 3: In the dialog box, enter the following script:<\/h3><p><strong>import pandas as pd<\/strong><br \/><strong>import pyodbc<\/strong><\/p><p>conn = pyodbc.connect(&#8216;Driver={SQL Server};&#8217;<br \/>&#8216;Server=servername;&#8217;<br \/>&#8216;Database=databasename;&#8217;<br \/>&#8216;Trusted_Connection=yes;&#8217;)<\/p><p>cur = conn.cursor()<\/p><p>sqlquery = pd.read_sql_query(&#8216;SELECT * FROM tablename&#8217;, conn)<\/p><p>print(sqlquery)<\/p><p>This <a href=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\">query connects to SQL Server<\/a> using the &#8216;pyodbc&#8217; library installed earlier and uses this connection to retrieve data from our table. These data are then converted and loaded into Power BI.<\/p><h3><strong>Step 4: In the &#8216;Navigator&#8217; panel, select the result and click on &#8216;Load&#8217;.<\/strong><\/h3><p>You will then have your data, which you can visualize as desired.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1f22cac e-flex e-con-boxed e-con\" data-id=\"1f22cac\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d066547 elementor-widget elementor-widget-heading\" data-id=\"d066547\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Using a connector for Power BI and SQL Server<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0628163 elementor-widget elementor-widget-text-editor\" data-id=\"0628163\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In this method, you are using only <em>Power BI and a connector.<\/em><\/p><p>1. Open Power BI Desktop on your computer.<br \/>2. In the panel at the top of your screen, click on &#8220;SQL Server.&#8221;<br \/>3. Enter the server name in the &#8220;Server&#8221; dialog box of SQL Server database. Select &#8220;DirectQuery.&#8221; In the &#8220;Name&#8221; dialog box, you can specify the name of your database.<br \/>4. Click &#8220;OK.&#8221;<\/p><p>You will then have your data table, and you can visualize the data according to your needs.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79c1775 elementor-widget elementor-widget-text-editor\" data-id=\"79c1775\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This approach is convenient if you have already established a connection between <strong>Power BI and SQL Server<\/strong>.<\/p><p>Creating the connection between these two entities can sometimes be a bit cumbersome. The other drawback occurs when you select &#8216;Import&#8217; as your <strong>Connectivity Mode.<\/strong> In this case, all the data is imported, making it challenging to fully utilize <a href=\"https:\/\/datascientest.com\/en\/demystifying-power-bi-date-formats-the-most-commonly-used-formats\">Power BI&#8217;s visualization potential.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-653cf8e e-flex e-con-boxed e-con\" data-id=\"653cf8e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-add0bfa elementor-widget elementor-widget-heading\" data-id=\"add0bfa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Export SQL Server data to Excel and import into Power BI<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be5bbda elementor-widget elementor-widget-text-editor\" data-id=\"be5bbda\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This process can indeed be time-consuming, especially if you perform this task regularly. Nevertheless, this old-school method works well.<\/p><p>Step 1: In SQL Server, right-click on the database containing your future table. Then, click on &#8216;Tasks&#8217; and &#8216;Export Data&#8217;.<\/p><p>Step 2: A panel opens: &#8216;Choose a Data Source&#8217;. Select &#8216;SQL Server Native Client 11.0&#8217; as the data source and click &#8216;Next&#8217;.<\/p><p>Step 3: Click on &#8216;<a href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\">Microsoft Excel<\/a>&#8216; for the destination. Specify the file path and name in the &#8216;Excel file path&#8217; dialog box. Then, click &#8216;Next&#8217;.<\/p><p>Step 4: If you want to export specific data, select &#8216;Write a query to specify the data to transfer&#8217;. Click &#8216;Next&#8217;.<\/p><p>Step 5: In the &#8216;Provide a Source Query&#8217; panel, enter the following script:<\/p><p><strong>SELECT * FROM tablename;<\/strong><\/p><p>Click &#8216;Next&#8217;.<\/p><p>In the &#8216;Select source tables and views&#8217; and &#8216;Review data mapping type&#8217; panels, click &#8216;Next&#8217;. Then, select &#8216;Run immediately&#8217; in the &#8216;Save and Run Package&#8217; panel and click &#8216;Finish&#8217;.<\/p><p>Step 6: Open <a href=\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\">Power BI and select Excel<\/a> in the panel at the top of your screen. Find the exported file from SQL Server.<\/p><p>Step 7: In the &#8216;Navigator&#8217; panel, select your data and click &#8216;Load&#8217;.<\/p><p>You will then see your data appear in Power BI.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8ccd253 e-flex e-con-boxed e-con\" data-id=\"8ccd253\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dc21cda elementor-widget elementor-widget-heading\" data-id=\"dc21cda\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5afc4e2 elementor-widget elementor-widget-text-editor\" data-id=\"5afc4e2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>There are several ways to connect <strong>Power BI and SQL Server,<\/strong> each with its own advantages and disadvantages. You can use an R or Python script to establish the connection, use a specific connector, or export SQL data to Excel and import it into Power BI. The method to use depends on your preferences and specific needs.<\/p><p>By using one of these approaches, you can easily connect SQL Server and Power BI to access your data and gain insights to <strong>improve your decision-making.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e98859 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4e98859\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn more about Power BI<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6f317e7 e-flex e-con-boxed e-con\" data-id=\"6f317e7\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-65228c2 elementor-widget elementor-widget-html\" data-id=\"65228c2\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"SQL Server and Power BI connected through a script\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"To connect Power BI and SQL Server using a script, you can use R or Python. Here you'll find a method based on the Python language.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Export SQL Server data to Excel and import it into Power BI\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"This process is probably the most time-consuming, especially if you repeat the task regularly. Nevertheless, this old-school method works like a charm.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>SQL Server and Power BI are two complementary tools for data analysis. On one hand, SQL Server is a database management system (DBMS) that allows for storing, controlling, sorting, and updating databases using the SQL language. On the other hand, Power BI is a business intelligence tool designed to help organizations make informed decisions using [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":174290,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide<\/title>\n<meta name=\"description\" content=\"If you are looking for a solution to connect Power BI and SQL Server, then you should take into account the different...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide\" \/>\n<meta property=\"og:description\" content=\"SQL Server and Power BI are two complementary tools for data analysis. On one hand, SQL Server is a database management system (DBMS) that allows for\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-30T07:56:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-28T20:13:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/power-bi-sql.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"384\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide\",\"datePublished\":\"2023-11-30T07:56:00+00:00\",\"dateModified\":\"2023-11-28T20:13:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it\"},\"wordCount\":791,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it\",\"url\":\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it\",\"name\":\"Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-11-30T07:56:00+00:00\",\"dateModified\":\"2023-11-28T20:13:02+00:00\",\"description\":\"If you are looking for a solution to connect Power BI and SQL Server, then you should take into account the different...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide","description":"If you are looking for a solution to connect Power BI and SQL Server, then you should take into account the different...","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:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it","og_locale":"en_GB","og_type":"article","og_title":"Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide","og_description":"SQL Server and Power BI are two complementary tools for data analysis. On one hand, SQL Server is a database management system (DBMS) that allows for","og_url":"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-11-30T07:56:00+00:00","article_modified_time":"2023-11-28T20:13:02+00:00","og_image":[{"width":768,"height":384,"url":"https:\/\/datascientest.com\/en\/files\/2023\/11\/power-bi-sql.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide","datePublished":"2023-11-30T07:56:00+00:00","dateModified":"2023-11-28T20:13:02+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it"},"wordCount":791,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it","url":"https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it","name":"Seamlessly Connect Power BI and SQL Server: A Step-by-Step Guide","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-11-30T07:56:00+00:00","dateModified":"2023-11-28T20:13:02+00:00","description":"If you are looking for a solution to connect Power BI and SQL Server, then you should take into account the different...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/connecting-power-bi-and-sql-server-how-do-i-do-it"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/174285"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=174285"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/174285\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/174290"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=174285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=174285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=174285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}