{"id":91915,"date":"2020-09-06T15:18:00","date_gmt":"2020-09-06T14:18:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=91915"},"modified":"2023-11-09T13:33:41","modified_gmt":"2023-11-09T13:33:41","slug":"power-bi-direct-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/power-bi-direct-query","title":{"rendered":"Power BI Direct Query : tout savoir sur la m\u00e9thode de requ\u00eate de donn\u00e9es"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"91915\" class=\"elementor elementor-91915\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d228c2c e-flex e-con-boxed e-con\" data-id=\"d228c2c\" 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-086ef5b elementor-widget elementor-widget-heading\" data-id=\"086ef5b\" 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\">DirectQuery est une m\u00e9thode alternative de requ\u00eates de donn\u00e9es sur Power BI. D\u00e9couvrez tout ce que vous devez savoir sur DirectQuery.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b5541f2 elementor-widget elementor-widget-text-editor\" data-id=\"b5541f2\" 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>Au moment de travailler avec les donn\u00e9es sur Power BI, il est n\u00e9cessaire de <b>choisir<\/b> <strong>le mode de connectivit\u00e9<\/strong>. Le mode Import est g\u00e9n\u00e9ralement le plus utilis\u00e9, en combinaison avec le mod\u00e8le Tabulaire. Ceci permet d&rsquo;effectuer des requ\u00eates et de g\u00e9n\u00e9rer des rapports tr\u00e8s rapidement. Toutefois, une alternative moins connue est <b>DirectQuery<\/b>.<\/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-5d1acf6 e-flex e-con-boxed e-con\" data-id=\"5d1acf6\" 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-91711b1 elementor-widget elementor-widget-heading\" data-id=\"91711b1\" 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 DirectQuery ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e4b822e elementor-widget elementor-widget-text-editor\" data-id=\"e4b822e\" 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><a href=\"https:\/\/docs.microsoft.com\/fr-fr\/power-bi\/connect-data\/desktop-use-directquery\"><b>DirectQuery<\/b><\/a> est <strong>une m\u00e9thode permettant de r\u00e9cup\u00e9rer les donn\u00e9es<\/strong> directement depuis leurs sources, au moment de la requ\u00eate. Alors que le mode Import stocke un snapshot des donn\u00e9es en m\u00e9moire, DirectQuery (DQ) ne stocke aucune donn\u00e9e.<\/p><p>\u00c0 chaque requ\u00eate,<strong> les donn\u00e9es sont directement extraites de la source<\/strong>. Les donn\u00e9es r\u00e9sident donc au sein de la source originale avant, pendant et apr\u00e8s l&rsquo;ex\u00e9cution de la requ\u00eate.<\/p><p>\u00c0 chaque requ\u00eate, <strong>les utilisateurs g\u00e9n\u00e8rent une requ\u00eate<\/strong> ou un ensemble de requ\u00eates n\u00e9cessitant d&rsquo;\u00eatre ex\u00e9cut\u00e9es dans un ordre sp\u00e9cifique. Le mod\u00e8le Tabulaire est constitu\u00e9 du Formula Engine (FE) et du Storage Engine (SE). Le FE accepte les requ\u00eates, cr\u00e9e un plan de requ\u00eate, et g\u00e9n\u00e8re la requ\u00eate en fonction du choix entre les modes Import et DirectQuery pour cibler la source de donn\u00e9es correspondante.<\/p><p>Si le mode DirectyQuery est choisi, <strong>le Formula Engine traduit le DAX en SQL<\/strong> et envoie la requ\u00eate directement \u00e0 la source de donn\u00e9es. Les donn\u00e9es ne sont pas import\u00e9es par PowerBI \u00e0 partir des tableaux sous-jacents. Seules les m\u00e9tadonn\u00e9es sont conserv\u00e9es.<\/p><p>En utilisant <strong>les mod\u00e8les Composite de Power BI<\/strong>, il est possible de combiner les modes Import et DirectQuery au sein du mod\u00e8le de donn\u00e9es. L&rsquo;option privil\u00e9gi\u00e9e peut \u00eatre choisie pour chaque tableau. Notons qu&rsquo;il est possible de passer de DirectQuery au mode Import, mais pas l&rsquo;inverse.<\/p><p>Enfin,<strong> le mode Dual<\/strong> est une combinaison entre le mode Import et DirectQuery. Les donn\u00e9es en provenance du tableau sont charg\u00e9es dans la m\u00e9moire, mais peuvent aussi \u00eatre r\u00e9cup\u00e9r\u00e9es directement depuis la source au moment de la requ\u00eate.<\/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-7dfc75b elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"7dfc75b\" 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 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-8ce50b7 e-flex e-con-boxed e-con\" data-id=\"8ce50b7\" 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-2b18657 elementor-widget elementor-widget-heading\" data-id=\"2b18657\" 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\">Quand utiliser DirectQuery ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ad89a10 elementor-widget elementor-widget-text-editor\" data-id=\"ad89a10\" 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=\"color: #000000;\">Il est pr\u00e9f\u00e9rable d&rsquo;utiliser DirectQuery plut\u00f4t que le mode Import dans plusieurs situations. C&rsquo;est le cas <strong>si vous avez besoin de donn\u00e9es en temps r\u00e9el<\/strong>. En effet, le mode Import garde des snapshots de donn\u00e9es mis \u00e0 jour p\u00e9riodiquement. Le mode DQ est plus adapt\u00e9 pour les requ\u00eates en temps r\u00e9el.<\/span><\/p><p><span style=\"color: #000000;\">En outre, <strong>DirectQuery convient pour les larges mod\u00e8les de donn\u00e9es<\/strong>. Si un fichier .pbix de taille maximum n&rsquo;est pas suffisant, cette m\u00e9thode est plus adapt\u00e9e. Les donn\u00e9es restent \u00e0 la source et les calculs y sont effectu\u00e9s directement.<\/span><\/p><p><span style=\"color: #000000;\">En revanche, dans certains cas, DirectQuery n&rsquo;est pas le choix optimal. Si votre base de donn\u00e9es source n&rsquo;est <strong>pas optimis\u00e9e pour un workload analytique<\/strong>, et que les requ\u00eates ont besoin de cibler des tableaux multiples, le rapport g\u00e9n\u00e9r\u00e9 avec DQ sera erron\u00e9.<\/span><\/p><p><span style=\"color: #000000;\">Le<strong> nombre d&rsquo;utilisateurs interagissant en parall\u00e8le<\/strong> avec le rapport \u00e0 aussi un impact. Chaque utilisateur parall\u00e8le g\u00e9n\u00e8re des requ\u00eates simultan\u00e9es vers la source de donn\u00e9es sous-jacente. Il faut aussi prendre en compte les performances du serveur source et la latence du r\u00e9seau.<\/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-48a0764 elementor-widget__width-initial elementor-widget elementor-widget-video\" data-id=\"48a0764\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/yKTSLffVGbk&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.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-video .elementor-widget-container{overflow:hidden;transform:translateZ(0)}.elementor-widget-video .elementor-wrapper{aspect-ratio:var(--video-aspect-ratio)}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{height:100%;width:100%;display:flex;border:none;background-color:#000}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-wrapper{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .elementor-open-inline .elementor-custom-embed-image-overlay{position:absolute;top:0;right:0;bottom:0;left:0;background-size:cover;background-position:50%}.elementor-widget-video .elementor-custom-embed-image-overlay{cursor:pointer;text-align:center}.elementor-widget-video .elementor-custom-embed-image-overlay:hover .elementor-custom-embed-play i{opacity:1}.elementor-widget-video .elementor-custom-embed-image-overlay img{display:block;width:100%;aspect-ratio:var(--video-aspect-ratio);-o-object-fit:cover;object-fit:cover;-o-object-position:center center;object-position:center center}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-custom-embed-image-overlay{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-custom-embed-image-overlay img{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .e-hosted-video .elementor-video{-o-object-fit:cover;object-fit:cover}.e-con-inner>.elementor-widget-video,.e-con>.elementor-widget-video{width:var(--container-widget-width);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\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-f69a8ce e-flex e-con-boxed e-con\" data-id=\"f69a8ce\" 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-1f6909f elementor-widget elementor-widget-heading\" data-id=\"1f6909f\" 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 optimiser la source de donn\u00e9es ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-414a28c elementor-widget elementor-widget-text-editor\" data-id=\"414a28c\" 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=\"color: #000000;\">Il existe diff\u00e9rentes techniques permettant <strong>d&rsquo;am\u00e9liorer les performances<\/strong> de la source de donn\u00e9es. On peut ajouter des indexes, et veiller \u00e0 l&rsquo;int\u00e9grit\u00e9 des donn\u00e9es.<\/span><\/p><p>\u00a0<\/p><p><span style=\"color: #000000;\">Des <strong>objets persistants peuvent aussi \u00eatre cr\u00e9\u00e9s<\/strong> dans la base de donn\u00e9es source. Les agr\u00e9gations, transformations et calculs peuvent \u00eatre mat\u00e9rialis\u00e9s dans un tableau sp\u00e9cial ou une vue index\u00e9e. Ainsi, Power BI peut retrouver toutes les donn\u00e9es depuis un emplacement unique plut\u00f4t que d&rsquo;effectuer des op\u00e9rations complexes chaque fois qu&rsquo;une requ\u00eate est effectu\u00e9e.<\/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-b3794b5 e-flex e-con-boxed e-con\" data-id=\"b3794b5\" 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-a217242 elementor-widget elementor-widget-heading\" data-id=\"a217242\" 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\">Conseils et astuces pour Power BI et DirectQuery<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8f69f4 elementor-widget elementor-widget-text-editor\" data-id=\"f8f69f4\" 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=\"color: #000000;\">Plusieurs pratiques permettent d&rsquo;utiliser Power BI et DirectQuery d&rsquo;une mani\u00e8re optimale. Veillez d&rsquo;abord \u00e0 <strong>\u00e9viter les transformations Power Query complexes<\/strong>. Chaque transformation appliqu\u00e9e au mod\u00e8le de donn\u00e9es g\u00e9n\u00e8re une requ\u00eate transmise \u00e0 la base de donn\u00e9es sources.<\/span><\/p><p><span style=\"color: #000000;\">Si vous avez besoin d&rsquo;utiliser des colonnes calcul\u00e9es, cr\u00e9ez-les <strong>sur la base de donn\u00e9es source<\/strong> et conservez-les persistantes. \u00c9vitez aussi les mesures DAX complexes, car il est n\u00e9cessaire de traduire les d\u00e9clarations <a href=\"https:\/\/datascientest.com\/tout-savoir-sur-loutil-danalyse-de-requetes-en-langage-dax\">DAX<\/a> en <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">SQL<\/a>.<\/span><\/p><p><span style=\"color: #000000;\">\u00c9vitez <strong>les relations sur les colonnes GUID<\/strong>, car ce type de donn\u00e9es n&rsquo;est pas pris en charge par Power BI. Il sera donc n\u00e9cessaire d&rsquo;appliquer une conversion de donn\u00e9es pendant l&rsquo;ex\u00e9cution de la requ\u00eate. Les performances seront impact\u00e9es. La solution est de convertir ce type de donn\u00e9es au sein de la base source avant que Power BI g\u00e9n\u00e8re ses requ\u00eates.<\/span><\/p><p><span style=\"color: #000000;\">Limitez le parall\u00e9lisme autant que possible, en d\u00e9finissant <strong>un nombre maximum de connexions<\/strong> pouvant \u00eatre ouvertes en simultan\u00e9. Ce nombre peut \u00eatre configur\u00e9 dans les Options. Il est aussi pr\u00e9f\u00e9rable de limiter le nombre de visuels sur la page de rapport, car chaque visuel rallonge le temps n\u00e9cessaire pour la r\u00e9cup\u00e9ration de donn\u00e9es.<\/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-cff82d9 e-flex e-con-boxed e-con\" data-id=\"cff82d9\" 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-22bf266 elementor-widget elementor-widget-heading\" data-id=\"22bf266\" 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-68c856a elementor-widget__width-initial elementor-widget elementor-widget-video\" data-id=\"68c856a\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/8AjsMM_mEBs&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\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-219633f elementor-widget elementor-widget-text-editor\" data-id=\"219633f\" 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=\"color: #000000;\">La m\u00e9thode DirectQuery est l&rsquo;une des nombreuses fonctionnalit\u00e9s de Power BI. Pour apprendre \u00e0 utiliser cette plateforme, <strong>vous pouvez choisir les formations DataScientest<\/strong>.<\/span><\/p><p><span style=\"color: #000000;\">Le <strong>module Business Intelligence de notre formation Data Analyst<\/strong> aborde <a href=\"https:\/\/datascientest.com\/microsoft-power-bi-au-service-des-cabinets-dexpertise-comptable\">Power BI<\/a>, <a href=\"https:\/\/datascientest.com\/tableau-outil-de-business-intelligence\">Tableau<\/a> et le Data Modeling. Les autres modules de ce cursus couvrent la programmation en <a href=\"https:\/\/datascientest.com\/comment-combiner-python-et-power-bi-pour-la-data-science\">Python<\/a>, la visualisation de donn\u00e9es, la gestion de donn\u00e9es texte et le Big Data. \u00c0 l&rsquo;issue de la formation, vous aurez toutes les comp\u00e9tences pour devenir Data Analyst.<\/span><\/p><p><span style=\"color: #000000;\">Ce m\u00e9tier consiste \u00e0 <strong>analyser les donn\u00e9es d&rsquo;une entreprise<\/strong> pour l&rsquo;aider \u00e0 prendre de meilleures d\u00e9cisions. Les r\u00e9sultats des analyses sont partag\u00e9s sous forme de visualisations et de rapports, ce qui permet aux cadres et managers de les exploiter. Power Bi est l&rsquo;un des nombreux outils du <a href=\"https:\/\/datascientest.com\/bootcamp-data-analyst\">Data Analyst<\/a>.<\/span><\/p><p><span style=\"color: #000000;\">Les formations DataScientest se distinguent par <strong>une approche innovante de Blended Learning<\/strong>, alliant apprentissage en ligne et MasterClass en pr\u00e9sentiel. Le parcours peut \u00eatre compl\u00e9t\u00e9 en BootCamp intensif en quelques semaines, ou en Formation Continue afin de poursuivre une activit\u00e9 personnelle ou professionnelle en parall\u00e8le.<\/span><\/p><p><span style=\"color: #000000;\">Il est possible de financer ce cursus<strong> par le biais du Compte Personnel de Formation<\/strong>, et 85% des alumnis ont trouv\u00e9 du travail imm\u00e9diatement. D\u00e9couvrez la formation Data Analyst, et inscrivez-vous d\u00e8s \u00e0 pr\u00e9sent \u00e0 cette adresse.<\/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-b06d8d5 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"b06d8d5\" 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\">D\u00e9couvrir 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<div class=\"elementor-element elementor-element-e125ec0 elementor-widget elementor-widget-text-editor\" data-id=\"e125ec0\" 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>Vous savez tout sur DirectQuery pour Power BI. D\u00e9couvrez <strong><a href=\"https:\/\/datascientest.com\/power-bi\" target=\"_blank\" rel=\"noopener\">notre dossier complet sur Power BI<\/a><\/strong>, et <strong><a href=\"https:\/\/datascientest.com\/quest-ce-la-dataviz-le-point-avec-nos-data-experts\" target=\"_blank\" rel=\"noopener\">notre introduction \u00e0 la DataViz<\/a><\/strong>.<\/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\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9686fcf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9686fcf\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d65c49c\" data-id=\"d65c49c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dd267ee elementor-widget elementor-widget-html\" data-id=\"dd267ee\" 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\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"https:\/\/docs.microsoft.com\/fr-fr\/power-bi\/connect-data\/desktop-use-directquery\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"DirectQuery est une m\u00e9thode permettant de r\u00e9cup\u00e9rer les donn\u00e9es directement depuis leurs sources, au moment de la requ\u00eate. Alors que le mode Import stocke un snapshot des donn\u00e9es en m\u00e9moire, DirectQuery (DQ) ne stocke aucune donn\u00e9e.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Quand utiliser DirectQuery ?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Il est pr\u00e9f\u00e9rable d'utiliser DirectQuery plut\u00f4t que le mode Import dans plusieurs situations. C'est le cas si vous avez besoin de donn\u00e9es en temps r\u00e9el. En effet, le mode Import garde des snapshots de donn\u00e9es mis \u00e0 jour p\u00e9riodiquement. Le mode DQ est plus adapt\u00e9 pour les requ\u00eates en temps r\u00e9el.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Comment optimiser la source de donn\u00e9es ?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Il existe diff\u00e9rentes techniques permettant d'am\u00e9liorer les performances de la source de donn\u00e9es. On peut ajouter des indexes, et veiller \u00e0 l'int\u00e9grit\u00e9 des donn\u00e9es.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>DirectQuery est une m\u00e9thode alternative de requ\u00eates de donn\u00e9es sur Power BI. D\u00e9couvrez tout ce que vous devez savoir sur DirectQuery. Au moment de travailler avec les donn\u00e9es sur Power BI, il est n\u00e9cessaire de choisir le mode de connectivit\u00e9. Le mode Import est g\u00e9n\u00e9ralement le plus utilis\u00e9, en combinaison avec le mod\u00e8le Tabulaire. Ceci [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":96741,"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>Power BI Direct Query : tout savoir sur la m\u00e9thode de requ\u00eate de donn\u00e9es<\/title>\n<meta name=\"description\" content=\"DirectQuery est une m\u00e9thode alternative de requ\u00eates de donn\u00e9es sur Power BI. D\u00e9couvrez tout ce que vous devez savoir sur DirectQuery.\" \/>\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\/power-bi-direct-query\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI Direct Query : tout savoir sur la m\u00e9thode de requ\u00eate de donn\u00e9es\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/power-bi-direct-query\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-06T14:18:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:33:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/09\/directquery_sqlserverdb.png\" \/>\n\t<meta property=\"og:image:width\" content=\"860\" \/>\n\t<meta property=\"og:image:height\" content=\"529\" \/>\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=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/power-bi-direct-query\",\"url\":\"https:\/\/datascientest.com\/power-bi-direct-query\",\"name\":\"Power BI Direct Query : tout savoir sur la m\u00e9thode de requ\u00eate de donn\u00e9es\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2020-09-06T14:18:00+00:00\",\"dateModified\":\"2023-11-09T13:33:41+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"DirectQuery est une m\u00e9thode alternative de requ\u00eates de donn\u00e9es sur Power BI. D\u00e9couvrez tout ce que vous devez savoir sur DirectQuery.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/power-bi-direct-query\"]}]},{\"@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":"Power BI Direct Query : tout savoir sur la m\u00e9thode de requ\u00eate de donn\u00e9es","description":"DirectQuery est une m\u00e9thode alternative de requ\u00eates de donn\u00e9es sur Power BI. D\u00e9couvrez tout ce que vous devez savoir sur DirectQuery.","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\/power-bi-direct-query","og_locale":"fr_FR","og_type":"article","og_title":"Power BI Direct Query : tout savoir sur la m\u00e9thode de requ\u00eate de donn\u00e9es","og_url":"https:\/\/datascientest.com\/power-bi-direct-query","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2020-09-06T14:18:00+00:00","article_modified_time":"2023-11-09T13:33:41+00:00","og_image":[{"width":860,"height":529,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/09\/directquery_sqlserverdb.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/power-bi-direct-query","url":"https:\/\/datascientest.com\/power-bi-direct-query","name":"Power BI Direct Query : tout savoir sur la m\u00e9thode de requ\u00eate de donn\u00e9es","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2020-09-06T14:18:00+00:00","dateModified":"2023-11-09T13:33:41+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"DirectQuery est une m\u00e9thode alternative de requ\u00eates de donn\u00e9es sur Power BI. D\u00e9couvrez tout ce que vous devez savoir sur DirectQuery.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/power-bi-direct-query"]}]},{"@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\/91915"}],"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=91915"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/91915\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/96741"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=91915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=91915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=91915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}