{"id":218536,"date":"2024-01-04T06:30:00","date_gmt":"2024-01-04T06:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=218536"},"modified":"2023-12-28T14:40:02","modified_gmt":"2023-12-28T14:40:02","slug":"query-folding-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/query-folding-tout-savoir","title":{"rendered":"Query folding : Qu&rsquo;est-ce que c&rsquo;est ? Comment s&rsquo;en servir ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"218536\" class=\"elementor elementor-218536\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-020121c e-flex e-con-boxed e-con\" data-id=\"020121c\" 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-aeaa6c8 elementor-widget elementor-widget-heading\" data-id=\"aeaa6c8\" 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\">Confront\u00e9s \u00e0 des volumes de donn\u00e9es de plus en plus importants, les experts data disposent de nombreux outils pour simplifier le traitement de ces donn\u00e9es. Parmi lesquelles, le pliage de requ\u00eates sur Power BI Desktop ou Power Pivot. \u00c0 travers cette fonctionnalit\u00e9, vous pourrez am\u00e9liorer consid\u00e9rablement vos capacit\u00e9s d'analyse de donn\u00e9es.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f658d6e elementor-widget elementor-widget-text-editor\" data-id=\"f658d6e\" 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><span style=\"font-weight: 400;\">Alors qu\u2019est-ce que Power Query ? Comment \u00e7a fonctionne ? Et surtout, comment l\u2019utiliser ? DataScientest r\u00e9pond \u00e0 vos questions.\u00a0<\/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-683a6d0 e-flex e-con-boxed e-con\" data-id=\"683a6d0\" 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-c75d20d elementor-widget elementor-widget-heading\" data-id=\"c75d20d\" 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 Query folding ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ca54e23 elementor-widget elementor-widget-text-editor\" data-id=\"ca54e23\" 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;\">Le query folding (ou pliage de requ\u00eate) consiste \u00e0<\/span><b> g\u00e9n\u00e9rer une instruction unique visant \u00e0 r\u00e9cup\u00e9rer et transformer des donn\u00e9es sources<\/b><span style=\"font-weight: 400;\">. Ce faisant, le traitement de grand volume de donn\u00e9es est simplifi\u00e9.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Cette requ\u00eate est particuli\u00e8rement utilis\u00e9e pour la conception de mod\u00e8les de donn\u00e9es dans Power Pivot ou <a href=\"https:\/\/datascientest.com\/power-bi\">Power BI Desktop<\/a>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\"><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir<\/strong><\/span> : Il est possible d\u2019utiliser le query folding pour une requ\u00eate enti\u00e8re (pliage complet) ou seulement pour quelques \u00e9tapes (pliage partiel). <\/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-eb2fffc e-flex e-con-boxed e-con\" data-id=\"eb2fffc\" 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-32db736 elementor-widget elementor-widget-heading\" data-id=\"32db736\" 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 fonctionne query folding ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3b5e6c8 elementor-widget elementor-widget-text-editor\" data-id=\"3b5e6c8\" 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<span style=\"font-weight: 400;\">Pour utiliser le pliage de requ\u00eates, vous devez \u00e9crire un ensemble d&rsquo;instructions en <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">code SQL<\/a> et les transmettre \u00e0 la <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\">base de donn\u00e9es<\/a> pour que ces instructions soient ex\u00e9cut\u00e9es. L\u2019id\u00e9e est alors de<\/span><b> r\u00e9duire la quantit\u00e9 de donn\u00e9es \u00e0 la source <\/b><span style=\"font-weight: 400;\">avant de les traiter et de les transf\u00e9rer dans Power BI ou Power Pivot. Mais attention, pour que le query folding fonctionne correctement, il faut respecter les conditions ci-dessous :<\/span>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f21f322 elementor-widget elementor-widget-heading\" data-id=\"f21f322\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">La source de donn\u00e9es supporte le query folding<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e0a6441 elementor-widget elementor-widget-text-editor\" data-id=\"e0a6441\" 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;\">Rassurez-vous, <\/span><b>la majorit\u00e9 des sources acceptent le pliage de requ\u00eate<\/b><span style=\"font-weight: 400;\">. C\u2019est notamment le cas des <\/span><span style=\"font-weight: 400;\">bases de donn\u00e9es relationnelles, des flux OData, de SharePoint Lists, d\u2019Azure Synapse Analytics, d\u2019Exchange ou encore d\u2019Active Directory d\u2019HDFS, etc.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">En revanche, si vos donn\u00e9es proviennent d\u2019un fichier plat, d\u2019objets blob ou du web, vous ne pourrez utiliser le query folding.<\/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-d3f6bad elementor-widget elementor-widget-image\" data-id=\"d3f6bad\" 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=\"787\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding2.jpg\" class=\"attachment-full size-full wp-image-218576\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding2.jpg 787w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding2-300x191.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding2-768x488.jpg 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/>\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<div class=\"elementor-element elementor-element-d2705ae elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d2705ae\" 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\">Comprendre le query folding<\/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<div class=\"elementor-element elementor-element-81f94c8 elementor-widget elementor-widget-heading\" data-id=\"81f94c8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">La transformation permet le pliage de donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5da0dda elementor-widget elementor-widget-text-editor\" data-id=\"5da0dda\" 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;\">Au-del\u00e0 des sources de donn\u00e9es, les \u00e9tapes de la configuration doivent aussi permettre le pliage de requ\u00eates. G\u00e9n\u00e9ralement, il s\u2019agit des<\/span> <b>transformations pouvant \u00eatre \u00e9crites sous une instruction SELECT unique.<\/b><span style=\"font-weight: 400;\"> Voici quelques exemples :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">la suppression de colonnes ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">le filtrage de lignes (avec une requ\u00eate WHERE) ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">le regroupement de donn\u00e9es (avec une requ\u00eate GROUP BY) ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">la fusion non approximative (avec une requ\u00eate JOIN) ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">l\u2019ajout ou la suppression d\u2019un tableau crois\u00e9 dynamique. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85172e3 elementor-widget elementor-widget-text-editor\" data-id=\"85172e3\" 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;\">Si parmi toutes les \u00e9tapes d\u2019instruction, une seule action ne<\/span><span style=\"font-weight: 400;\"> peut \u00eatre pli\u00e9e, le query folding s&rsquo;arr\u00eatera pour l&rsquo;ensemble de la requ\u00eate. Voici quelques exemples de <\/span><span style=\"font-weight: 400;\">transformations emp\u00eachant le query folding :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">la fusion ou l\u2019ajout de requ\u00eates bas\u00e9es sur diff\u00e9rentes sources ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">l\u2019ajout de colonnes personnalis\u00e9es avec une logique complexe ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">l\u2019ajout de colonnes d\u2019index.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd48387 elementor-widget elementor-widget-text-editor\" data-id=\"cd48387\" 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;\">De mani\u00e8re g\u00e9n\u00e9rale, vous aurez des <\/span><b>difficult\u00e9s \u00e0 utiliser le pliage de requ\u00eate lorsque la transformation implique plusieurs sources<\/b><span style=\"font-weight: 400;\"> de donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\"><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir<\/strong><\/span> : si le query folding ne <\/span><span style=\"font-weight: 400;\">peut \u00eatre obtenu, c\u2019est le Moteur Mashup Power Query qui prend le relais en transformant lui-m\u00eame les donn\u00e9es. Mais cette op\u00e9ration est g\u00e9n\u00e9ralement plus lente ; d\u2019autant plus si vous souhaitez traiter de gros volumes de donn\u00e9es.<\/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-3e16ea8 elementor-widget elementor-widget-heading\" data-id=\"3e16ea8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">La requ\u00eate peut \u00eatre pli\u00e9e<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-528770b elementor-widget elementor-widget-text-editor\" data-id=\"528770b\" 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<span style=\"font-weight: 400;\">Pour savoir si une requ\u00eate peut \u00eatre pli\u00e9e, suivez les \u00e9tapes ci-dessous :\u00a0<\/span>\n<ul>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans l\u2019<a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">\u00e9diteur Power Query<\/a>, rendez-vous sur l\u2019onglet \u201cParam\u00e8tres\u201d de la requ\u00eate.\u00a0<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Faites un clic droit sur la derni\u00e8re \u00e9tape appliqu\u00e9e ;\u00a0<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V\u00e9rifiez l\u2019option \u201cAfficher la requ\u00eate native\u201d. Si elle est activ\u00e9e (non gris\u00e9e), la requ\u00eate peut \u00eatre pli\u00e9e. Si non, la requ\u00eate ne peut pas \u00eatre pli\u00e9e.<\/span><\/li>\n<\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-efc7dbb elementor-widget elementor-widget-text-editor\" data-id=\"efc7dbb\" 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;\"><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir<\/strong><\/span> : cette option \u00ab\u00a0Afficher la requ\u00eate native\u00a0\u00bb ne s\u2019affiche que pour <\/span><b>certains connecteurs<\/b><span style=\"font-weight: 400;\">. Par exemple, elle n\u2019est pas disponible pour les connecteurs OData. Si tel est le cas, utilisez la fonctionnalit\u00e9 \u00ab\u00a0Diagnostics de requ\u00eate\u00a0\u00bb.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par ailleurs, la requ\u00eate ne doit pas commencer par votre propre code SQL. \u00c0 d\u00e9faut, aucune \u00e9tape de la requ\u00eate ne sera pli\u00e9e.<\/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-d17a722 elementor-widget elementor-widget-image\" data-id=\"d17a722\" 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=\"648\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding1.jpg\" class=\"attachment-full size-full wp-image-218572\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding1.jpg 648w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding1-300x231.jpg 300w\" sizes=\"(max-width: 648px) 100vw, 648px\" \/>\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<div class=\"elementor-element elementor-element-e826988 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e826988\" 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\">Ma\u00eetriser le query folding<\/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-c3a95c1 e-flex e-con-boxed e-con\" data-id=\"c3a95c1\" 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-b2d686e elementor-widget elementor-widget-heading\" data-id=\"b2d686e\" 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 utiliser le pliage de requ\u00eate ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5829ab8 elementor-widget elementor-widget-text-editor\" data-id=\"5829ab8\" 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;\">Pour effectuer un pliage de requ\u00eate dans Power BI, voici les \u00e9tapes \u00e0 suivre :<\/span><\/p><ul><li aria-level=\"1\"><span style=\"font-weight: 400;\">Connectez-vous \u00e0 une <\/span><b>source de donn\u00e9es Power BI <\/b><span style=\"font-weight: 400;\">qui prend en charge le query folding. Pour cela, cliquez sur \u00ab\u00a0Obtenir des donn\u00e9es\u00a0\u00bb et choisissez la source de donn\u00e9es appropri\u00e9e.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Chargez les donn\u00e9es avant d\u2019effectuer toutes les modifications que vous souhaitez.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Transformer les donn\u00e9es\u00a0\u00bb, vous serez ainsi redirig\u00e9 vers l&rsquo;\u00e9diteur de requ\u00eate Power Query. Vous pourrez, par exemple, supprimer des colonnes, ajouter des lignes, trier les lignes d&rsquo;une colonne par ordre croissant, etc.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Retournez sur l\u2019onglet \u00ab\u00a0Accueil\u00a0\u00bb et cliquez sur \u201cFermer et appliquer\u201d pour charger les donn\u00e9es dans Power BI. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9d548c8 elementor-widget elementor-widget-text-editor\" data-id=\"9d548c8\" 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;\">Le processus peut ensuite \u00eatre r\u00e9p\u00e9t\u00e9 pour toutes les colonnes auxquelles vous souhaitez appliquer un query folding.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Si le pliage de requ\u00eate est indispensable \u00e0 la mod\u00e9lisation des donn\u00e9es, il ne s\u2019agit que d\u2019<\/span><b>une requ\u00eate parmi d\u2019autres<\/b><span style=\"font-weight: 400;\">. Pour g\u00e9rer efficacement d&rsquo;\u00e9normes volumes de donn\u00e9es, mieux vaut vous former avec DataScientest. <a href=\"https:\/\/datascientest.com\/formations-data\">D\u00e9couvrez nos formations<\/a>. <\/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-91f16e7 e-flex e-con-boxed e-con\" data-id=\"91f16e7\" 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-481e339 elementor-widget elementor-widget-heading\" data-id=\"481e339\" 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\">Ce qu\u2019il faut retenir :<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93fd35a elementor-widget elementor-widget-text-editor\" data-id=\"93fd35a\" 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<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">En g\u00e9n\u00e9rant une instruction unique pour transformer des ensembles de donn\u00e9es, le query folding simplifie le traitement des gros volumes de donn\u00e9es.&nbsp;<\/span><\/li>\n<li style=\"\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cependant, il ne peut \u00eatre utilis\u00e9 pour <\/span><b>toutes les requ\u00eates<\/b><span style=\"font-weight: 400;\">. En effet, les sources et les transformations demand\u00e9es doivent supporter le pliage de requ\u00eates. Et surtout, <\/span><b>la requ\u00eate doit \u00eatre pliable<\/b><span style=\"font-weight: 400;\">.&nbsp;<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Si toutes ces conditions sont r\u00e9unies, vous pourrez transformer de grands ensembles de donn\u00e9es depuis l\u2019\u00e9diteur de requ\u00eate Power Query.&nbsp;<\/span><\/li>\n<\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-91abff3 elementor-widget elementor-widget-image\" data-id=\"91abff3\" 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=\"803\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding3.jpg\" class=\"attachment-full size-full wp-image-218580\" alt=\"\" loading=\"lazy\" \/>\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<div class=\"elementor-element elementor-element-ad3c822 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ad3c822\" 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\">Apprendre \u00e0 utiliser le query folding<\/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-19cb234 e-flex e-con-boxed e-con\" data-id=\"19cb234\" 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\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>Confront\u00e9s \u00e0 des volumes de donn\u00e9es de plus en plus importants, les experts data disposent de nombreux outils pour simplifier le traitement de ces donn\u00e9es. Parmi lesquelles, le pliage de requ\u00eates sur Power BI Desktop ou Power Pivot. \u00c0 travers cette fonctionnalit\u00e9, vous pourrez am\u00e9liorer consid\u00e9rablement vos capacit\u00e9s d&rsquo;analyse de donn\u00e9es. Alors qu\u2019est-ce que Power [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":218547,"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>Query folding : Qu&#039;est-ce que c&#039;est ? Comment s&#039;en servir ?<\/title>\n<meta name=\"description\" content=\"Pour traiter de grands volumes de donn\u00e9es, les experts data peuvent utiliser le query folding (ou pliage de donn\u00e9es).\" \/>\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\/query-folding-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Query folding : Qu&#039;est-ce que c&#039;est ? Comment s&#039;en servir ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/query-folding-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-04T06:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-28T14:40:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding.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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/query-folding-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/query-folding-tout-savoir\",\"name\":\"Query folding : Qu'est-ce que c'est ? Comment s'en servir ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2024-01-04T06:30:00+00:00\",\"dateModified\":\"2023-12-28T14:40:02+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Pour traiter de grands volumes de donn\u00e9es, les experts data peuvent utiliser le query folding (ou pliage de donn\u00e9es).\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/query-folding-tout-savoir\"]}]},{\"@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":"Query folding : Qu'est-ce que c'est ? Comment s'en servir ?","description":"Pour traiter de grands volumes de donn\u00e9es, les experts data peuvent utiliser le query folding (ou pliage de donn\u00e9es).","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\/query-folding-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Query folding : Qu'est-ce que c'est ? Comment s'en servir ?","og_url":"https:\/\/datascientest.com\/query-folding-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2024-01-04T06:30:00+00:00","article_modified_time":"2023-12-28T14:40:02+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/query-folding.png","type":"image\/png"}],"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\/query-folding-tout-savoir","url":"https:\/\/datascientest.com\/query-folding-tout-savoir","name":"Query folding : Qu'est-ce que c'est ? Comment s'en servir ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2024-01-04T06:30:00+00:00","dateModified":"2023-12-28T14:40:02+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Pour traiter de grands volumes de donn\u00e9es, les experts data peuvent utiliser le query folding (ou pliage de donn\u00e9es).","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/query-folding-tout-savoir"]}]},{"@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\/218536"}],"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=218536"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/218536\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/218547"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=218536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=218536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=218536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}