{"id":510,"date":"2023-03-29T18:18:33","date_gmt":"2023-03-29T16:18:33","guid":{"rendered":"https:\/\/www.nicedata.fr\/?p=510"},"modified":"2024-08-20T14:49:14","modified_gmt":"2024-08-20T12:49:14","slug":"creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse","status":"publish","type":"post","link":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/","title":{"rendered":"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Notre DataLakeHouse contient physiquement des fichiers de donn\u00e9es. Ceux-ci sont organis\u00e9s, nettoy\u00e9s, repr\u00e9sentent un mod\u00e8le de donn\u00e9e d\u00e9fini sur la \u00ab\u00a0derni\u00e8re\u00a0\u00bb couche et \u00e9ventuellement de formats diff\u00e9rents. Nous pouvons donc lire nos donn\u00e9es depuis ces fichiers et travailler dessus pour faire ce que l&rsquo;on en veut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Un des principaux cas d&rsquo;usage est de connecter un outil de reporting pour faire de l&rsquo;analyse de donn\u00e9e. Dans un pr\u00e9c\u00e9dent article (<a href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/\">Rafraichir un dataset Power BI depuis Azure Synapse Analytics &#8211; NiceData<\/a>) nous avons vu comment rafraichir les donn\u00e9es de notre Dataset Power BI directement depuis Synapse. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons dans cet article nous int\u00e9resser \u00e0 comment cr\u00e9er un dataset Power BI sur les fichiers de notre DataLakeHouse\/<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Sommaire<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#Introduction_et_Prerequis\" >Introduction et Pr\u00e9requis<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#Mise_en_place\" >Mise en place<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#Creation_de_vues_dans_le_Pool_SQL_Serverless\" >Cr\u00e9ation de vues dans le Pool SQL Serverless<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#Connexion_a_notre_%C2%AB_Data_Warehouse_%C2%BB\" >Connexion \u00e0 notre \u00ab\u00a0Data Warehouse\u00a0\u00bb<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#Import_des_donnees_depuis_Power_BI\" >Import des donn\u00e9es depuis Power BI<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction_et_Prerequis\"><\/span>Introduction et Pr\u00e9requis<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dans notre paradigme du DataLakeHouse, nous avons besoin des fichiers de donn\u00e9es dans notre Lake. Pour notre cas d&rsquo;usage, j&rsquo;utilise des fichiers parquet pour mes tables de faits et des fichiers csv pour mes dimensions. Pourquoi ? Parce que c&rsquo;est l&rsquo;avantage d&rsquo;un DataLakeHouse, on est libre sur la partie \u00ab\u00a0stockage\u00a0\u00bb. L&rsquo;important est comment on expose ces diff\u00e9rents formats \u00e0 l&rsquo;ext\u00e9rieur. Nous partons pour notre exemple du postulat que nous avons d\u00e9j\u00e0 nos fichiers dans notre Lake.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"312\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/02\/image-1.png?resize=659%2C312&#038;ssl=1\" alt=\"\" class=\"wp-image-512\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/02\/image-1.png?w=659&amp;ssl=1 659w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/02\/image-1.png?resize=300%2C142&amp;ssl=1 300w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><figcaption class=\"wp-element-caption\">Nos fichiers sources<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Mise_en_place\"><\/span>Mise en place<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_de_vues_dans_le_Pool_SQL_Serverless\"><\/span>Cr\u00e9ation de vues dans le Pool SQL Serverless<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">La premi\u00e8re chose \u00e0 faire est de cr\u00e9er des vues ou tables externes dans le Pool SQL Serverless afin de pouvoir lire les fichiers pr\u00e9sents dans notre lake directement depuis n&rsquo;importe quel client SQL.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Utilisation de l&rsquo;interface Azure pour g\u00e9n\u00e9rer les scripts<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">La m\u00e9thode la plus simple est d&rsquo;utiliser directement l&rsquo;interface de Synapse pour g\u00e9n\u00e9rer automatiquement nos objets SQL. Pour se faire, il faut se rendre dans la page li\u00e9e \u00e0 nos Data et naviguer jusqu&rsquo;\u00e0 nos fichiers de donn\u00e9es.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"778\" height=\"373\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image.png?resize=778%2C373&#038;ssl=1\" alt=\"\" class=\"wp-image-515\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image.png?w=778&amp;ssl=1 778w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image.png?resize=300%2C144&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image.png?resize=768%2C368&amp;ssl=1 768w\" sizes=\"auto, (max-width: 778px) 100vw, 778px\" \/><figcaption class=\"wp-element-caption\">Navigation vers nos donn\u00e9es<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Ensuite, sur chaque fichier, un clic droit nous offre diff\u00e9rentes possibilit\u00e9s de g\u00e9n\u00e9ration de script. Nous allons nous int\u00e9resser \u00e0 la cr\u00e9ation de tables externe en SQL.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"551\" height=\"467\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-2.png?resize=551%2C467&#038;ssl=1\" alt=\"\" class=\"wp-image-517\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-2.png?w=551&amp;ssl=1 551w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-2.png?resize=300%2C254&amp;ssl=1 300w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><figcaption class=\"wp-element-caption\">G\u00e9n\u00e9ration d&rsquo;un script SQL<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Synapse travail seul dans son coin et nous propose quelques param\u00e8tres suivant le type de fichier source s\u00e9lectionn\u00e9.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour un fichier Parquet, c&rsquo;est relativement simple, nous ne configurons que la taille maximum des champs de type string.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"634\" height=\"443\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-3.png?resize=634%2C443&#038;ssl=1\" alt=\"\" class=\"wp-image-518\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-3.png?w=634&amp;ssl=1 634w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-3.png?resize=300%2C210&amp;ssl=1 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><figcaption class=\"wp-element-caption\">Param\u00e8tres de lecture du fichier parquet<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Pour un fichier CSV, <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"630\" height=\"746\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-22.png?resize=630%2C746&#038;ssl=1\" alt=\"\" class=\"wp-image-538\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-22.png?w=630&amp;ssl=1 630w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-22.png?resize=253%2C300&amp;ssl=1 253w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><figcaption class=\"wp-element-caption\">Param\u00e8tres de lecture du CSV<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">En ce qui concerne la cr\u00e9ation de nos objets, la premi\u00e8re chose que nous synapse est sur quel serveur nous souhaitons cr\u00e9er nos objets. Dans notre cas nous utilisons le pool Serverless int\u00e9gr\u00e9 \u00e0 Synapse qui s&rsquo;appelle \u00ab\u00a0Built-in\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"500\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-5.png?resize=632%2C500&#038;ssl=1\" alt=\"\" class=\"wp-image-520\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-5.png?w=632&amp;ssl=1 632w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-5.png?resize=300%2C237&amp;ssl=1 300w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><figcaption class=\"wp-element-caption\">S\u00e9lection du Pool Serverless comme cible de cr\u00e9ation<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">L&rsquo;\u00e9tape suivante consiste \u00e0 s\u00e9lectionner dans quelle base de donn\u00e9es cr\u00e9\u00e9e notre objet. Il nous est de plus propos\u00e9 de cr\u00e9er une nouvelle \u00ab\u00a0Base\u00a0\u00bb directement. Ce que nous allons faire dans notre cas : <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"630\" height=\"498\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-6.png?resize=630%2C498&#038;ssl=1\" alt=\"\" class=\"wp-image-521\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-6.png?w=630&amp;ssl=1 630w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-6.png?resize=300%2C237&amp;ssl=1 300w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><figcaption class=\"wp-element-caption\">S\u00e9lection de la base de donn\u00e9e cible<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"315\" height=\"499\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-7.png?resize=315%2C499&#038;ssl=1\" alt=\"\" class=\"wp-image-522\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-7.png?w=315&amp;ssl=1 315w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-7.png?resize=189%2C300&amp;ssl=1 189w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><figcaption class=\"wp-element-caption\">cr\u00e9ation d&rsquo;une nouvelle base<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"633\" height=\"498\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-11.png?resize=633%2C498&#038;ssl=1\" alt=\"\" class=\"wp-image-526\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-11.png?w=633&amp;ssl=1 633w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-11.png?resize=300%2C236&amp;ssl=1 300w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><figcaption class=\"wp-element-caption\">Configuration du nom de notre future table et g\u00e9n\u00e9ration du script<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Une fois compl\u00e8tement configur\u00e9, il suffit d&rsquo;ouvrir et ex\u00e9cut\u00e9 le script que synapse a g\u00e9n\u00e9r\u00e9 pour nous :<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"482\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-10.png?resize=1024%2C482&#038;ssl=1\" alt=\"\" class=\"wp-image-525\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-10.png?resize=1024%2C482&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-10.png?resize=300%2C141&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-10.png?resize=768%2C361&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-10.png?resize=1536%2C723&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-10.png?w=1575&amp;ssl=1 1575w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Nous n&rsquo;allons pas analyser ce script qui n&rsquo;est pas l&rsquo;objet de cet article, mais simplement l&rsquo;utiliser tel quel (enfin presque). Une fois sur ce script, il est possible de le renommer et lui donner une description, puis de configurer la connexion SQL \u00e0 utiliser avant de pouvoir l&rsquo;ex\u00e9cuter : <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"81\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-13.png?resize=969%2C81&#038;ssl=1\" alt=\"\" class=\"wp-image-528\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-13.png?w=969&amp;ssl=1 969w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-13.png?resize=300%2C25&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-13.png?resize=768%2C64&amp;ssl=1 768w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><figcaption class=\"wp-element-caption\">Configuration de la connexion SQL a utiliser pour le script<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Si comme moi vous avez sp\u00e9cifi\u00e9 un sch\u00e9ma sp\u00e9cifique qui n&rsquo;existe pas encore dans la base de donn\u00e9es, il faudra imp\u00e9rativement le cr\u00e9er avant sous peine de rencontrer une erreur d&rsquo;ex\u00e9cution. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour cr\u00e9er un sch\u00e9ma, il n&rsquo;y a rien de plus simple : <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"559\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-14.png?resize=1024%2C559&#038;ssl=1\" alt=\"\" class=\"wp-image-529\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-14.png?resize=1024%2C559&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-14.png?resize=300%2C164&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-14.png?resize=768%2C419&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-14.png?w=1095&amp;ssl=1 1095w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Ajout de la cr\u00e9ation du sch\u00e9ma \u00e0 notre script SQL<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Le script g\u00e9n\u00e9r\u00e9 par Synapse fait un \u00ab\u00a0Select\u00a0\u00bb de la nouvelle table cr\u00e9er et donc \u00e0 la fin de l&rsquo;ex\u00e9cution de celui-ci nous devons voir le r\u00e9sultat de cette instruction dans l&rsquo;onglet de r\u00e9sultat :<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"694\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-16.png?resize=1024%2C694&#038;ssl=1\" alt=\"\" class=\"wp-image-531\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-16.png?resize=1024%2C694&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-16.png?resize=300%2C203&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-16.png?resize=768%2C520&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-16.png?w=1246&amp;ssl=1 1246w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Le r\u00e9sultat du select dans notre nouvelle table externe<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Un refresh de notre espace de travail dans l&rsquo;espace \u00ab\u00a0Data\u00a0\u00bb nous permet maintenant de voir notre table externe cr\u00e9er dans notre base de donn\u00e9es nouvellement cr\u00e9e en tant que \u00ab\u00a0SQL database\u00a0\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"324\" height=\"791\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-17.png?resize=324%2C791&#038;ssl=1\" alt=\"\" class=\"wp-image-533\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-17.png?w=324&amp;ssl=1 324w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-17.png?resize=123%2C300&amp;ssl=1 123w\" sizes=\"auto, (max-width: 324px) 100vw, 324px\" \/><figcaption class=\"wp-element-caption\">Table externe sur notre BDD SQL<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Nous pouvons maintenant cr\u00e9er l&rsquo;ensemble de nos tables externe pour cr\u00e9er notre DWH complet. Si vous n&rsquo;avez pas l&rsquo;intention de conserver le script de cr\u00e9ation de la table externe, il est possible de cr\u00e9er la table \u00ab\u00a0Automatiquement\u00a0\u00bb au lieu de g\u00e9n\u00e9rer le Script de cr\u00e9ation.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"629\" height=\"499\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-20.png?resize=629%2C499&#038;ssl=1\" alt=\"\" class=\"wp-image-536\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-20.png?w=629&amp;ssl=1 629w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-20.png?resize=300%2C238&amp;ssl=1 300w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><figcaption class=\"wp-element-caption\">Cr\u00e9ation automatique de notre table<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Cette fois-ci, le script g\u00e9n\u00e9r\u00e9 est plus succinct et nous propose simplement de requ\u00eater notre table pour v\u00e9rifier que tout \u00e0 fonctionn\u00e9.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"988\" height=\"197\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-21.png?resize=988%2C197&#038;ssl=1\" alt=\"\" class=\"wp-image-537\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-21.png?w=988&amp;ssl=1 988w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-21.png?resize=300%2C60&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-21.png?resize=768%2C153&amp;ssl=1 768w\" sizes=\"auto, (max-width: 988px) 100vw, 988px\" \/><figcaption class=\"wp-element-caption\">Script g\u00e9n\u00e9r\u00e9<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Une fois l&rsquo;ensemble des tables externes g\u00e9n\u00e9r\u00e9, nous pouvons d\u00e9cr\u00e9ter notre \u00ab\u00a0Data Warehouse\u00a0\u00bb cr\u00e9\u00e9 !<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Connexion_a_notre_%C2%AB_Data_Warehouse_%C2%BB\"><\/span>Connexion \u00e0 notre \u00ab\u00a0Data Warehouse\u00a0\u00bb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Nous avons pu voir depuis l&rsquo;interface Synapse nos tables de donn\u00e9es et des scripts SQL, mais le plus int\u00e9ressant est que celui-ci est accessible comme n&rsquo;importe quelle base de donn\u00e9es SQL Serveur sur Azure.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Les chaines de connexion peuvent se trouver directement dans Synapse studio sur la page management.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"322\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-23.png?resize=1024%2C322&#038;ssl=1\" alt=\"\" class=\"wp-image-539\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-23.png?resize=1024%2C322&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-23.png?resize=300%2C94&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-23.png?resize=768%2C241&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-23.png?w=1276&amp;ssl=1 1276w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Management de notre SQL pool Serverless<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Nous retrouvons l&rsquo;ensemble des propri\u00e9t\u00e9s du pool Serverless pour trouver nos chaines de connexion.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"509\" height=\"1024\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-25.png?resize=509%2C1024&#038;ssl=1\" alt=\"\" class=\"wp-image-542\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-25.png?resize=509%2C1024&amp;ssl=1 509w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-25.png?resize=149%2C300&amp;ssl=1 149w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-25.png?w=631&amp;ssl=1 631w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><figcaption class=\"wp-element-caption\">Informations sur notre \u00ab\u00a0Serveur\u00a0\u00bb SQL<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Nous pouvons maintenant utiliser notre client SQL favori :<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"484\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-26.png?resize=1024%2C484&#038;ssl=1\" alt=\"\" class=\"wp-image-544\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-26.png?resize=1024%2C484&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-26.png?resize=300%2C142&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-26.png?resize=768%2C363&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-26.png?w=1360&amp;ssl=1 1360w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Requ\u00eatage de notre DWH via Azure Data Studio<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Import_des_donnees_depuis_Power_BI\"><\/span>Import des donn\u00e9es depuis Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">D&rsquo;un point de vue Power BI nous sommes maintenant dans une situation tr\u00e8s classique ou nous pouvons nous connecter \u00e0 nos donn\u00e9es avec une connexion SQL Serveur.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"626\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-28.png?resize=1024%2C626&#038;ssl=1\" alt=\"\" class=\"wp-image-548\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-28.png?resize=1024%2C626&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-28.png?resize=300%2C183&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-28.png?resize=768%2C470&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-28.png?w=1176&amp;ssl=1 1176w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Se connecter \u00e0 un SQL Serveur<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Notre \u00ab\u00a0SQL Pool serverless\u00a0\u00bb doit \u00eatre consid\u00e9r\u00e9 comme un serveur SQL classique. On y renseigne la chaine de connexion trouv\u00e9e dans notre studio synapse. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"333\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-30.png?resize=698%2C333&#038;ssl=1\" alt=\"\" class=\"wp-image-550\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-30.png?w=698&amp;ssl=1 698w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-30.png?resize=300%2C143&amp;ssl=1 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><figcaption class=\"wp-element-caption\">D\u00e9finition de la chaine de connexion du serveur SQL<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"317\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-31.png?resize=700%2C317&#038;ssl=1\" alt=\"\" class=\"wp-image-551\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-31.png?w=700&amp;ssl=1 700w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-31.png?resize=300%2C136&amp;ssl=1 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\">param\u00e8tres d&rsquo;identifications<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Dans Power BI, nous ne voyons pas de diff\u00e9rence pour la s\u00e9lection de nos donn\u00e9es avec un serveur plus \u00ab\u00a0classique\u00a0\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"880\" height=\"700\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-32.png?resize=880%2C700&#038;ssl=1\" alt=\"\" class=\"wp-image-552\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-32.png?w=880&amp;ssl=1 880w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-32.png?resize=300%2C239&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/image-32.png?resize=768%2C611&amp;ssl=1 768w\" sizes=\"auto, (max-width: 880px) 100vw, 880px\" \/><figcaption class=\"wp-element-caption\">S\u00e9lection des donn\u00e9es<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Nous rentrons maintenant dans une configuration classique de travail avec Power BI.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">La brique ServerLess SQL est l&rsquo;atout majeur de notre DataLakehouse dans Synapse pour profiter de la puissance des traitements sur des fichiers cot\u00e9s datalake tout en apportant la m\u00eame souplesse d&rsquo;utilisation qu&rsquo;un datalake avec des technologies plus classiques.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Il reste maintenant de nombreuses optimisations techniques \u00e0 mettre en place avec de la mise \u00e0 jour incr\u00e9mentale, de l&rsquo;optimisation sur la structure de nos fichiers comme le partitionnement de fichier vu dans cet article : <a href=\"https:\/\/www.nicedata.fr\/index.php\/2022\/09\/01\/generer-un-dataset-partitionne-via-un-data-flow-azure-synapse-analytics\/\">G\u00e9n\u00e9rer un dataset partitionn\u00e9 via un data flow Azure Synapse Analytics &#8211; NiceData<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Notre DataLakeHouse contient physiquement des fichiers de donn\u00e9es. Ceux-ci sont organis\u00e9s, nettoy\u00e9s, repr\u00e9sentent un mod\u00e8le de donn\u00e9e d\u00e9fini sur la \u00ab\u00a0derni\u00e8re\u00a0\u00bb couche et \u00e9ventuellement de formats diff\u00e9rents. Nous pouvons donc lire nos donn\u00e9es depuis ces fichiers et travailler dessus pour faire ce que l&rsquo;on en veut. Un des principaux cas d&rsquo;usage est de connecter un [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":558,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[76],"tags":[10,9,32,55],"class_list":["post-510","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-synapsedatalake","tag-azure","tag-azure-synapse-analytics","tag-datalake","tag-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse - NiceData<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse - NiceData\" \/>\n<meta property=\"og:description\" content=\"Notre DataLakeHouse contient physiquement des fichiers de donn\u00e9es. Ceux-ci sont organis\u00e9s, nettoy\u00e9s, repr\u00e9sentent un mod\u00e8le de donn\u00e9e d\u00e9fini sur la \u00ab\u00a0derni\u00e8re\u00a0\u00bb couche et \u00e9ventuellement de formats diff\u00e9rents. Nous pouvons donc lire nos donn\u00e9es depuis ces fichiers et travailler dessus pour faire ce que l&rsquo;on en veut. Un des principaux cas d&rsquo;usage est de connecter un [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"NiceData\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-29T16:18:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-20T12:49:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/From-Baseball-to-Banking-Data1.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Jean-Laurent Ferralis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JLFerralis\" \/>\n<meta name=\"twitter:site\" content=\"@JLFerralis\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jean-Laurent Ferralis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/\"},\"author\":{\"name\":\"Jean-Laurent Ferralis\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#\\\/schema\\\/person\\\/8d1ad38004d3b0cf6bff7c200c795e19\"},\"headline\":\"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse\",\"datePublished\":\"2023-03-29T16:18:33+00:00\",\"dateModified\":\"2024-08-20T12:49:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/\"},\"wordCount\":1225,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.nicedata.fr\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1\",\"keywords\":[\"Azure\",\"Azure Synapse Analytics\",\"datalake\",\"Power BI\"],\"articleSection\":[\"Azure Synapse - Datalake\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/\",\"url\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/\",\"name\":\"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse - NiceData\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.nicedata.fr\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1\",\"datePublished\":\"2023-03-29T16:18:33+00:00\",\"dateModified\":\"2024-08-20T12:49:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.nicedata.fr\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.nicedata.fr\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1\",\"width\":800,\"height\":420},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/2023\\\/03\\\/29\\\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.nicedata.fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#website\",\"url\":\"https:\\\/\\\/www.nicedata.fr\\\/\",\"name\":\"NiceData\",\"description\":\"L&#039;expertise Data du sud\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.nicedata.fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#organization\",\"name\":\"NiceData\",\"url\":\"https:\\\/\\\/www.nicedata.fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.nicedata.fr\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/NICE-DATA_JLFMod.webp?fit=2493%2C1249&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.nicedata.fr\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/NICE-DATA_JLFMod.webp?fit=2493%2C1249&ssl=1\",\"width\":2493,\"height\":1249,\"caption\":\"NiceData\"},\"image\":{\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/JLFerralis\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.nicedata.fr\\\/#\\\/schema\\\/person\\\/8d1ad38004d3b0cf6bff7c200c795e19\",\"name\":\"Jean-Laurent Ferralis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g\",\"caption\":\"Jean-Laurent Ferralis\"},\"description\":\"French Data Professionnal - BI consultant and #sql lover. I also #swimbikerun when possible ! Living in @villedenice\",\"sameAs\":[\"http:\\\/\\\/xp-it.com\"],\"url\":\"https:\\\/\\\/www.nicedata.fr\\\/index.php\\\/author\\\/jlf\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse - NiceData","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:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse - NiceData","og_description":"Notre DataLakeHouse contient physiquement des fichiers de donn\u00e9es. Ceux-ci sont organis\u00e9s, nettoy\u00e9s, repr\u00e9sentent un mod\u00e8le de donn\u00e9e d\u00e9fini sur la \u00ab\u00a0derni\u00e8re\u00a0\u00bb couche et \u00e9ventuellement de formats diff\u00e9rents. Nous pouvons donc lire nos donn\u00e9es depuis ces fichiers et travailler dessus pour faire ce que l&rsquo;on en veut. Un des principaux cas d&rsquo;usage est de connecter un [&hellip;]","og_url":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/","og_site_name":"NiceData","article_published_time":"2023-03-29T16:18:33+00:00","article_modified_time":"2024-08-20T12:49:14+00:00","og_image":[{"width":800,"height":420,"url":"https:\/\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/From-Baseball-to-Banking-Data1.webp","type":"image\/webp"}],"author":"Jean-Laurent Ferralis","twitter_card":"summary_large_image","twitter_creator":"@JLFerralis","twitter_site":"@JLFerralis","twitter_misc":{"\u00c9crit par":"Jean-Laurent Ferralis","Dur\u00e9e de lecture estim\u00e9e":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#article","isPartOf":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/"},"author":{"name":"Jean-Laurent Ferralis","@id":"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19"},"headline":"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse","datePublished":"2023-03-29T16:18:33+00:00","dateModified":"2024-08-20T12:49:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/"},"wordCount":1225,"commentCount":2,"publisher":{"@id":"https:\/\/www.nicedata.fr\/#organization"},"image":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1","keywords":["Azure","Azure Synapse Analytics","datalake","Power BI"],"articleSection":["Azure Synapse - Datalake"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/","url":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/","name":"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse - NiceData","isPartOf":{"@id":"https:\/\/www.nicedata.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#primaryimage"},"image":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1","datePublished":"2023-03-29T16:18:33+00:00","dateModified":"2024-08-20T12:49:14+00:00","breadcrumb":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#primaryimage","url":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1","width":800,"height":420},{"@type":"BreadcrumbList","@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/03\/29\/creer-un-dataset-power-bi-depuis-notre-synapse-datalakehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.nicedata.fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er un dataset Power BI depuis notre Synapse DataLakeHouse"}]},{"@type":"WebSite","@id":"https:\/\/www.nicedata.fr\/#website","url":"https:\/\/www.nicedata.fr\/","name":"NiceData","description":"L&#039;expertise Data du sud","publisher":{"@id":"https:\/\/www.nicedata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.nicedata.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.nicedata.fr\/#organization","name":"NiceData","url":"https:\/\/www.nicedata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.nicedata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/11\/NICE-DATA_JLFMod.webp?fit=2493%2C1249&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/11\/NICE-DATA_JLFMod.webp?fit=2493%2C1249&ssl=1","width":2493,"height":1249,"caption":"NiceData"},"image":{"@id":"https:\/\/www.nicedata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/JLFerralis"]},{"@type":"Person","@id":"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19","name":"Jean-Laurent Ferralis","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g","caption":"Jean-Laurent Ferralis"},"description":"French Data Professionnal - BI consultant and #sql lover. I also #swimbikerun when possible ! Living in @villedenice","sameAs":["http:\/\/xp-it.com"],"url":"https:\/\/www.nicedata.fr\/index.php\/author\/jlf\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/03\/From-Baseball-to-Banking-Data1.webp?fit=800%2C420&ssl=1","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=510"}],"version-history":[{"count":10,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/510\/revisions"}],"predecessor-version":[{"id":557,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/510\/revisions\/557"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/media\/558"}],"wp:attachment":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}