{"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\/fr\/puissancebi\/conectar-power-bi-a-sql-server\/","title":{"rendered":"Connectez Power BI \u00e0 SQL Server"},"content":{"rendered":"<div>\n<p>Prenons une approche \u00e9tape par \u00e9tape pour connecter Power BI \u00e0 la base de donn\u00e9es SQL Server. En plus de cette connexion de Power BI \u00e0 SQL Server, comment utiliser les requ\u00eates SQL avec les donn\u00e9es pr\u00e9sentes dans les tables SQL avec un exemple<\/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>Approche \u00e9tape par \u00e9tape pour connecter Power BI \u00e0 SQL Server<\/h2>\n<p>Si vous n&#039;avez pas encore d\u00e9marr\u00e9 Power BI Desktop, double-cliquez sur Power BI Desktop pour l&#039;ouvrir. Une fois ouvert, il ressemble \u00e0 la capture d&#039;\u00e9cran suivante. Clique sur le <strong>Obtenir des informations<\/strong> Hyperlien<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-au-serveur-sql-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-au-serveur-sql-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>Si vous \u00eates sur la page de visualisation Power BI, sous l&#039;onglet Accueil, cliquez sur l&#039;ic\u00f4ne <b>Obtenir des informations<\/b> et s\u00e9lectionnez l&#039;option <b>Serveur SQL, <\/b>comme nous le montrons ci-dessous. Ou s\u00e9lectionnez <b>Voir plus<\/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>Nous s\u00e9lectionnons <b>Voir plus<\/b> options pour vous montrer la fen\u00eatre suivante. Utilisez cette fen\u00eatre pour s\u00e9lectionner la source de donn\u00e9es souhait\u00e9e. Ici, nous parlons de la fa\u00e7on de connecter Power BI \u00e0 SQL Server. Alors, laissez-moi s\u00e9lectionner le <b>Base de donn\u00e9es SQL Server<\/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>Connectez Power BI \u00e0 SQL Server<\/h3>\n<p>Voici la liste des champs disponibles \u00e0 remplir pour connecter Power BI \u00e0 la base de donn\u00e9es SQL Server<\/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>Serveur:<\/b> Fournissez le nom de l&#039;instance SQL Server. Si vous avez install\u00e9 SQL avec l&#039;instance par d\u00e9faut, le nom de l&#039;instance est le nom de l&#039;ordinateur ou localhost.<\/li>\n<li><b>Base de donn\u00e9es:<\/b> Ceci est facultatif. Si vous souhaitez utiliser une requ\u00eate SQL personnalis\u00e9e, elle est obligatoire.<\/li>\n<li><b>Mode de connectivit\u00e9 des donn\u00e9es:<\/b> S\u00e9lectionnez si vous souhaitez importer ou interroger directement.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-au-serveur-sql-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-au-serveur-sql-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>Cliquez sur l&#039;option Avanc\u00e9 pour afficher les propri\u00e9t\u00e9s avanc\u00e9es.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-au-serveur-sql-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-au-serveur-sql-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>Vous pouvez \u00e9crire votre propre requ\u00eate SQL pour extraire des donn\u00e9es de la base de donn\u00e9es sp\u00e9cifi\u00e9e. Pour ce faire, \u00e9crivez votre requ\u00eate dans la zone Instruction SQL<\/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>La requ\u00eate personnalis\u00e9e que nous utilisons dans la capture d&#039;\u00e9cran Connect Power BI to SQL Server ci-dessus est:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">- Connexion de Power BI \u00e0 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, FactorStateProvince 600\n<\/pre>\n<p>Si vous souhaitez utiliser ces donn\u00e9es, cliquez sur T\u00e9l\u00e9charger. Pour l&#039;instant, permettez-moi de cliquer sur le bouton Annuler car je souhaite s\u00e9lectionner plusieurs 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>REMARQUE:<\/strong> Ne vous inqui\u00e9tez pas pour la requ\u00eate, comprenez simplement la proc\u00e9dure. Cependant, si vous souhaitez en savoir plus, consultez notre didacticiel SQL Server<\/p>\n<p>Permettez-moi d&#039;utiliser l&#039;instance locale et cliquez sur 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>Pour l&#039;instant, nous utilisons les informations d&#039;identification Windows locales actuelles. Si vous n&#039;\u00eates pas autoris\u00e9 \u00e0 acc\u00e9der \u00e0 SQL Server, utilisez les informations d&#039;identification Windows de quelqu&#039;un d&#039;autre en s\u00e9lectionnant <strong>Utilisez d&#039;autres informations d&#039;identification<\/strong>.<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-au-serveur-sql-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-au-serveur-sql-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>En temps r\u00e9el, nous n&#039;utilisons que les informations d&#039;identification de la base de donn\u00e9es SQL Server. Pour cela, s\u00e9lectionnez la base de donn\u00e9es et saisissez le nom d&#039;utilisateur et le mot de passe fournis par l&#039;administrateur.<\/p>\n<p>Pour l&#039;instant, j&#039;utilise les informations d&#039;identification Windows actuelles.<\/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>Dans les options d&#039;affichage, il r\u00e9pertorie les bases de donn\u00e9es disponibles pour cette instance. Dans cet exemple, nous s\u00e9lectionnons <b>le AdventureWorksDW2017 <\/b>base de donn\u00e9es.<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>Vous pouvez t\u00e9l\u00e9charger gratuitement cette base de donn\u00e9es depuis le centre de t\u00e9l\u00e9chargement officiel de Microsoft ou GitHub.<\/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>Le d\u00e9veloppement du dossier Base de donn\u00e9es affiche les tables et vues disponibles. Lorsque vous s\u00e9lectionnez la table, l&#039;aper\u00e7u des donn\u00e9es s&#039;affiche.<\/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>Dans la capture d&#039;\u00e9cran suivante, vous pouvez voir que nous s\u00e9lectionnons les tables requises. N&#039;oubliez pas que si vous ne parvenez pas \u00e0 s\u00e9lectionner des tables, s\u00e9lectionnez une table de mesures (commandes ou ventes) et cliquez sur <strong>S\u00e9lectionnez des tables associ\u00e9es<\/strong> bouton.<\/p>\n<ul>\n<li><strong>Charge:<\/strong> Cela chargera les donn\u00e9es des tables s\u00e9lectionn\u00e9es dans Power BI. Puisque je sais que les donn\u00e9es sont propres, permettez-moi de cliquer sur le bouton T\u00e9l\u00e9charger<\/li>\n<li><strong>\u00c9diter:<\/strong> Cliquez sur ce bouton pour modifier les colonnes ou nettoyer les donn\u00e9es<\/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>Veuillez patienter jusqu&#039;\u00e0 ce que le t\u00e9l\u00e9chargement soit termin\u00e9<\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-au-serveur-sql-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-au-serveur-sql-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>Vous pouvez maintenant voir les tables que nous avons s\u00e9lectionn\u00e9es dans la base de donn\u00e9es SQL Server dans la section Champs.<\/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>D\u00e9veloppez n&#039;importe quelle table pour voir les colonnes (champs) de cette 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>ASTUCE:<\/strong> Il s&#039;agit de l&#039;ensemble de donn\u00e9es que nous utiliserons pour la plupart du didacticiel Power BI.<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>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&#8230;<\/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\/fr\/puissancebi\/conectar-power-bi-a-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\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\/fr\/puissancebi\/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\":\"fr-FR\"},{\"@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\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conectar-power-bi-a-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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":"Connecter Power BI \u00e0 SQL Server - R Marketing Digital","description":"Prenons une approche \u00e9tape par \u00e9tape pour connecter Power BI \u00e0 la base de donn\u00e9es SQL Server. En plus de cette connexion de Power BI \u00e0 SQL Server, comment utiliser les requ\u00eates","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\/fr\/puissancebi\/conectar-power-bi-a-sql-server\/","og_locale":"fr_FR","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\/fr\/puissancebi\/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":"fr-FR"},{"@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":"Connecter Power BI \u00e0 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":"Prenons une approche \u00e9tape par \u00e9tape pour connecter Power BI \u00e0 la base de donn\u00e9es SQL Server. En plus de cette connexion de Power BI \u00e0 SQL Server, comment utiliser les requ\u00eates","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/conectar-power-bi-a-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@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":"Marketing num\u00e9rique","description":"Agence de r\u00e9f\u00e9rencement | Publicit\u00e9 sur les r\u00e9seaux sociaux | Gestion de communaut\u00e9","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":"fr-FR"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"Marketing num\u00e9rique","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/wp-json\/wp\/v2\/posts\/85409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/comments?post=85409"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts\/85409\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/media\/85408"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/media?parent=85409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/categories?post=85409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/tags?post=85409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}