{"id":85372,"date":"2022-06-09T21:21:31","date_gmt":"2022-06-09T19:21:31","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/obtener-datos-de-excel-a-power-bi\/"},"modified":"2020-09-18T00:47:39","modified_gmt":"2020-09-18T03:47:39","slug":"obtener-datos-de-excel-a-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/fr\/puissancebi\/obtener-datos-de-excel-a-power-bi\/","title":{"rendered":"Obtenir des donn\u00e9es d&#039;Excel vers Power BI"},"content":{"rendered":"<div>\n<p>Dans cette section, nous vous montrons comment connecter Power BI \u00e0 des fichiers Excel et comment obtenir des donn\u00e9es d&#039;Excel vers Power BI. Pour montrer comment obtenir des donn\u00e9es d&#039;Excel vers Power BI, nous allons t\u00e9l\u00e9charger les donn\u00e9es du fichier Excel vers Power BI et g\u00e9n\u00e9rer un graphique en anneau.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-104\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:90px;min-width:728px;text-align:center !important;\" class=\"ezoic-ad medrectangle-3 adtester-container adtester-container-104\" data-ez-name=\"tutorialgateway_org-medrectangle-3\"><span id=\"div-gpt-ad-tutorialgateway_org-medrectangle-3-0\" ezaw=\"728\" ezah=\"90\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:90px;min-width:728px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<h2>Comment obtenir des donn\u00e9es d&#039;Excel vers Power BI<\/h2>\n<p>Avant de commencer, regardons les donn\u00e9es pr\u00e9sentes dans le fichier Excel des ventes par pays. Dans la capture d&#039;\u00e9cran ci-dessous, vous pouvez voir que la premi\u00e8re ligne a les noms de colonne.<\/p>\n<figure class=\"wp-block-image\"><img alt='get-data-from-excel-to-power-bi-1-1731993' width='905' height='627' class=\"wp-image-30208\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-1-1731993.png 905w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-1-1731993-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-1-1731993-768x532.png 768w' data-lazy-sizes='(max-width: 905px) 100vw, 905px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-1-1731993.png'\/><noscript><img alt='get-data-from-excel-to-power-bi-1-1731993' width='905' height='627' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-1-1731993.png' class=\"wp-image-30208\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-1-1731993.png 905w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-1-1731993-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-1-1731993-768x532.png 768w' sizes='(max-width: 905px) 100vw, 905px'\/><\/noscript><\/figure>\n<p>Si vous n&#039;avez pas encore d\u00e9marr\u00e9 Power BI Desktop, double-cliquez sur Power BI Desktop pour l&#039;ouvrir. Une fois ouvert, il ressemble \u00e0 la capture d&#039;\u00e9cran ci-dessous. Clique sur le <b>Obtenir des informations<\/b> Hyperlien.<span id=\"ezoic-pub-ad-placeholder-132\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad box-3 adtester-container adtester-container-132\" data-ez-name=\"tutorialgateway_org-box-3\"><span id=\"div-gpt-ad-tutorialgateway_org-box-3-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='connect-power-bi-au-serveur-sql-1-1617761' width='1160' height='743' class=\"wp-image-29650\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761.png 1160w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-1024x656.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-768x492.png 768w' data-lazy-sizes='(max-width: 1160px) 100vw, 1160px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761.png'\/><noscript><img alt='connect-power-bi-au-serveur-sql-1-1617761' width='1160' height='743' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761.png' class=\"wp-image-29650\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761.png 1160w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-1024x656.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-SQL-Server-1-1617761-768x492.png 768w' sizes='(max-width: 1160px) 100vw, 1160px'\/><\/noscript><\/figure>\n<p>Si vous \u00eates sur la page de visualisation Power BI, sous l&#039;onglet Accueil, cliquez sur l&#039;ic\u00f4ne <b>Obtenir des informations<\/b> et s\u00e9lectionnez l&#039;option <b>Se d\u00e9marquer<\/b> comme nous le montrons ci-dessous. Ou s\u00e9lectionnez <b>Voir plus<\/b> options.<\/p>\n<figure class=\"wp-block-image\"><img alt='get-data-from-excel-to-power-bi-2-8004552' width='1052' height='586' class=\"wp-image-30209\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552.png 1052w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552-768x428.png 768w' data-lazy-sizes='(max-width: 1052px) 100vw, 1052px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552.png'\/><noscript><img alt='get-data-from-excel-to-power-bi-2-8004552' width='1052' height='586' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552.png' class=\"wp-image-30209\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552.png 1052w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-2-8004552-768x428.png 768w' sizes='(max-width: 1052px) 100vw, 1052px'\/><\/noscript><\/figure>\n<h3>Obtenir des donn\u00e9es d&#039;Excel vers Power BI<\/h3>\n<p>Lorsque vous s\u00e9lectionnez le <strong>Voir plus<\/strong> option, la fen\u00eatre suivante sera affich\u00e9e. Vous pouvez utiliser cette fen\u00eatre pour s\u00e9lectionner la source de donn\u00e9es souhait\u00e9e. Pour l&#039;instant, laissez-moi s\u00e9lectionner le <strong>Fichier -&gt; <\/strong><strong>Se d\u00e9marquer<\/strong> Option et cliquez <strong>Relier<\/strong> bouton<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:400px;min-width:580px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"580\" ezah=\"400\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:400px;min-width:580px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='get-data-from-excel-to-power-bi-3-4965436' width='610' height='663' class=\"wp-image-30210\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-4965436.png 610w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-4965436-276x300.png 276w' data-lazy-sizes='(max-width: 610px) 100vw, 610px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-4965436.png'\/><noscript><img alt='get-data-from-excel-to-power-bi-3-4965436' width='610' height='663' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-4965436.png' class=\"wp-image-30210\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-4965436.png 610w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-4965436-276x300.png 276w' sizes='(max-width: 610px) 100vw, 610px'\/><\/noscript><\/figure>\n<p>Une fois que vous cliquez sur le <b>Relier<\/b> , une nouvelle fen\u00eatre s&#039;ouvre pour s\u00e9lectionner le fichier Excel dans notre syst\u00e8me de fichiers. Pour l&#039;instant, nous s\u00e9lectionnons le fichier SalesByCountry.xls, comme indiqu\u00e9 ci-dessous.<\/p>\n<figure class=\"wp-block-image\"><img alt='obtenir-des-donn\u00e9es-d&#039;excel-\u00e0-power-bi-4-5933933' width='704' height='439' class=\"wp-image-30211\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-4-5933933.png 704w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-4-5933933-300x187.png 300w' data-lazy-sizes='(max-width: 704px) 100vw, 704px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-4-5933933.png'\/><noscript><img alt='obtenir-des-donn\u00e9es-d&#039;excel-\u00e0-power-bi-4-5933933' width='704' height='439' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-4-5933933.png' class=\"wp-image-30211\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-4-5933933.png 704w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-4-5933933-300x187.png 300w' sizes='(max-width: 704px) 100vw, 704px'\/><\/noscript><\/figure>\n<p>Le d\u00e9veloppement du dossier Excel affiche la liste des feuilles disponibles. Si vous s\u00e9lectionnez la feuille ou le tableau, il affiche l&#039;aper\u00e7u des donn\u00e9es. Dans la capture d&#039;\u00e9cran ci-dessous, vous pouvez voir l&#039;aper\u00e7u de la feuille.<\/p>\n<p>Si vous \u00eates satisfait des donn\u00e9es et des types de donn\u00e9es, cliquez sur le bouton T\u00e9l\u00e9charger. Sinon, cliquez sur le bouton Modifier pour apporter des modifications.<\/p>\n<figure class=\"wp-block-image\"><img alt='get-data-from-excel-to-power-bi-5-8294724' width='1172' height='585' class=\"wp-image-30212\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724.png 1172w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-300x150.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-1024x511.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-768x383.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-1000x500.png 1000w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-670x335.png 670w' data-lazy-sizes='(max-width: 1172px) 100vw, 1172px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724.png'\/><noscript><img alt='get-data-from-excel-to-power-bi-5-8294724' width='1172' height='585' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724.png' class=\"wp-image-30212\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724.png 1172w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-300x150.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-1024x511.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-768x383.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-1000x500.png 1000w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-5-8294724-670x335.png 670w' sizes='(max-width: 1172px) 100vw, 1172px'\/><\/noscript><\/figure>\n<p>Actuellement, nous ne souhaitons apporter aucune modification aux donn\u00e9es. Alors laissez-moi cliquer sur le <strong>Charge<\/strong> bouton<\/p>\n<figure class=\"wp-block-image\"><img alt='obtenir-des-donn\u00e9es-de-excel-\u00e0-power-bi-6-3505273' width='1163' height='569' class=\"wp-image-30213\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273.png 1163w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273-1024x501.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273-768x376.png 768w' data-lazy-sizes='(max-width: 1163px) 100vw, 1163px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273.png'\/><noscript><img alt='obtenir-des-donn\u00e9es-de-excel-\u00e0-power-bi-6-3505273' width='1163' height='569' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273.png' class=\"wp-image-30213\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273.png 1163w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273-1024x501.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-6-3505273-768x376.png 768w' sizes='(max-width: 1163px) 100vw, 1163px'\/><\/noscript><\/figure>\n<p>Veuillez patienter jusqu&#039;\u00e0 ce que le t\u00e9l\u00e9chargement soit termin\u00e9<\/p>\n<figure class=\"wp-block-image\"><img alt='obtenir-des-donn\u00e9es-de-excel-\u00e0-power-bi-7-5466685' width='500' height='192' class=\"wp-image-30214\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-7-5466685.png 500w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-7-5466685-300x115.png 300w' data-lazy-sizes='(max-width: 500px) 100vw, 500px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-7-5466685.png'\/><noscript><img alt='obtenir-des-donn\u00e9es-de-excel-\u00e0-power-bi-7-5466685' width='500' height='192' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-7-5466685.png' class=\"wp-image-30214\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-7-5466685.png 500w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-7-5466685-300x115.png 300w' sizes='(max-width: 500px) 100vw, 500px'\/><\/noscript><\/figure>\n<p>Vous pouvez maintenant voir toutes les colonnes qui ont \u00e9t\u00e9 import\u00e9es \u00e0 partir du fichier Excel dans le <strong>Des champs<\/strong> section.<\/p>\n<figure class=\"wp-block-image\"><img alt='obtenir-des-donn\u00e9es-de-excel-\u00e0-power-bi-8-5070321' width='1052' height='589' class=\"wp-image-30215\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321.png 1052w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321-1024x573.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321-768x430.png 768w' data-lazy-sizes='(max-width: 1052px) 100vw, 1052px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321.png'\/><noscript><img alt='obtenir-des-donn\u00e9es-de-excel-\u00e0-power-bi-8-5070321' width='1052' height='589' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321.png' class=\"wp-image-30215\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321.png 1052w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321-1024x573.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-8-5070321-768x430.png 768w' sizes='(max-width: 1052px) 100vw, 1052px'\/><\/noscript><\/figure>\n<p>Permettez-moi de cr\u00e9er un graphique en anneau avec ces donn\u00e9es. Je vous sugg\u00e8re de consulter l&#039;article Power BI Donut Chart pour comprendre les \u00e9tapes requises pour le cr\u00e9er.<\/p>\n<figure class=\"wp-block-image\"><img alt='get-data-from-excel-to-power-bi-9-1855238' width='1376' height='740' class=\"wp-image-30216\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238.png 1376w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238-300x161.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238-1024x551.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238-768x413.png 768w' data-lazy-sizes='(max-width: 1376px) 100vw, 1376px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238.png'\/><noscript><img alt='get-data-from-excel-to-power-bi-9-1855238' width='1376' height='740' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238.png' class=\"wp-image-30216\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238.png 1376w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238-300x161.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238-1024x551.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-9-1855238-768x413.png 768w' sizes='(max-width: 1376px) 100vw, 1376px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Dans cette section, nous vous montrons comment connecter Power BI \u00e0 des fichiers Excel et comment obtenir des donn\u00e9es d&#039;Excel vers Power BI. Pour montrer comment obtenir des donn\u00e9es d&#039;Excel vers\u2026<\/p>","protected":false},"author":1,"featured_media":85373,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-85372","post","type-post","status-publish","format-standard","has-post-thumbnail","category-powerbi","category-tutoriales-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Obtener datos de Excel a Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"En esta secci\u00f3n, le mostramos c\u00f3mo conectar Power BI a archivos de Excel y c\u00f3mo obtener datos de Excel a Power BI. Para demostrar c\u00f3mo Obtener datos de\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/fr\/puissancebi\/obtenir-des-donnees-de-excel-a-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Obtener datos de Excel a Power BI\" \/>\n<meta property=\"og:description\" content=\"En esta secci\u00f3n, le mostramos c\u00f3mo conectar Power BI a archivos de Excel y c\u00f3mo obtener datos de Excel a Power BI. Para demostrar c\u00f3mo Obtener datos de\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/fr\/puissancebi\/obtenir-des-donnees-de-excel-a-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-09T19:21:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-9346584.png\" \/>\n\t<meta property=\"og:image:width\" content=\"610\" \/>\n\t<meta property=\"og:image:height\" content=\"663\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"R Marketing Digital\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Obtener datos de Excel a Power BI\",\"datePublished\":\"2022-06-09T19:21:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/\"},\"wordCount\":417,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Get-Data-from-Excel-to-Power-BI-3-9346584.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/\",\"name\":\"Obtener datos de Excel a Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Get-Data-from-Excel-to-Power-BI-3-9346584.png\",\"datePublished\":\"2022-06-09T19:21:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"En esta secci\u00f3n, le mostramos c\u00f3mo conectar Power BI a archivos de Excel y c\u00f3mo obtener datos de Excel a Power BI. Para demostrar c\u00f3mo Obtener datos de\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/fr\\\/powerbi\\\/obtenir-des-donnees-de-excel-a-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Get-Data-from-Excel-to-Power-BI-3-9346584.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Get-Data-from-Excel-to-Power-BI-3-9346584.png\",\"width\":610,\"height\":663,\"caption\":\"get-data-from-excel-to-power-bi-3-9346584-9979597-png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Obtenez des donn\u00e9es d&#039;Excel vers Power BI - R Marketing Digital","description":"Dans cette section, nous vous montrons comment connecter Power BI \u00e0 des fichiers Excel et comment obtenir des donn\u00e9es d&#039;Excel vers Power BI. Pour montrer comment obtenir des donn\u00e9es \u00e0 partir de","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:\/\/rmarketingdigital.com\/fr\/puissancebi\/obtenir-des-donnees-de-excel-a-power-bi\/","og_locale":"fr_FR","og_type":"article","og_title":"Obtener datos de Excel a Power BI","og_description":"En esta secci\u00f3n, le mostramos c\u00f3mo conectar Power BI a archivos de Excel y c\u00f3mo obtener datos de Excel a Power BI. Para demostrar c\u00f3mo Obtener datos de","og_url":"https:\/\/rmarketingdigital.com\/fr\/puissancebi\/obtenir-des-donnees-de-excel-a-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-06-09T19:21:31+00:00","og_image":[{"width":610,"height":663,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-9346584.png","type":"image\/png"}],"author":"R Marketing Digital","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Obtener datos de Excel a Power BI","datePublished":"2022-06-09T19:21:31+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/"},"wordCount":417,"image":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-9346584.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/","url":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/","name":"Obtenez des donn\u00e9es d&#039;Excel vers Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-9346584.png","datePublished":"2022-06-09T19:21:31+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Dans cette section, nous vous montrons comment connecter Power BI \u00e0 des fichiers Excel et comment obtenir des donn\u00e9es d&#039;Excel vers Power BI. Pour montrer comment obtenir des donn\u00e9es \u00e0 partir de","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/rmarketingdigital.com\/fr\/powerbi\/obtenir-des-donnees-de-excel-a-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-9346584.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Get-Data-from-Excel-to-Power-BI-3-9346584.png","width":610,"height":663,"caption":"get-data-from-excel-to-power-bi-3-9346584-9979597-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"Marketing num\u00e9rique","description":"Agence de r\u00e9f\u00e9rencement | Publicit\u00e9 sur les r\u00e9seaux sociaux | Gestion de communaut\u00e9","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rmarketingdigital.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"Marketing num\u00e9rique","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","caption":"R Marketing Digital"}}]}},"_links":{"self":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts\/85372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/comments?post=85372"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts\/85372\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/media\/85373"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/media?parent=85372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/categories?post=85372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/tags?post=85372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}