{"id":85409,"date":"2022-08-24T06:04:55","date_gmt":"2022-08-24T04:04:55","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/"},"modified":"2020-09-18T01:24:42","modified_gmt":"2020-09-18T04:24:42","slug":"conectar-power-bi-a-sql-server","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/conectar-power-bi-a-sql-server\/","title":{"rendered":"Connect Power BI to SQL Server"},"content":{"rendered":"<div>\n<p>Let&#039;s take a step-by-step approach to connecting Power BI to SQL Server database. In addition to this Connect Power BI to SQL Server, how to use SQL queries with the data present in SQL tables with an example<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-104\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:280px;min-width:336px;text-align:center !important;\" class=\"ezoic-ad medrectangle-3 adtester-container adtester-container-104\" data-ez-name=\"tutorialgateway_org-medrectangle-3\"><span id=\"div-gpt-ad-tutorialgateway_org-medrectangle-3-0\" ezaw=\"336\" ezah=\"280\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:280px;min-width:336px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<h2>Step-by-step approach to connecting Power BI to SQL Server<\/h2>\n<p>If you haven&#039;t started Power BI Desktop yet, double-click Power BI Desktop to open it. Once it&#039;s open, it looks like the following screenshot. Click on the <strong>Get information<\/strong> Hyperlink<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-1-1617761' width='1160' height='743' class=\"wp-image-29650\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761.png 1160w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-1024x656.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-768x492.png 768w' data-lazy-sizes='(max-width: 1160px) 100vw, 1160px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761.png'\/><noscript><img alt='connect-power-bi-to-sql-server-1-1617761' width='1160' height='743' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761.png' class=\"wp-image-29650\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761.png 1160w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-1024x656.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-768x492.png 768w' sizes='(max-width: 1160px) 100vw, 1160px'\/><\/noscript><\/figure>\n<p>If you are on the Power BI visualization page, on the Home tab, click the <b>Get information<\/b> option and select the <b>SQL server, <\/b>as we show below. Or select <b>More<\/b> options.<span id=\"ezoic-pub-ad-placeholder-132\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:90px;min-width:728px;text-align:center !important;\" class=\"ezoic-ad box-3 adtester-container adtester-container-132\" data-ez-name=\"tutorialgateway_org-box-3\"><span id=\"div-gpt-ad-tutorialgateway_org-box-3-0\" ezaw=\"728\" ezah=\"90\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:90px;min-width:728px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-2-2688683' width='1116' height='708' class=\"wp-image-29651\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683.png 1116w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683-1024x650.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683-768x487.png 768w' data-lazy-sizes='(max-width: 1116px) 100vw, 1116px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683.png'\/><noscript><img alt='connect-power-bi-to-sql-server-2-2688683' width='1116' height='708' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683.png' class=\"wp-image-29651\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683.png 1116w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683-1024x650.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-2-2688683-768x487.png 768w' sizes='(max-width: 1116px) 100vw, 1116px'\/><\/noscript><\/figure>\n<p>We are selecting <b>More<\/b> options to show you the following window. Use this window to select the desired data source. Here, we are talking about how to connect Power BI to SQL Server. So, let me select the <b>SQL Server database<\/b> Option.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-3-9567225' width='1114' height='685' class=\"wp-image-29652\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225.png 1114w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225-1024x630.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225-768x472.png 768w' data-lazy-sizes='(max-width: 1114px) 100vw, 1114px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225.png'\/><noscript><img alt='connect-power-bi-to-sql-server-3-9567225' width='1114' height='685' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225.png' class=\"wp-image-29652\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225.png 1114w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225-1024x630.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-3-9567225-768x472.png 768w' sizes='(max-width: 1114px) 100vw, 1114px'\/><\/noscript><\/figure>\n<h3>Connect Power BI to SQL Server<\/h3>\n<p>The following is the list of fields available to fill in to connect Power BI to the SQL Server database<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"background:0 0 !important;display:flex !important;float:none !important;justify-content:space-between;margin-bottom:15px !important;margin-left:auto !important;margin-right:auto !important;margin-top:15px !important;min-height:250px;min-width:580px;text-align:center !important;width:580px;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105 ezoic-ad-adaptive\" data-ez-name=\"tutorialgateway_org-box-4\"><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:250px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"290\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:290px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:250px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0_1\" ezaw=\"290\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:290px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/span><\/p>\n<ul>\n<li><b>Server:<\/b> Provide the name of the SQL Server instance. If you installed SQL with the default instance, the instance name is the computer name or localhost.<\/li>\n<li><b>Database:<\/b> This is optional. If you want to use a custom SQL query, it is required.<\/li>\n<li><b>Data connectivity mode:<\/b> Select whether you want to import or query directly.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-4-9525796' width='700' height='335' class=\"wp-image-29653\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-4-9525796.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-4-9525796-300x144.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-4-9525796.png'\/><noscript><img alt='connect-power-bi-to-sql-server-4-9525796' width='700' height='335' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-4-9525796.png' class=\"wp-image-29653\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-4-9525796.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-4-9525796-300x144.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Clicking the Advanced option displays the advanced properties.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-5-1161003' width='700' height='662' class=\"wp-image-29654\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-5-1161003.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-5-1161003-300x284.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-5-1161003.png'\/><noscript><img alt='connect-power-bi-to-sql-server-5-1161003' width='700' height='662' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-5-1161003.png' class=\"wp-image-29654\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-5-1161003.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-5-1161003-300x284.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>You can write your own SQL query to extract data from the specified database. To do this, write your query inside the SQL Statement box<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-15-4508087' width='700' height='664' class=\"wp-image-29665\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-15-4508087.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-15-4508087-300x285.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-15-4508087.png'\/><noscript><img alt='connect-power-bi-to-sql-server-15-4508087' width='700' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-15-4508087.png' class=\"wp-image-29665\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-15-4508087.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-15-4508087-300x285.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>The custom query we use in the Connect Power BI to SQL Server screenshot above is:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">- Connecting Power BI to SQL Server SELECT Geo.EnglishCountryRegionName AS Country, Geo.StateProvinceName AS State, SUM (Fact.SalesAmount) AS Sales, SUM (Fact.TaxAmt) AS Tax, COUNT (Fact.OrderQuantity) AS Orders FROM FactResellerSales AS Fact INNER JOIN DimSalesTerritory ON Fact.SalesTerritoryKey = DimSalesTerritory.SalesTerritoryKey INNER JOIN DimGeography AS Geo ON DimSalesTerritory.SalesTerritoryKey = Geo.SalesTerritoryKey GROUP BY Geo.EnglishCountryRegionName, Geo.StateProvinceName HAVING COUNT (Fact.Order00Quantity) 600\n<\/pre>\n<p>If you want to use this data, click Upload. For now, let me click the cancel button because I want to select multiple tables.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-16-9158394' width='723' height='519' class=\"wp-image-29666\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-16-9158394.png 723w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-16-9158394-300x215.png 300w' data-lazy-sizes='(max-width: 723px) 100vw, 723px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-16-9158394.png'\/><noscript><img alt='connect-power-bi-to-sql-server-16-9158394' width='723' height='519' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-16-9158394.png' class=\"wp-image-29666\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-16-9158394.png 723w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-16-9158394-300x215.png 300w' sizes='(max-width: 723px) 100vw, 723px'\/><\/noscript><\/figure>\n<p class=\"note\"><strong>NOTE:<\/strong> Don&#039;t worry over the query, just understand the procedure. However, if you want to learn, check out our SQL Server Tutorial<\/p>\n<p>Let me use the local instance and click OK<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-6-1334529' width='699' height='335' class=\"wp-image-29655\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-6-1334529.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-6-1334529-300x144.png 300w' data-lazy-sizes='(max-width: 699px) 100vw, 699px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-6-1334529.png'\/><noscript><img alt='connect-power-bi-to-sql-server-6-1334529' width='699' height='335' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-6-1334529.png' class=\"wp-image-29655\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-6-1334529.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-6-1334529-300x144.png 300w' sizes='(max-width: 699px) 100vw, 699px'\/><\/noscript><\/figure>\n<p>For now, we are using the current local Windows credentials. If you do not have permission to access SQL Server, use someone else&#039;s Windows credential by selecting <strong>Use alternate credentials<\/strong>.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-7-1564063' width='700' height='318' class=\"wp-image-29656\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-7-1564063.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-7-1564063-300x136.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-7-1564063.png'\/><noscript><img alt='connect-power-bi-to-sql-server-7-1564063' width='700' height='318' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-7-1564063.png' class=\"wp-image-29656\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-7-1564063.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-7-1564063-300x136.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>In real time, we only use the credentials from the SQL Server database. For this, select the database and enter the username and password provided by the Admin person.<\/p>\n<p>For now, I am using current Windows credentials.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-8-1714051' width='699' height='318' class=\"wp-image-29657\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-8-1714051.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-8-1714051-300x136.png 300w' data-lazy-sizes='(max-width: 699px) 100vw, 699px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-8-1714051.png'\/><noscript><img alt='connect-power-bi-to-sql-server-8-1714051' width='699' height='318' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-8-1714051.png' class=\"wp-image-29657\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-8-1714051.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-8-1714051-300x136.png 300w' sizes='(max-width: 699px) 100vw, 699px'\/><\/noscript><\/figure>\n<p>In the display options, it lists the databases that are available for that instance. In this example, we are selecting <b>the AdventureWorksDW2017 <\/b>database.<span id=\"ezoic-pub-ad-placeholder-106\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad banner-1 adtester-container adtester-container-106\" data-ez-name=\"tutorialgateway_org-banner-1\"><span id=\"div-gpt-ad-tutorialgateway_org-banner-1-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<p>You can download this database from Microsoft&#039;s Official Download Center or GitHub for free.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-9-4677047' width='880' height='700' class=\"wp-image-29658\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-9-4677047.png 880w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-9-4677047-300x239.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-9-4677047-768x611.png 768w' data-lazy-sizes='(max-width: 880px) 100vw, 880px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-9-4677047.png'\/><noscript><img alt='connect-power-bi-to-sql-server-9-4677047' width='880' height='700' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-9-4677047.png' class=\"wp-image-29658\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-9-4677047.png 880w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-9-4677047-300x239.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-9-4677047-768x611.png 768w' sizes='(max-width: 880px) 100vw, 880px'\/><\/noscript><\/figure>\n<p>Expanding the Database folder displays the available tables and views. When you select the table, the Data Preview is displayed.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-10-9719125' width='1113' height='700' class=\"wp-image-29659\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125-1024x644.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125-768x483.png 768w' data-lazy-sizes='(max-width: 1113px) 100vw, 1113px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125.png'\/><noscript><img alt='connect-power-bi-to-sql-server-10-9719125' width='1113' height='700' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125.png' class=\"wp-image-29659\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125-1024x644.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-10-9719125-768x483.png 768w' sizes='(max-width: 1113px) 100vw, 1113px'\/><\/noscript><\/figure>\n<p>In the following screenshot, you can see that we are selecting the required tables. Remember, if you are confused to select tables, select a table of Measures (Orders or Sales) and click <strong>Select related tables<\/strong> button.<\/p>\n<ul>\n<li><strong>Load:<\/strong> This will load data from the selected tables into Power BI. Since I know the data is clean, let me click the Upload button<\/li>\n<li><strong>Edit:<\/strong> Click this button to modify the columns or clean the data<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-11-5116469' width='1111' height='700' class=\"wp-image-29660\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469.png 1111w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469-1024x645.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469-768x484.png 768w' data-lazy-sizes='(max-width: 1111px) 100vw, 1111px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469.png'\/><noscript><img alt='connect-power-bi-to-sql-server-11-5116469' width='1111' height='700' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469.png' class=\"wp-image-29660\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469.png 1111w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469-1024x645.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-5116469-768x484.png 768w' sizes='(max-width: 1111px) 100vw, 1111px'\/><\/noscript><\/figure>\n<p>Please wait until the upload is complete<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-12-8351415' width='500' height='392' class=\"wp-image-29661\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-12-8351415.png 500w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-12-8351415-300x235.png 300w' data-lazy-sizes='(max-width: 500px) 100vw, 500px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-12-8351415.png'\/><noscript><img alt='connect-power-bi-to-sql-server-12-8351415' width='500' height='392' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-12-8351415.png' class=\"wp-image-29661\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-12-8351415.png 500w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-12-8351415-300x235.png 300w' sizes='(max-width: 500px) 100vw, 500px'\/><\/noscript><\/figure>\n<p>Now you can see the tables we selected from the SQL Server database in the Fields section.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-13-5176174' width='1085' height='727' class=\"wp-image-29662\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174.png 1085w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-300x201.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-1024x686.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-768x515.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-900x604.png 900w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-600x403.png 600w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-400x269.png 400w' data-lazy-sizes='(max-width: 1085px) 100vw, 1085px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174.png'\/><noscript><img alt='connect-power-bi-to-sql-server-13-5176174' width='1085' height='727' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174.png' class=\"wp-image-29662\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174.png 1085w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-300x201.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-1024x686.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-768x515.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-900x604.png 900w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-600x403.png 600w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-13-5176174-400x269.png 400w' sizes='(max-width: 1085px) 100vw, 1085px'\/><\/noscript><\/figure>\n<p>Expand any table to see the columns (fields) within that table.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-to-sql-server-14-9382611' width='1086' height='749' class=\"wp-image-29663\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-9382611.png 1086w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-9382611-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-9382611-1024x706.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-9382611-768x530.png 768w' data-lazy-sizes='(max-width: 1086px) 100vw, 1086px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-9382611.png'\/><noscript><img alt='connect-power-bi-to-sql-server-14-8235973' width='1086' height='749' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-8235973.png' class=\"wp-image-29663\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-8235973.png 1086w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-8235973-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-8235973-1024x706.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-14-8235973-768x530.png 768w' sizes='(max-width: 1086px) 100vw, 1086px'\/><\/noscript><\/figure>\n<p class=\"tip\"><strong>TIP:<\/strong> This is the dataset that we will use for most of the Power BI tutorial.<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Let&#039;s see the step by step approach to connect Power BI to SQL Server database. In addition to this Connect Power BI to SQL Server, how to use queries\u2026<\/p>","protected":false},"author":1,"featured_media":85408,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-85409","post","type-post","status-publish","format-standard","has-post-thumbnail","category-powerbi","category-tutoriales-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Conectar Power BI a SQL Server - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"Veamos el enfoque paso a paso para conectar Power BI a la base de datos de SQL Server. Adem\u00e1s de este Connect Power BI to SQL Server, c\u00f3mo usar consultas\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/conectar-power-bi-a-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conectar Power BI a SQL Server\" \/>\n<meta property=\"og:description\" content=\"Veamos el enfoque paso a paso para conectar Power BI a la base de datos de SQL Server. Adem\u00e1s de este Connect Power BI to SQL Server, c\u00f3mo usar consultas\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/conectar-power-bi-a-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-24T04:04:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-1017186.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1111\" \/>\n\t<meta property=\"og:image:height\" content=\"700\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"R Marketing Digital\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Conectar Power BI a SQL Server\",\"datePublished\":\"2022-08-24T04:04:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/\"},\"wordCount\":674,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Connect-Power-BI-to-SQL-Server-11-1017186.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/\",\"name\":\"Conectar Power BI a SQL Server - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Connect-Power-BI-to-SQL-Server-11-1017186.png\",\"datePublished\":\"2022-08-24T04:04:55+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"Veamos el enfoque paso a paso para conectar Power BI a la base de datos de SQL Server. Adem\u00e1s de este Connect Power BI to SQL Server, c\u00f3mo usar consultas\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Connect-Power-BI-to-SQL-Server-11-1017186.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Connect-Power-BI-to-SQL-Server-11-1017186.png\",\"width\":1111,\"height\":700,\"caption\":\"connect-power-bi-to-sql-server-11-1017186-2499343-png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connect Power BI to SQL Server - R Marketing Digital","description":"Let&#039;s take a step-by-step approach to connecting Power BI to SQL Server database. In addition to this Connect Power BI to SQL Server, how to use queries","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:\/\/rmarketingdigital.com\/en\/powerbi\/conectar-power-bi-a-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Conectar Power BI a SQL Server","og_description":"Veamos el enfoque paso a paso para conectar Power BI a la base de datos de SQL Server. Adem\u00e1s de este Connect Power BI to SQL Server, c\u00f3mo usar consultas","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/conectar-power-bi-a-sql-server\/","og_site_name":"R Marketing Digital","article_published_time":"2022-08-24T04:04:55+00:00","og_image":[{"width":1111,"height":700,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-1017186.png","type":"image\/png"}],"author":"R Marketing Digital","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Conectar Power BI a SQL Server","datePublished":"2022-08-24T04:04:55+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/"},"wordCount":674,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-1017186.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/","name":"Connect Power BI to SQL Server - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-1017186.png","datePublished":"2022-08-24T04:04:55+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Let&#039;s take a step-by-step approach to connecting Power BI to SQL Server database. In addition to this Connect Power BI to SQL Server, how to use queries","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-1017186.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-11-1017186.png","width":1111,"height":700,"caption":"connect-power-bi-to-sql-server-11-1017186-2499343-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digital Marketing","description":"SEO Agency | Advertising social networks | Community Management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rmarketingdigital.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digital Marketing","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","caption":"R Marketing Digital"}}]}},"_links":{"self":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/85409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/comments?post=85409"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/85409\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/85408"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=85409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=85409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=85409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}