{"id":185497,"date":"2022-12-26T18:07:00","date_gmt":"2022-12-26T18:07:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=185497"},"modified":"2023-11-09T13:30:33","modified_gmt":"2023-11-09T13:30:33","slug":"connecter-power-bi-et-sql-server","status":"publish","type":"post","link":"https:\/\/datascientest.com\/connecter-power-bi-et-sql-server","title":{"rendered":"Connecter Power BI et SQL Server : Comment faire ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"185497\" class=\"elementor elementor-185497\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b099a68 e-flex e-con-boxed e-con\" data-id=\"b099a68\" 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-88ebf15 elementor-widget elementor-widget-heading\" data-id=\"88ebf15\" 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 et Power BI sont deux outils compl\u00e9mentaires pour l\u2019analyse de vos donn\u00e9es. D\u2019un c\u00f4t\u00e9, SQL Server est un syst\u00e8me de gestion de base de donn\u00e9es (SGBD) permettant le stockage, le contr\u00f4le, le tri et la mise \u00e0 jour de base de donn\u00e9es gr\u00e2ce au langage SQL. De l\u2019autre c\u00f4t\u00e9, Power BI est outil d\u2019informatique d\u00e9cisionnelle qui vise \u00e0 accompagner les organisations \u00e0 prendre les bonnes d\u00e9cisions gr\u00e2ce \u00e0 la data. Mais alors, comment connecter SQL Server et Power BI ? D\u00e9couvrez trois approches pour parvenir \u00e0 vos fins. <\/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-abece50 e-flex e-con-boxed e-con\" data-id=\"abece50\" 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-7674e30 elementor-widget elementor-widget-heading\" data-id=\"7674e30\" 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 et Power BI connect\u00e9s gr\u00e2ce \u00e0 un script<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d1a7b4 elementor-widget elementor-widget-text-editor\" data-id=\"6d1a7b4\" 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>Pour connecter <a href=\"https:\/\/datascientest.com\/formation-power-bi\">Power BI<\/a> et SQL Server \u00e0 l\u2019aide d\u2019un script, vous pouvez utiliser R ou Python. Ici, vous retrouverez une m\u00e9thode bas\u00e9e sur le <a href=\"https:\/\/datascientest.com\/formation-langage-python\">langage Python<\/a>.<\/p><p><strong>\u00c9tape 1<\/strong> : Installez ces libraires \u00e0 l\u2019aide de Pip dans le terminal de commande :<\/p><blockquote><p><strong>pip install pyodbc<\/strong><\/p><p><strong>pip install pandas<\/strong><\/p><p><strong>pip install matplotlib<\/strong><\/p><\/blockquote><p>La librairie pyodbc donne acc\u00e8s aux bases de donn\u00e9es ODBC (Open Database Connectivity).<br \/>Celle de pandas permet la manipulation et l\u2019analyse des donn\u00e9es.<br \/>Enfin, matplotlib permet de tracer des graphiques et des diagrammes directement \u00e0 partir de pandas.<\/p><p>Pensez \u00e0 v\u00e9rifier o\u00f9 pointe le Python Home Directory. Pour ce faire, rendez-vous dans \u2018Files\u2019 puis dans \u2018Options and Settings\u2019. Cliquez sur \u2018Python Scripting\u2019 et v\u00e9rifiez le \u2018Python Home Directory\u2019 qui pointe vers votre Local Python Installation Path et votre \u2018Python IDE\u2019 sur lequel le syst\u00e8me ex\u00e9cute le script.<\/p><p><strong>\u00c9tape 2<\/strong> : S\u00e9lectionnez \u2018Get Data\u2019 dans votre panneau en haut de votre \u00e9cran.<\/p><p>Le panneau d\u2019affichage \u2018Get Data\u2019 s\u2019ouvre. Vous s\u00e9lectionnez alors \u2018Other\u2019 puis \u2018Python script\u2019. Cliquez sur \u2018Connect\u2019.<\/p><p><strong>\u00c9tape 3<\/strong> : Dans la bo\u00eete de dialogue, entrez le script suivant :<\/p><blockquote><p><strong>import pandas as pd<\/strong><\/p><p><strong>import pyodbc<\/strong><\/p><p><strong>conn = pyodbc.connect(&lsquo;Driver={SQL Server};&rsquo;<\/strong><\/p><p style=\"padding-left: 40px;\"><strong>&lsquo;Server=servername;&rsquo;<\/strong><\/p><p style=\"padding-left: 40px;\"><strong>&lsquo;Database=databasename;&rsquo;<\/strong><\/p><p style=\"padding-left: 40px;\"><strong>&lsquo;Trusted_Connection=yes;&rsquo;)<\/strong><\/p><p><strong>cur= conn.cursor()<\/strong><\/p><p><strong>sqlquery = pd.read_sql_query(&lsquo;SELECT * FROM tablename&rsquo;,conn)<\/strong><\/p><p><strong>print(sqlquery)<\/strong><\/p><\/blockquote><p>Cette requ\u00eate se connecte \u00e0 SQL Server en utilisant la librairie \u2018pyodbc\u2019 install\u00e9e plus t\u00f4t et se sert de cette connexion pour r\u00e9cup\u00e9rer les donn\u00e9es de notre tableau. Ces donn\u00e9es sont ensuite converties et charg\u00e9es dans Power BI.<\/p><p><strong>\u00c9tape 4<\/strong> : Dans le panneau \u2018Navigator\u2019, s\u00e9lectionnez le r\u00e9sultat et cliquez sur \u2018Load\u2019.<\/p><p>Vous obtenez alors vos donn\u00e9es. Vous pouvez les visualiser selon vos souhaits.<\/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-f423a38 e-flex e-con-boxed e-con\" data-id=\"f423a38\" 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-638050b elementor-widget elementor-widget-heading\" data-id=\"638050b\" 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\">Utiliser un connecteur pour Power BI et SQL Server<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fc82552 elementor-widget elementor-widget-text-editor\" data-id=\"fc82552\" 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>Dans cette m\u00e9thode, vous utilisez uniquement Power BI et un connecteur.<\/p><ol><li>Ouvrez Power BI Desktop (sur votre ordinateur).<\/li><li>Dans le panneau en haut de votre \u00e9cran, cliquez sur SQL Server.<\/li><li>Entrez ensuite le nom du serveur dans la bo\u00eete de dialogue \u2018Server\u2019 de SQL Server database. S\u00e9lectionnez \u2018DirectQuery\u2019. Dans la bo\u00eete de dialogue \u2018Name\u2019, vous pouvez sp\u00e9cifier le nom de votre base de donn\u00e9es.<\/li><li>Cliquez sur \u2018OK\u2019.<\/li><li>Vous obtenez alors votre tableau de donn\u00e9es et pouvez visualiser la data selon vos besoins.<\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-95ddef1 elementor-widget elementor-widget-text-editor\" data-id=\"95ddef1\" 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><strong>Cette approche est pratique si vous avez d\u00e9j\u00e0 connect\u00e9 SQL Server \u00e0 Power BI<\/strong>. Cr\u00e9er la connexion entre ces deux entit\u00e9s peut parfois \u00eatre laborieux. L\u2019autre inconv\u00e9nient appara\u00eet si vous s\u00e9lectionnez \u2018Import\u2019 comme votre Connectivity Mode. Toutes les donn\u00e9es sont import\u00e9es : il est alors difficile d\u2019exploiter le potentiel de visualisation de 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-f420dae e-flex e-con-boxed e-con\" data-id=\"f420dae\" 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-f4c8f79 elementor-widget elementor-widget-heading\" data-id=\"f4c8f79\" 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\">Exporter les donn\u00e9es SQL Server en Excel et les importer dans Power BI<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bdc7f56 elementor-widget elementor-widget-text-editor\" data-id=\"bdc7f56\" 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><span style=\"font-weight: 400;\">Ce processus est s\u00fbrement le plus chronophage, particuli\u00e8rement si vous r\u00e9p\u00e9tez cette t\u00e2che r\u00e9guli\u00e8rement. N\u00e9anmoins, cette m\u00e9thode old-school fonctionne \u00e0 merveille.\u00a0<\/span><\/p><p><b>\u00c9tape 1<\/b><span style=\"font-weight: 400;\"> : Dans SQL Server, faites un clic droit sur la base de donn\u00e9es contenant votre futur tableau. Cliquez ensuite sur \u2018Tasks\u2019 et \u2018Export Data\u2019.\u00a0<\/span><\/p><p><b>\u00c9tape 2<\/b><span style=\"font-weight: 400;\"> : Un panneau s\u2019ouvre : \u2018Choose a Data Source\u2019. S\u00e9lectionnez \u2018SQL Server Native CLient 11.0\u2019 comme source de donn\u00e9es et cliquez sur \u2018Next\u2019.<\/span><\/p><p><b>\u00c9tape 3 <\/b><span style=\"font-weight: 400;\">: Cliquez ensuite sur \u2018Microsoft Excel\u2019 pour la destination. D\u00e9terminez le parcours du fichier ainsi que son nom dans la bo\u00eete de dialogue \u2018Excel file path\u2019. Cliquez ensuite sur \u2018Next\u2019.<\/span><\/p><p><b>\u00c9tape 4<\/b><span style=\"font-weight: 400;\"> : Si vous souhaitez exporter des donn\u00e9es sp\u00e9cifiques, s\u00e9lectionnez \u2018Write a query to specify the data to transfer\u2019. Cliquez sur \u2018Next\u2019.<\/span><\/p><p><b>\u00c9tape 5<\/b><span style=\"font-weight: 400;\"> : Dans le panneau \u2018Provide a Source Query\u2019, entrez le script suivant :\u00a0<\/span><\/p><blockquote><p><b>SELECT * FROM tablename;<\/b><\/p><\/blockquote><p><span style=\"font-weight: 400;\">Cliquez sur \u2018Next\u2019.<\/span><\/p><p><span style=\"font-weight: 400;\">Dans les panneaux \u2018Select source tables and views\u2019 et \u2018Review data mapping type\u2019, cliquez sur \u2018Next\u2019. S\u00e9lectionnez ensuite \u2018Run immediately\u2019 dans le panneau \u2018Save and Run Package\u2019 et cliquez sur \u2018Finish\u2019.<\/span><\/p><p><b>\u00c9tape 6<\/b><span style=\"font-weight: 400;\"> : Ouvrez Power BI et s\u00e9lectionnez Excel dans le panneau en haut de votre \u00e9cran. Trouvez le fichier export\u00e9 de SQL Server.\u00a0<\/span><\/p><p><b>\u00c9tape 7<\/b><span style=\"font-weight: 400;\"> : Dans le panneau \u2018Navigator\u2019, s\u00e9lectionnez vos donn\u00e9es et cliquez sur \u2018Load\u2019.<\/span><\/p><p><span style=\"font-weight: 400;\">Vous verrez alors vos donn\u00e9es appara\u00eetre dans Power BI.<\/span><\/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-7f1870d e-flex e-con-boxed e-con\" data-id=\"7f1870d\" 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-41624a7 elementor-widget elementor-widget-heading\" data-id=\"41624a7\" 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-562374d elementor-widget elementor-widget-text-editor\" data-id=\"562374d\" 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><span style=\"font-weight: 400;\">Il existe plusieurs fa\u00e7ons de connecter SQL Server et Power BI, chacune avec ses propres <strong>avantages et inconv\u00e9nients<\/strong>. Vous pouvez utiliser un script R ou Python pour \u00e9tablir la connexion, utiliser un connecteur sp\u00e9cifique, ou exporter les donn\u00e9es SQL en Excel pour les importer sur Power BI. La m\u00e9thode \u00e0 utiliser d\u00e9pend de vos pr\u00e9f\u00e9rences et de vos <strong>besoins sp\u00e9cifiques<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">En utilisant l&rsquo;une de ces approches, vous pourrez <strong>facilement connecter<\/strong> SQL Server et Power BI pour acc\u00e9der \u00e0 vos donn\u00e9es et en tirer des insights pour am\u00e9liorer votre prise de d\u00e9cision.<\/span><\/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-5951c69 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"5951c69\" 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\/formation-power-bi\">\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\">En savoir plus sur 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-0f520dd e-flex e-con-boxed e-con\" data-id=\"0f520dd\" 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-b9d12b1 elementor-widget elementor-widget-html\" data-id=\"b9d12b1\" 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\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"SQL Server et Power BI connect\u00e9s gr\u00e2ce \u00e0 un script\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Pour connecter Power BI et SQL Server \u00e0 l\u2019aide d\u2019un script, vous pouvez utiliser R ou Python. Ici, vous retrouverez une m\u00e9thode bas\u00e9e sur le langage Python.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Exporter les donn\u00e9es SQL Server en Excel et les importer dans Power BI\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Ce processus est s\u00fbrement le plus chronophage, particuli\u00e8rement si vous r\u00e9p\u00e9tez cette t\u00e2che r\u00e9guli\u00e8rement. N\u00e9anmoins, cette m\u00e9thode old-school fonctionne \u00e0 merveille.\"\r\n    }\r\n  }]\r\n}\r\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 et Power BI sont deux outils compl\u00e9mentaires pour l\u2019analyse de vos donn\u00e9es. D\u2019un c\u00f4t\u00e9, SQL Server est un syst\u00e8me de gestion de base de donn\u00e9es (SGBD) permettant le stockage, le contr\u00f4le, le tri et la mise \u00e0 jour de base de donn\u00e9es gr\u00e2ce au langage SQL. De l\u2019autre c\u00f4t\u00e9, Power BI est outil [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":185521,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"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>Connecter Power BI et SQL Server : Comment faire ? | DataScientest.com<\/title>\n<meta name=\"description\" content=\"Power BI et SQL Server sont deux outils compl\u00e9mentaires en mati\u00e8re d&#039;analyse de donn\u00e9es. D\u00e9couvrez comment les connecter ensemble.\" \/>\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\/connecter-power-bi-et-sql-server\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecter Power BI et SQL Server : Comment faire ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/connecter-power-bi-et-sql-server\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-26T18:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/12\/connecter-power-bi-slq-server.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/connecter-power-bi-et-sql-server\",\"url\":\"https:\/\/datascientest.com\/connecter-power-bi-et-sql-server\",\"name\":\"Connecter Power BI et SQL Server : Comment faire ? | DataScientest.com\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-12-26T18:07:00+00:00\",\"dateModified\":\"2023-11-09T13:30:33+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Power BI et SQL Server sont deux outils compl\u00e9mentaires en mati\u00e8re d'analyse de donn\u00e9es. D\u00e9couvrez comment les connecter ensemble.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/connecter-power-bi-et-sql-server\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connecter Power BI et SQL Server : Comment faire ? | DataScientest.com","description":"Power BI et SQL Server sont deux outils compl\u00e9mentaires en mati\u00e8re d'analyse de donn\u00e9es. D\u00e9couvrez comment les connecter ensemble.","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\/connecter-power-bi-et-sql-server","og_locale":"fr_FR","og_type":"article","og_title":"Connecter Power BI et SQL Server : Comment faire ?","og_url":"https:\/\/datascientest.com\/connecter-power-bi-et-sql-server","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-12-26T18:07:00+00:00","article_modified_time":"2023-11-09T13:30:33+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/12\/connecter-power-bi-slq-server.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/connecter-power-bi-et-sql-server","url":"https:\/\/datascientest.com\/connecter-power-bi-et-sql-server","name":"Connecter Power BI et SQL Server : Comment faire ? | DataScientest.com","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-12-26T18:07:00+00:00","dateModified":"2023-11-09T13:30:33+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Power BI et SQL Server sont deux outils compl\u00e9mentaires en mati\u00e8re d'analyse de donn\u00e9es. D\u00e9couvrez comment les connecter ensemble.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/connecter-power-bi-et-sql-server"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/185497"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=185497"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/185497\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/185521"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=185497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=185497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=185497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}