{"id":176910,"date":"2022-11-07T13:52:06","date_gmt":"2022-11-07T13:52:06","guid":{"rendered":"https:\/\/datascientest.com\/?p=176910"},"modified":"2024-11-18T14:29:54","modified_gmt":"2024-11-18T14:29:54","slug":"jointure-power-bi","status":"publish","type":"post","link":"https:\/\/datascientest.com\/jointure-power-bi","title":{"rendered":"Jointure Power BI : Maitriser les diff\u00e9rents types de jointures"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"176910\" class=\"elementor elementor-176910\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a2a813a e-flex e-con-boxed e-con\" data-id=\"a2a813a\" 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-a6bc611 elementor-widget elementor-widget-text-editor\" data-id=\"a6bc611\" 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<h2>Les jointures Power BI permettent d&rsquo;\u00e9tablir des relations entre les tableaux de donn\u00e9es. D\u00e9couvrez tout ce que vous devez savoir sur cette fonctionnalit\u00e9 du logiciel de Business Intelligence de Microsoft.<\/h2>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-af33096 elementor-widget elementor-widget-text-editor\" data-id=\"af33096\" 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;\">Les entreprises du monde entier ont pris conscience des avantages de la <a href=\"https:\/\/datascientest.com\/business-intelligence\">Business Intelligence<\/a> et de la <a href=\"https:\/\/datascientest.com\/avec-la-data-visualisation-donnez-du-sens-a-vos-donnees\">Data Visualization<\/a>. Afin d&rsquo;en profiter, de nombreuses organisations adoptent la plateforme <strong>Power BI de Microsoft<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">Cet outil permet d&rsquo;assembler des donn\u00e9es en provenance de multiples sources, et de les analyser pour <strong>cr\u00e9er des rapports et des tableaux de bord<\/strong> agr\u00e9ment\u00e9s de visualisations claires et intuitives.<\/span><\/p><p><span style=\"font-weight: 400;\">Les tableaux de jointure de Power BI sont l&rsquo;une des fonctionnalit\u00e9s qui rendent ce logiciel si performant pour la Business Intelligence. D\u00e9couvrez tout ce que vous devez savoir \u00e0 ce sujet.<\/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-85d59cc e-flex e-con-boxed e-con\" data-id=\"85d59cc\" 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-e65b15b elementor-widget elementor-widget-heading\" data-id=\"e65b15b\" 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><h3 class=\"elementor-heading-title elementor-size-default\">Qu'est-ce que Power BI ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b7d5278 elementor-widget elementor-widget-text-editor\" data-id=\"b7d5278\" 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;\">Power BI est une <strong>plateforme de Business Intelligence d\u00e9velopp\u00e9e par Microsoft<\/strong>. Les utilisateurs peuvent s&rsquo;en servir pour analyser les donn\u00e9es et cr\u00e9er des rapports et des tableaux de bord.<\/span><\/p><p><span style=\"font-weight: 400;\">Cet outil permet de collecter des donn\u00e9es en provenance d&rsquo;une large vari\u00e9t\u00e9 de sources gr\u00e2ce \u00e0 de nombreux connecteurs. Il permet \u00e9galement de filtrer les <a href=\"https:\/\/datascientest.com\/dataset-definition\">datasets<\/a> pour se focaliser sur des donn\u00e9es sp\u00e9cifiques.<\/span><\/p><p><span style=\"font-weight: 400;\">En outre, Power BI regroupe de nombreux <strong>templates<\/strong> de visualisations de donn\u00e9es permettant de cr\u00e9er facilement des tableaux de bord et des rapports interactifs.<\/span><\/p><p><span style=\"font-weight: 400;\">Power BI est disponible sous forme de logiciel pour <strong>PC<\/strong>, d&rsquo;application <strong>mobile<\/strong> pour smartphone et tablette, ou de service cloud. Il s&rsquo;agit aujourd&rsquo;hui de l&rsquo;un des principaux outils de Business Intelligence.<\/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-e4764d7 elementor-widget elementor-widget-image\" data-id=\"e4764d7\" data-element_type=\"widget\" data-widget_type=\"image.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-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/Microsoft-Power-BI-Logo-1024x576.png\" class=\"attachment-large size-large wp-image-176919\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/Microsoft-Power-BI-Logo-1024x576.png 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/Microsoft-Power-BI-Logo-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/Microsoft-Power-BI-Logo-768x432.png 768w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/Microsoft-Power-BI-Logo-1536x864.png 1536w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/Microsoft-Power-BI-Logo-2048x1152.png 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\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-c6fdf41 e-flex e-con-boxed e-con\" data-id=\"c6fdf41\" 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-0c20b7e elementor-widget elementor-widget-heading\" data-id=\"0c20b7e\" 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\">Qu'est-ce que les jointures sur Power BI ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-819694b elementor-widget elementor-widget-text-editor\" data-id=\"819694b\" 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;\">Lors d&rsquo;une mod\u00e9lisation sur Power BI, il ne suffit pas d&rsquo;amasser les donn\u00e9es dans un tableau. Les jointures ou <strong>Joining Tables<\/strong> permettent de construire des relations entre les donn\u00e9es.<\/span><\/p><p><span style=\"font-weight: 400;\">Il est tr\u00e8s facile de construire des relations entre les tableaux, et le logiciel peut les d\u00e9tecter automatiquement. Toutefois, il peut \u00eatre pr\u00e9f\u00e9rable d&rsquo;\u00e9tablir les liens manuellement pour savoir quelles colonnes connectent deux tableaux et \u00e9viter la <strong>cr\u00e9ation de boucles<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">L&rsquo;onglet de <strong>\u00ab Vue des Relations \u00bb<\/strong> est accessible en cliquant sur l&rsquo;ic\u00f4ne de fl\u00e8che rouge dans Power BI. Il est possible de configurer les jointures en utilisant les commandes de s\u00e9lection et de <strong>glisser-d\u00e9poser<\/strong> avec les colonnes communes de chaque tableau.<\/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-0ede46b e-flex e-con-boxed e-con\" data-id=\"0ede46b\" 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-9397c4c elementor-widget elementor-widget-heading\" data-id=\"9397c4c\" 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\">Les diff\u00e9rents types de jointures Power BI<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a953ac8 elementor-widget elementor-widget-text-editor\" data-id=\"a953ac8\" 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 diff\u00e9rents types de jointures Power BI, permettant d&rsquo;\u00e9tablir les relations entre <strong>deux tableaux A et B<\/strong>. Les jointures internes renvoient uniquement les lignes correspondantes que l&rsquo;on retrouve dans les <strong>deux tableaux A et B<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">La jointure externe droite prend en compte toutes les <strong>lignes<\/strong> du tableau B, et retourne les lignes correspondantes du tableau A. Au contraire, la jointure externe gauche prend en compte toutes les lignes du tableau A et retourne les lignes du tableau B correspondantes.<\/span><\/p><p><span style=\"font-weight: 400;\">Une jointure externe enti\u00e8re prend en compte toutes les lignes du <strong>tableau A<\/strong> et toutes les lignes du <strong>tableau B<\/strong>, et retourne un tableau contenant tous les enregistrements correspondant \u00e0 ceux de ces deux tableaux.<\/span><\/p><p><span style=\"font-weight: 400;\">Contrairement aux jointures externes, la jointure interne retourne uniquement les lignes que l&rsquo;on retrouve dans les deux tableaux A et B. La jointure oppos\u00e9e droite retourne toutes les lignes du tableau B sans correspondance dans le tableau A, et la jointure oppos\u00e9e gauche retourne toutes les lignes du tableau A sans correspondance dans le tableau B.<\/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-bd00826 elementor-widget elementor-widget-image\" data-id=\"bd00826\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"439\" height=\"372\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/2020-11-24_202735.png\" class=\"attachment-large size-large wp-image-176920\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/2020-11-24_202735.png 439w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/2020-11-24_202735-300x254.png 300w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/>\t\t\t\t\t\t\t\t\t\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-3f6c13d e-flex e-con-boxed e-con\" data-id=\"3f6c13d\" 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-9bee038 elementor-widget elementor-widget-heading\" data-id=\"9bee038\" 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\">Comment changer le type de jointure Power BI avec un script M ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f2827b elementor-widget elementor-widget-text-editor\" data-id=\"7f2827b\" 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;\">\u00c0 partir de l&rsquo;<strong>Editeur Avanc\u00e9<\/strong> de Power BI, il est possible d&rsquo;alt\u00e9rer le script M pour appliquer des changements aux jointures de Power BI. Il suffit de naviguer jusqu&rsquo;\u00e0 l&rsquo;onglet Vue et de s\u00e9lectionner l&rsquo;Editeur Avanc\u00e9.<\/span><\/p><p><span style=\"font-weight: 400;\">Le <strong>script M<\/strong> cr\u00e9ant les r\u00e9sultats des jointures Power BI est accessible dans la fen\u00eatre de requ\u00eate de l&rsquo;Editeur Avanc\u00e9. Pour changer le type de jointure, vous devez modifier le <strong>JoinKind<\/strong> de la fonction jointure du script.<\/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-bb6c87f e-flex e-con-boxed e-con\" data-id=\"bb6c87f\" 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-9bf9ed3 elementor-widget elementor-widget-heading\" data-id=\"9bf9ed3\" 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\">Comment apprendre \u00e0 utiliser Power BI ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8efbc1 elementor-widget elementor-widget-text-editor\" data-id=\"f8efbc1\" 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;\">Les jointures font partie des fonctionnalit\u00e9s tr\u00e8s utiles de Power BI. Afin d&rsquo;apprendre \u00e0 manier toutes les subtilit\u00e9s de cet outil de Business Intelligence, vous pouvez vous tourner vers <strong>DataScientest<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">Notre formation permet \u00e0 un d\u00e9butant de ma\u00eetriser int\u00e9gralement Power BI en seulement <strong>38 heures<\/strong>, r\u00e9parties sur cinq jours. En guise d&rsquo;alternative, nous proposons aussi une formation d&rsquo;initiation de 3 jours pour les d\u00e9butants et une <strong>formation d&rsquo;approfondissement sur deux jours<\/strong> pour les utilisateurs confirm\u00e9s.<\/span><\/p><p><span style=\"font-weight: 400;\">Le programme couvre notamment le moteur <strong>Power Query<\/strong>, le <strong>langage DAX<\/strong>, la <strong>DataViz<\/strong> et toutes les fonctionnalit\u00e9s de Power BI. En tant que <strong>Microsoft Learning Partner<\/strong>, <strong>DataScientest<\/strong> est habilit\u00e9 \u00e0 faire passer l&rsquo;<a href=\"https:\/\/datascientest.com\/cours-power-bi\">examen officiel PL-300<\/a> permettant d&rsquo;obtenir la <a href=\"https:\/\/datascientest.com\/pl-300-tout-savoir\">certification Microsoft Power BI Data Analyst Associate<\/a>.<\/span><\/p><p><span style=\"font-weight: 400;\">Nos formations s&rsquo;effectuent int\u00e9gralement \u00e0 distance, via internet. Concernant le financement, notre organisme est reconnu par l&rsquo;\u00c9tat et \u00e9ligible au <a href=\"https:\/\/datascientest.com\/cpf-comment-utiliser-son-compte-personnel-de-formation\">Compte Personnel de Formation<\/a> ou \u00e0 la prise en charge par P\u00f4le Emploi. N&rsquo;attendez plus et d\u00e9couvrez DataScientest !<\/span><\/p><p><span style=\"font-weight: 400;\">Vous savez tout sur les jointures Power BI. Pour plus d&rsquo;informations sur ce sujet, d\u00e9couvrez <a href=\"https:\/\/datascientest.com\/power-bi-direct-query\">notre dossier complet sur Power Query<\/a> et <a href=\"https:\/\/datascientest.com\/dax-power-bi\">notre dossier sur le langage DAX<\/a>.<\/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-1e6ac72 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1e6ac72\" 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 la formation 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-388dc6b e-flex e-con-boxed e-con\" data-id=\"388dc6b\" 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-d439282 elementor-widget elementor-widget-html\" data-id=\"d439282\" 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\": \"Qu'est-ce que les jointures sur Power BI ?\u200b\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Lors d'une mod\u00e9lisation sur Power BI, il ne suffit pas d'amasser les donn\u00e9es dans un tableau. Les jointures ou Joining Tables permettent de construire des relations entre les donn\u00e9es.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment changer le type de jointure Power BI avec un script M ?\u200b\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"\u00c0 partir de l'Editeur Avanc\u00e9 de Power BI, il est possible d'alt\u00e9rer le script M pour appliquer des changements aux jointures de Power BI. Il suffit de naviguer jusqu'\u00e0 l'onglet Vue et de s\u00e9lectionner l'Editeur Avanc\u00e9.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est-ce que Power BI ?\u200b\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power BI est une plateforme de Business Intelligence d\u00e9velopp\u00e9e par Microsoft. Les utilisateurs peuvent s'en servir pour analyser les donn\u00e9es et cr\u00e9er des rapports et des tableaux de bord.\r\nCet outil permet de collecter des donn\u00e9es en provenance d'une large vari\u00e9t\u00e9 de sources gr\u00e2ce \u00e0 de nombreux connecteurs. Il permet \u00e9galement de filtrer les datasets pour se focaliser sur des donn\u00e9es sp\u00e9cifiques.\"\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>Les jointures Power BI permettent d&rsquo;\u00e9tablir des relations entre les tableaux de donn\u00e9es. D\u00e9couvrez tout ce que vous devez savoir sur cette fonctionnalit\u00e9 du logiciel de Business Intelligence de Microsoft. Les entreprises du monde entier ont pris conscience des avantages de la Business Intelligence et de la Data Visualization. Afin d&rsquo;en profiter, de nombreuses organisations [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":176912,"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>Jointure Power BI : Maitriser les diff\u00e9rents types de jointures<\/title>\n<meta name=\"description\" content=\"Les jointures Power BI permettent d&#039;\u00e9tablir des relations entre les tableaux de donn\u00e9es. D\u00e9couvrez tout ce que vous devez savoir sur cette fonctionnalit\u00e9 du logiciel de Business Intelligence de Microsoft.\" \/>\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\/jointure-power-bi\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jointure Power BI : Maitriser les diff\u00e9rents types de jointures\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/jointure-power-bi\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-07T13:52:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-18T14:29:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/jointure-powerbi.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/jointure-power-bi\",\"url\":\"https:\/\/datascientest.com\/jointure-power-bi\",\"name\":\"Jointure Power BI : Maitriser les diff\u00e9rents types de jointures\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-11-07T13:52:06+00:00\",\"dateModified\":\"2024-11-18T14:29:54+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Les jointures Power BI permettent d'\u00e9tablir des relations entre les tableaux de donn\u00e9es. D\u00e9couvrez tout ce que vous devez savoir sur cette fonctionnalit\u00e9 du logiciel de Business Intelligence de Microsoft.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/jointure-power-bi\"]}]},{\"@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":"Jointure Power BI : Maitriser les diff\u00e9rents types de jointures","description":"Les jointures Power BI permettent d'\u00e9tablir des relations entre les tableaux de donn\u00e9es. D\u00e9couvrez tout ce que vous devez savoir sur cette fonctionnalit\u00e9 du logiciel de Business Intelligence de Microsoft.","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\/jointure-power-bi","og_locale":"fr_FR","og_type":"article","og_title":"Jointure Power BI : Maitriser les diff\u00e9rents types de jointures","og_url":"https:\/\/datascientest.com\/jointure-power-bi","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-11-07T13:52:06+00:00","article_modified_time":"2024-11-18T14:29:54+00:00","og_image":[{"width":900,"height":500,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/09\/jointure-powerbi.jpg","type":"image\/jpeg"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/jointure-power-bi","url":"https:\/\/datascientest.com\/jointure-power-bi","name":"Jointure Power BI : Maitriser les diff\u00e9rents types de jointures","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-11-07T13:52:06+00:00","dateModified":"2024-11-18T14:29:54+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Les jointures Power BI permettent d'\u00e9tablir des relations entre les tableaux de donn\u00e9es. D\u00e9couvrez tout ce que vous devez savoir sur cette fonctionnalit\u00e9 du logiciel de Business Intelligence de Microsoft.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/jointure-power-bi"]}]},{"@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\/176910"}],"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=176910"}],"version-history":[{"count":1,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/176910\/revisions"}],"predecessor-version":[{"id":256913,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/176910\/revisions\/256913"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/176912"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=176910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=176910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=176910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}