{"id":465,"date":"2023-01-31T14:03:15","date_gmt":"2023-01-31T13:03:15","guid":{"rendered":"https:\/\/www.nicedata.fr\/?p=465"},"modified":"2024-08-20T14:49:15","modified_gmt":"2024-08-20T12:49:15","slug":"rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics","status":"publish","type":"post","link":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/","title":{"rendered":"Rafraichir un dataset Power BI depuis Azure Synapse Analytics"},"content":{"rendered":"\n<p>Une fois de plus, notre DataLakeHouse n&rsquo;a d&rsquo;utilit\u00e9 que si l&rsquo;on exploite les donn\u00e9es qui y sont stock\u00e9es. Un des uses cases le plus classique est de faire du reporting (via Power BI)sur la partie \u00ab\u00a0DataXxxHouse\u00a0\u00bb. <br>Nous allons pr\u00e9senter dans cet article comment mettre \u00e0 jour notre Dataset Power BI directement depuis Azure Synapse Analytics via un pipeline.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 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\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Introduction\" >Introduction<\/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\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Cas_dusage_%E2%80%93_Rafraichir_notre_Dataset_Power_BI_depuis_notre_pipeline_Synapse\" >Cas d\u2019usage \u2013&nbsp;Rafraichir notre Dataset Power BI depuis notre pipeline Synapse<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Solution\" >Solution<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Mise_en_place_des_autorisations\" >Mise en place des autorisations<\/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\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Developpement_du_pipeline\" >D\u00e9veloppement du pipeline<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Mise_en_place_du_Pipeline\" >Mise en place du Pipeline<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Trouver_les_Id_Power_BI\" >Trouver les Id Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Resultat\" >R\u00e9sultat<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span>Introduction<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La derni\u00e8re zone de notre DataLakeHouse correspond \u00e0 notre DataWareHouse et nous avons construit un dataset Power BI \u00e0 partir de celui-ci. Pour des questions de performances cot\u00e9es utilisateur, notre dataset est configur\u00e9 en mode \u00ab\u00a0import\u00a0\u00bb et nous devons donc rafraichir r\u00e9guli\u00e8rement celui-ci afin d&rsquo;avoir les derni\u00e8res donn\u00e9es dans nos rapports Power BI.<\/p>\n\n\n\n<p>Du c\u00f4t\u00e9 de Synapse analytics, nous programmons nos alimentations via des triggers qui sont d\u00e9clench\u00e9s sur certains intervalles de temps. Nous avons exactement le m\u00eame type de configuration cot\u00e9 Power BI.<\/p>\n\n\n\n<p>Le probl\u00e8me de ce fonctionnement est que si nous savons approximativement \u00e0 quel moment d\u00e9marre l&rsquo;alimentation de notre DataLakeHouse, nous ne savons pas quand il est fini et donc \u00e0 quel moment il nous faut lancer le rafraichissement c\u00f4t\u00e9 Power BI.  Il est certes envisageable de faire des estimations en prenant la moyenne des temps de traitements, de rajouter une petite marge et de programmer les diff\u00e9rents triggers en cons\u00e9quence.<\/p>\n\n\n\n<p>Cependant, il y a une fa\u00e7on de voir la chose de mani\u00e8re bien plus \u00e9vidente !<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cas_dusage_%E2%80%93_Rafraichir_notre_Dataset_Power_BI_depuis_notre_pipeline_Synapse\"><\/span>Cas d\u2019usage \u2013&nbsp;Rafraichir notre Dataset Power BI depuis notre pipeline Synapse<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Imaginons que nous avons des pipelines Synapses qui sont d\u00e9clench\u00e9es via des triggers depuis Synapse qui extraient les donn\u00e9es de nos bases de donn\u00e9es op\u00e9rationnelles, les traitent pour alimenter la couche DataWareHouse de notre DataLakeHouse. Nous souhaitons que les diff\u00e9rents Datasets Power BI bas\u00e9 sur ce DWH soit rafraichi d\u00e8s que les donn\u00e9es soient mises \u00e0 jour et uniquement si tous les traitements ce bon bien pass\u00e9.<\/p>\n\n\n\n<p>Nous voulons (et allons) donc lancer le rafraichissement de nos Dataset directement depuis Synapse \u00e0 la fin de nos pipelines de traitement.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Solution\"><\/span>Solution<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La solution consiste en un pipeline qui sera ex\u00e9cut\u00e9 \u00e0 la suite de nos pipelines de traitement qui fera un appel \u00e0 l&rsquo;API Power BI directement apr\u00e8s le succ\u00e8s de pipeline de traitement.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1005\" height=\"495\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-29.png?resize=1005%2C495&#038;ssl=1\" alt=\"\" class=\"wp-image-503\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-29.png?w=1005&amp;ssl=1 1005w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-29.png?resize=300%2C148&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-29.png?resize=768%2C378&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Sch\u00e9ma global de la solution<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Mise_en_place_des_autorisations\"><\/span>Mise en place des autorisations<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La premi\u00e8re partie de notre solution consiste \u00e0 autoriser le user qui ex\u00e9cute le pipeline synapse \u00e0 utiliser l&rsquo;api Power BI. Pour ce faire, nous allons d&rsquo;abord cr\u00e9er un groupe de s\u00e9curit\u00e9 ou nous allons ajouter nos utilisateurs synapses.<\/p>\n\n\n\n<p>Ce qu&rsquo;il se passe dans la majorit\u00e9 des cas, c&rsquo;est que nous allons demander \u00e0 nos administrateurs AD \/ s\u00e9curit\u00e9 de cr\u00e9er le groupe pour nous, car g\u00e9n\u00e9ralement nous n&rsquo;avons pas tous les droits. Cependant, voici la d\u00e9marche \u00e0 effectuer.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Cr\u00e9ation du groupe dans l&rsquo;AAD<\/h4>\n\n\n\n<p>Rendez-vous dans le centre d&rsquo;administration AAD.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-5.png?resize=464%2C238&#038;ssl=1\" alt=\"\" class=\"wp-image-472\" width=\"464\" height=\"238\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-5.png?w=594&amp;ssl=1 594w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-5.png?resize=300%2C154&amp;ssl=1 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><figcaption class=\"wp-element-caption\">Cr\u00e9ation d&rsquo;un groupe<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-11.png?resize=579%2C363&#038;ssl=1\" alt=\"\" class=\"wp-image-478\" width=\"579\" height=\"363\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-11.png?w=750&amp;ssl=1 750w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-11.png?resize=300%2C188&amp;ssl=1 300w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><figcaption class=\"wp-element-caption\">Choisir le type de groupe \u00ab\u00a0S\u00e9curit\u00e9\u00a0\u00bb<\/figcaption><\/figure>\n\n\n\n<p>Pour faciliter son identification, il faut choisir un nom \u00ab\u00a0parlant\u00a0\u00bb, Pour ma part, il s&rsquo;appellera \u00ab\u00a0PowerBI_Integration\u00a0\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-12.png?resize=659%2C294&#038;ssl=1\" alt=\"\" class=\"wp-image-479\" width=\"659\" height=\"294\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-12.png?w=997&amp;ssl=1 997w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-12.png?resize=300%2C134&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-12.png?resize=768%2C343&amp;ssl=1 768w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><figcaption class=\"wp-element-caption\">Notre groupe cr\u00e9e avec le bon type<\/figcaption><\/figure>\n\n\n\n<p>Il nous faut maintenant ajouter les utilisateurs \u00e0 ce groupe. Mais quelles users ? Lorsque l&rsquo;on ex\u00e9cute un pipeline via un trigger, c&rsquo;est l&rsquo;identit\u00e9 manag\u00e9e de Synapse qui ex\u00e9cute un pipeline et c&rsquo;est donc elle qui doit \u00eatre autoris\u00e9e. Vous pouvez aussi ajouter les d\u00e9veloppeurs synapses dans ce groupe car lorsque l&rsquo;on ex\u00e9cute un pipeline en mode debug, c&rsquo;est l&rsquo;utilisateur authentifi\u00e9 sur le workspace qui ex\u00e9cute l&rsquo;action. Dans un environnement de d\u00e9veloppement, il peut \u00eatre int\u00e9ressant d&rsquo;ajouter les d\u00e9veloppeurs dans ce groupe pour leur donner les m\u00eames droits. (ou cr\u00e9er un autre groupe et lui donner les m\u00eames droits dans le reste de la proc\u00e9dure)<\/p>\n\n\n\n<p>L&rsquo;identit\u00e9 manag\u00e9e en question porte le m\u00eame nom que le workspace. Au besoin, l&rsquo;ensemble des informations se trouve dans les propri\u00e9t\u00e9s du workspace dans le portail azure.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-15.png?resize=642%2C284&#038;ssl=1\" alt=\"\" class=\"wp-image-482\" width=\"642\" height=\"284\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-15.png?w=779&amp;ssl=1 779w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-15.png?resize=300%2C133&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-15.png?resize=768%2C340&amp;ssl=1 768w\" sizes=\"auto, (max-width: 642px) 100vw, 642px\" \/><figcaption class=\"wp-element-caption\">Informations de notre workspace<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"274\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-14.png?resize=1024%2C274&#038;ssl=1\" alt=\"\" class=\"wp-image-481\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-14.png?resize=1024%2C274&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-14.png?resize=300%2C80&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-14.png?resize=768%2C205&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-14.png?resize=1536%2C410&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-14.png?w=1681&amp;ssl=1 1681w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Ajout de l&rsquo;identit\u00e9 manag\u00e9 de notre workspace synapse<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Autorisation du groupe dans Power BI<\/h4>\n\n\n\n<p>Une fois notre groupe cr\u00e9e, il va nous falloir aller dans le portail d&rsquo;administration de notre Tenant Power BI pour autoriser les utilisateurs de ce groupe \u00e0 utiliser les APIs Power BI.<br><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"542\" height=\"294\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-1.png?resize=542%2C294&#038;ssl=1\" alt=\"\" class=\"wp-image-468\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-1.png?w=542&amp;ssl=1 542w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-1.png?resize=300%2C163&amp;ssl=1 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><figcaption class=\"wp-element-caption\">Aller dans le portail d&rsquo;administration de Power BI<\/figcaption><\/figure>\n\n\n\n<p>Une fois dans le portail d&rsquo;administration, nous devons aller autoriser notre groupe \u00e0 utiliser les API Power BI dans les param\u00e8tres de d\u00e9veloppeur.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-4.png?resize=1024%2C468&#038;ssl=1\" alt=\"\" class=\"wp-image-471\" width=\"1024\" height=\"468\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-4.png?resize=1024%2C468&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-4.png?resize=300%2C137&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-4.png?resize=768%2C351&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-4.png?resize=1536%2C701&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-4.png?w=1695&amp;ssl=1 1695w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Autorisation de notre groupe de user \u00e0 utiliser les API Power BI<\/figcaption><\/figure>\n\n\n\n<p>Nous avons maintenant l&rsquo;ensemble des autorisations n\u00e9cessaires pour demander le rafraichissement d&rsquo;un dataset Power BI depuis un pipeline Synapse qu&rsquo;il nous reste \u00e0 d\u00e9velopper.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Developpement_du_pipeline\"><\/span>D\u00e9veloppement du pipeline<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pour \u00eatre plus pr\u00e9cis, ce que nous devons d\u00e9velopper est \u00ab\u00a0juste une activit\u00e9\u00a0\u00bb qui va faire un appel \u00e0 l&rsquo;API Power BI. Il nous faut cependant quelques param\u00e8tres que nous allons inclure dans le pipeline histoire de rendre le tout un peu param\u00e9trable.<\/p>\n\n\n\n<p>La documentation de l&rsquo;API est disponible ici : <a href=\"https:\/\/learn.microsoft.com\/en-us\/rest\/api\/power-bi\/datasets\/refresh-dataset\">Datasets &#8211; Refresh Dataset &#8211; REST API (Power BI Power BI REST APIs) | Microsoft Learn<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Mise_en_place_du_Pipeline\"><\/span>Mise en place du Pipeline<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La premi\u00e8re chose \u00e0 effectuer est de cr\u00e9er notre pipeline d\u00e9di\u00e9 qui h\u00e9bergera notre solution.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"255\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-16.png?resize=491%2C255&#038;ssl=1\" alt=\"\" class=\"wp-image-485\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-16.png?w=491&amp;ssl=1 491w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-16.png?resize=300%2C156&amp;ssl=1 300w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><figcaption class=\"wp-element-caption\">Cr\u00e9ation d&rsquo;un nouveau Pipeline<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"584\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-17.png?resize=1024%2C584&#038;ssl=1\" alt=\"\" class=\"wp-image-486\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-17.png?resize=1024%2C584&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-17.png?resize=300%2C171&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-17.png?resize=768%2C438&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-17.png?w=1136&amp;ssl=1 1136w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Notre nouveau Pipeline<\/figcaption><\/figure>\n\n\n\n<p>Une fois le pipeline cr\u00e9er, nous allons avoir besoin de cr\u00e9er les param\u00e8tres n\u00e9cessaires \u00e0 l&rsquo;appel API. Nous avons besoin de l&rsquo;ID du dataset ainsi que de l&rsquo;ID du workspace.<\/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=\"500\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-25.png?resize=1024%2C500&#038;ssl=1\" alt=\"\" class=\"wp-image-495\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-25.png?resize=1024%2C500&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-25.png?resize=300%2C146&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-25.png?resize=768%2C375&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-25.png?w=1262&amp;ssl=1 1262w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">Cr\u00e9ation des param\u00e8tres<\/figcaption><\/figure>\n\n\n\n<p>Nous pouvons maintenant ajouter notre activit\u00e9 de type web.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"431\" height=\"239\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-19.png?resize=431%2C239&#038;ssl=1\" alt=\"\" class=\"wp-image-488\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-19.png?w=431&amp;ssl=1 431w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-19.png?resize=300%2C166&amp;ssl=1 300w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><figcaption class=\"wp-element-caption\">Utilisation d&rsquo;une activit\u00e9 \u00ab\u00a0Web\u00a0\u00bb<\/figcaption><\/figure>\n\n\n\n<p>La configuration g\u00e9n\u00e9rale est plut\u00f4t rapide. Un nom pour faire les choses proprement et une valeur de Timeout relativement faible sont suffisants.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"673\" height=\"596\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-20.png?resize=673%2C596&#038;ssl=1\" alt=\"\" class=\"wp-image-489\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-20.png?w=673&amp;ssl=1 673w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-20.png?resize=300%2C266&amp;ssl=1 300w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><figcaption class=\"wp-element-caption\">Configuration g\u00e9n\u00e9rale<\/figcaption><\/figure>\n\n\n\n<p>C&rsquo;est dans la partie \u00ab\u00a0Settings\u00a0\u00bb que nous allons vraiment faire la configuration de notre appel API. Dans un premier temps, nous devons configurer l&rsquo;URL de l&rsquo;appel. \u00c9tant donn\u00e9 que nous devons passer les param\u00e8tres d&rsquo;ID de notre Dataset et de notre Workspace Power BI, nous devons ajouter du contenu dynamique.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"549\" height=\"284\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-21.png?resize=549%2C284&#038;ssl=1\" alt=\"\" class=\"wp-image-490\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-21.png?w=549&amp;ssl=1 549w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-21.png?resize=300%2C155&amp;ssl=1 300w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><figcaption class=\"wp-element-caption\">Configuration de l&rsquo;URL de l&rsquo;appel API<\/figcaption><\/figure>\n\n\n\n<p>C&rsquo;est dans l&rsquo;\u00e9diteur d&rsquo;expression que nous allons cr\u00e9er la chaine de caract\u00e8re correspondant \u00e0 l&rsquo;URL de notre appel.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"451\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-22.png?resize=614%2C451&#038;ssl=1\" alt=\"\" class=\"wp-image-491\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-22.png?w=614&amp;ssl=1 614w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-22.png?resize=300%2C220&amp;ssl=1 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><figcaption class=\"wp-element-caption\">Construction de l&rsquo;appel<\/figcaption><\/figure>\n\n\n\n<p>Pour des raisons que je n&rsquo;ai pas encore \u00e9lucid\u00e9, je n&rsquo;arrive pas \u00e0 utiliser l&rsquo;URL fournie dans la documentation (sans faire appel au Workspace Id) mais la suivante fonctionne correctement. Si vous trouvez l&rsquo;erreur, je vous serai reconnaissant de m&rsquo;en informer en commentaire, mais en attendant cela marche correctement, et c&rsquo;est bien l&rsquo;essentiel !<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@concat('https:\/\/api.powerbi.com\/v1.0\/myorg\/groups\/',pipeline().parameters.WorkspaceGuid,'\/datasets\/',pipeline().parameters.DatasetGuid,'\/refreshes')<\/code><\/pre>\n\n\n\n<p>Ensuite, nous devons pr\u00e9ciser que notre appel API se fait avec une m\u00e9thode \u00ab\u00a0POST\u00a0\u00bb, car nous envoyons une information \u00e0 notre API et nous n&rsquo;attendons rien en retour (appart un code retour).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"461\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-23.png?resize=640%2C461&#038;ssl=1\" alt=\"\" class=\"wp-image-492\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-23.png?w=640&amp;ssl=1 640w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-23.png?resize=300%2C216&amp;ssl=1 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\">Configuration de la m\u00e9thode d&rsquo;appel API &#8211;&gt; POST<\/figcaption><\/figure>\n\n\n\n<p>La derni\u00e8re \u00e9tape consiste \u00e0 configurer la m\u00e9thode d&rsquo;authentification qui doit \u00eatre utilis\u00e9e. Nous avons autoris\u00e9 au d\u00e9but de notre article l&rsquo;identit\u00e9 manag\u00e9e de notre Workspace Synapse et nous allons donc l&rsquo;utiliser pour l&rsquo;authentification.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"556\" height=\"448\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-24.png?resize=556%2C448&#038;ssl=1\" alt=\"\" class=\"wp-image-493\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-24.png?w=556&amp;ssl=1 556w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-24.png?resize=300%2C242&amp;ssl=1 300w\" sizes=\"auto, (max-width: 556px) 100vw, 556px\" \/><figcaption class=\"wp-element-caption\">Configuration de l&rsquo;authentification<\/figcaption><\/figure>\n\n\n\n<p>Le deuxi\u00e8me param\u00e8tre correspond \u00e0 l&rsquo;adresse qui va nous servir \u00e0 nous authentifier. L&rsquo;adresse \u00e0 utiliser est la suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>https:&#47;&#47;analysis.windows.net\/powerbi\/api<\/code><\/pre>\n\n\n\n<p>La configuration est finie, il nous reste maintenant \u00e0 tester notre pipeline. Attention, en debug ou via un trigger le user qui fera l&rsquo;appel n&rsquo;est pas le m\u00eame donc si vous n&rsquo;avez pas autoris\u00e9 votre compte AAD mais uniquement l&rsquo;identit\u00e9 manag\u00e9e il faudra imp\u00e9rativement publi\u00e9 et ex\u00e9cuter via un trigger.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"556\" height=\"197\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-26.png?resize=556%2C197&#038;ssl=1\" alt=\"\" class=\"wp-image-497\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-26.png?w=556&amp;ssl=1 556w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-26.png?resize=300%2C106&amp;ssl=1 300w\" sizes=\"auto, (max-width: 556px) 100vw, 556px\" \/><figcaption class=\"wp-element-caption\">Configuration des id n\u00e9cessaires de notre Power BI<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Trouver_les_Id_Power_BI\"><\/span>Trouver les Id Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pour trouver les Id du Workspace et du Dataset, il suffit de se rendre sur la page du Dataset en question dans Power BI et tout est \u00e9crit dans l&rsquo;URL.<\/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=\"397\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-30.png?resize=1024%2C397&#038;ssl=1\" alt=\"\" class=\"wp-image-507\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-30.png?resize=1024%2C397&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-30.png?resize=300%2C116&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-30.png?resize=768%2C298&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-30.png?resize=1536%2C596&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-30.png?w=1917&amp;ssl=1 1917w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">R\u00e9cup\u00e9ration des Id Power BI<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Resultat\"><\/span>R\u00e9sultat<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Le pipeline est bien ex\u00e9cut\u00e9 :<\/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=\"456\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-27.png?resize=1024%2C456&#038;ssl=1\" alt=\"\" class=\"wp-image-498\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-27.png?resize=1024%2C456&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-27.png?resize=300%2C134&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-27.png?resize=768%2C342&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-27.png?w=1051&amp;ssl=1 1051w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p>ATTENTION ! Ce qui \u00e0 r\u00e9ussi est uniquement l&rsquo;appel \u00e0 l&rsquo;API et non pas le refresh Power BI en lui-m\u00eame. Globalement l&rsquo;API nous r\u00e9pond qu&rsquo;elle a r\u00e9ussi \u00e0 lancer le refresh de notre dataset. Ce qu&rsquo;il se passe apr\u00e8s reste dans Power BI. <\/p>\n\n\n\n<p>Pour v\u00e9rifier que tout se passe bien, nous pouvons aller dans Power BI et regarder l&rsquo;historique de refresh de notre Datastet. Si tout c&rsquo;est bien pass\u00e9, notre Dataset devrait \u00eatre en cours, mais le plus important est de regarder le type de refresh qui fait apparaitre qu&rsquo;il a \u00e9t\u00e9 lanc\u00e9 via API.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"852\" height=\"446\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-28.png?resize=852%2C446&#038;ssl=1\" alt=\"\" class=\"wp-image-499\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-28.png?w=852&amp;ssl=1 852w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-28.png?resize=300%2C157&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2023\/01\/image-28.png?resize=768%2C402&amp;ssl=1 768w\" sizes=\"auto, (max-width: 852px) 100vw, 852px\" \/><figcaption class=\"wp-element-caption\">D\u00e9clenchement d&rsquo;un refresh Power BI via API<\/figcaption><\/figure>\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>A ce stade, nous avons r\u00e9ussi \u00e0 lancer le refresh d&rsquo;un dataset Power BI directement depuis un pipeline Synapse. Cependant, pour l&rsquo;instant, nous rafraichissons qu&rsquo;un seul dataset, nous ne v\u00e9rifions pas s&rsquo;il y a une erreur dans l&rsquo;appel.<\/p>\n\n\n\n<p>Certaines am\u00e9liorations \u00e0 ce pipeline qui feront probablement l&rsquo;objet d&rsquo;articles futurs seraient :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Rafraichir uniquement une table ou une partition du dataset<\/li>\n\n\n\n<li>Rafraichir plusieurs Dataset<\/li>\n\n\n\n<li>Faire une v\u00e9rification d&rsquo;erreur<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Nous allons pr\u00e9senter dans cet article comment mettre \u00e0 jour notre Dataset Power BI directement depuis Azure Synapse Analytics via un pipeline.<\/p>\n","protected":false},"author":2,"featured_media":506,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[76],"tags":[9,8,55],"class_list":["post-465","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-synapsedatalake","tag-azure-synapse-analytics","tag-microsoft","tag-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Rafraichir un dataset Power BI depuis Azure Synapse Analytics - NiceData<\/title>\n<meta name=\"description\" content=\"Nous allons pr\u00e9senter dans cet article comment mettre \u00e0 jour notre Dataset Power BI directement depuis Azure Synapse Analytics via un pipeline.\" \/>\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\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rafraichir un dataset Power BI depuis Azure Synapse Analytics - NiceData\" \/>\n<meta property=\"og:description\" content=\"Nous allons pr\u00e9senter dans cet article comment mettre \u00e0 jour notre Dataset Power BI directement depuis Azure Synapse Analytics via un pipeline.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"NiceData\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-31T13:03:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-20T12:49:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"12 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\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/\"},\"author\":{\"name\":\"Jean-Laurent Ferralis\",\"@id\":\"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19\"},\"headline\":\"Rafraichir un dataset Power BI depuis Azure Synapse Analytics\",\"datePublished\":\"2023-01-31T13:03:15+00:00\",\"dateModified\":\"2024-08-20T12:49:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/\"},\"wordCount\":1595,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.nicedata.fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707\",\"keywords\":[\"Azure Synapse Analytics\",\"Microsoft\",\"Power BI\"],\"articleSection\":[\"Azure Synapse - Datalake\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/\",\"url\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/\",\"name\":\"Rafraichir un dataset Power BI depuis Azure Synapse Analytics - NiceData\",\"isPartOf\":{\"@id\":\"https:\/\/www.nicedata.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707\",\"datePublished\":\"2023-01-31T13:03:15+00:00\",\"dateModified\":\"2024-08-20T12:49:15+00:00\",\"description\":\"Nous allons pr\u00e9senter dans cet article comment mettre \u00e0 jour notre Dataset Power BI directement depuis Azure Synapse Analytics via un pipeline.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#primaryimage\",\"url\":\"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707\",\"contentUrl\":\"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707\",\"width\":2560,\"height\":1707,\"caption\":\"Photo par Luke Chesser sur Unsplash\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.nicedata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rafraichir un dataset Power BI depuis Azure Synapse Analytics\"}]},{\"@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":"Rafraichir un dataset Power BI depuis Azure Synapse Analytics - NiceData","description":"Nous allons pr\u00e9senter dans cet article comment mettre \u00e0 jour notre Dataset Power BI directement depuis Azure Synapse Analytics via un pipeline.","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\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/","og_locale":"fr_FR","og_type":"article","og_title":"Rafraichir un dataset Power BI depuis Azure Synapse Analytics - NiceData","og_description":"Nous allons pr\u00e9senter dans cet article comment mettre \u00e0 jour notre Dataset Power BI directement depuis Azure Synapse Analytics via un pipeline.","og_url":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/","og_site_name":"NiceData","article_published_time":"2023-01-31T13:03:15+00:00","article_modified_time":"2024-08-20T12:49:15+00:00","og_image":[{"height":1707,"width":2560,"url":"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707","type":"image\/jpeg"}],"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":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#article","isPartOf":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/"},"author":{"name":"Jean-Laurent Ferralis","@id":"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19"},"headline":"Rafraichir un dataset Power BI depuis Azure Synapse Analytics","datePublished":"2023-01-31T13:03:15+00:00","dateModified":"2024-08-20T12:49:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/"},"wordCount":1595,"commentCount":0,"publisher":{"@id":"https:\/\/www.nicedata.fr\/#organization"},"image":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707","keywords":["Azure Synapse Analytics","Microsoft","Power BI"],"articleSection":["Azure Synapse - Datalake"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/","url":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/","name":"Rafraichir un dataset Power BI depuis Azure Synapse Analytics - NiceData","isPartOf":{"@id":"https:\/\/www.nicedata.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#primaryimage"},"image":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707","datePublished":"2023-01-31T13:03:15+00:00","dateModified":"2024-08-20T12:49:15+00:00","description":"Nous allons pr\u00e9senter dans cet article comment mettre \u00e0 jour notre Dataset Power BI directement depuis Azure Synapse Analytics via un pipeline.","breadcrumb":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#primaryimage","url":"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707","contentUrl":"https:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707","width":2560,"height":1707,"caption":"Photo par Luke Chesser sur Unsplash"},{"@type":"BreadcrumbList","@id":"https:\/\/www.nicedata.fr\/index.php\/2023\/01\/31\/rafraichir-un-dataset-power-bi-depuis-azure-synapse-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.nicedata.fr\/"},{"@type":"ListItem","position":2,"name":"Rafraichir un dataset Power BI depuis Azure Synapse Analytics"}]},{"@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:\/\/images.unsplash.com\/photo-1551288049-bebda4e38f71?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzUxNjk0MDc&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2560&h=1707","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/465","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=465"}],"version-history":[{"count":11,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/465\/revisions"}],"predecessor-version":[{"id":508,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/465\/revisions\/508"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/media\/506"}],"wp:attachment":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}