{"id":98853,"date":"2022-08-07T07:41:23","date_gmt":"2022-08-07T05:41:23","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/"},"modified":"2021-07-14T15:52:59","modified_gmt":"2021-07-14T13:52:59","slug":"jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/","title":{"rendered":"Jupyter als externes Tool f\u00fcr Power BI Desktop (Python Teil 4)"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contenidos<\/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:\/\/rmarketingdigital.com\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#Open-Jupyter-fundamental-pero-no-util\" >Open Jupyter: fundamental pero no \u00fatil<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#Crear-y-abrir-un-cuaderno-codificado\" >Crear y abrir un cuaderno (codificado)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#Crear-y-abrir-un-cuaderno-definido-en-un-Gist-de-GitHub\" >Crear y abrir un cuaderno definido en un Gist de GitHub<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#Ampliacion-de-la-definicion-del-portatil\" >Ampliaci\u00f3n de la definici\u00f3n del port\u00e1til<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#Desbloqueo-de-mas\" >Desbloqueo de m\u00e1s<\/a><\/li><\/ul><\/nav><\/div>\n<p>Mucha gente usa Python con cuadernos, as\u00ed que echemos un vistazo a una forma posible de habilitar un <a href=\"https:\/\/jupyter.org\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" aria-label=\"Jupyter (opens in a new tab)\">Jupyter<\/a> herramienta externa para Power BI Desktop. El siguiente enfoque escalonado comienza con simplemente abrir Jupyter. Luego avanza para crear y abrir un cuaderno que incluye Power BI <em>servidor<\/em> y <em>base de datos<\/em> argumentos. Finalmente, se abre camino hacia la descarga de una definici\u00f3n de cuaderno contenida en una esencia de GitHub y se conecta al modelo tabular de Power BI para comenzar a hacer que este enfoque sea m\u00e1s \u00fatil.<\/p>\n<p>Esta publicaci\u00f3n contin\u00faa una serie de publicaciones relacionadas con Python y Power BI. Las primeras tres partes de esta serie de blogs introdujeron algunos usos posibles de Python conectado a un modelo de Power BI, c\u00f3mo configurar una herramienta externa b\u00e1sica de Python y c\u00f3mo usarla con un entorno virtual y conectarse al modelo de objetos tabulares.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Open-Jupyter-fundamental-pero-no-util\"><\/span>Open Jupyter: fundamental pero no \u00fatil<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yo uso el <a href=\"https:\/\/www.anaconda.com\/products\/individual\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Anaconda<\/a> distribuci\u00f3n en estos ejemplos, y consideremos c\u00f3mo simplemente iniciar y abrir un cuaderno (vainilla Jupyter y nada con JupyterLab). Solo necesitamos un archivo pbitool.json en esta etapa porque el objetivo es simplemente iniciar Jupyter, ni siquiera un archivo de cuaderno. No es un ejemplo \u00fatil, pero proporciona una base sobre la que construiremos.<\/p>\n<p>Como se discuti\u00f3 en la Parte 2, los archivos pbitool.json definen las herramientas externas de Power BI Desktop. Si observa el acceso directo de Jupyter, proporciona la inspiraci\u00f3n sobre c\u00f3mo definir la herramienta externa de Power BI.<\/p>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-8679 jetpack-lazy-image\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-9396482.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-9396482.png 520w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-9396482-300x157.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-9396482-16x8.png 16w\" alt=\"image-9396482\" data-attachment-id=\"8679\" data-permalink=\"https:\/\/dataveld.com\/2020\/08\/17\/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4\/image-18\/\" data-orig-file=\"https:\/\/i2.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image.png?fit=520%2C272&amp;ssl=1\" data-orig-size=\"520,272\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image\" data-image-description=\"\" data-medium-file=\"https:\/\/i2.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image.png?fit=300%2C157&amp;ssl=1\" data-large-file=\"https:\/\/i2.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image.png?fit=520%2C272&amp;ssl=1\" data-recalc-dims=\"1\" data-lazy-srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-9396482.png 520w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-9396482-300x157.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-9396482-16x8.png 16w\" data-lazy-sizes=\"(max-width: 520px) 100vw, 520px\" data-lazy-src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-9396482.png\" \/><noscript><img alt='image-6478165' data-attachment-id=\"8679\" data-permalink=\"https:\/\/dataveld.com\/2020\/08\/17\/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4\/image-18\/\" data-orig-file=\"https:\/\/i2.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image.png?fit=520%2C272&amp;ssl=1\" data-orig-size=\"520,272\" data-comments-opened=\"1\" data-image-meta='{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}' data-image-title=\"image\" data-image-description=\"\" data-medium-file=\"https:\/\/i2.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image.png?fit=300%2C157&amp;ssl=1\" data-large-file=\"https:\/\/i2.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image.png?fit=520%2C272&amp;ssl=1\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-6478165.png' alt=\"\" class=\"wp-image-8679\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-6478165.png 520w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-6478165-300x157.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-6478165-16x8.png 16w' sizes='(max-width: 520px) 100vw, 520px' data-recalc-dims=\"1\"><\/noscript><\/figure>\n<p>El JSON en esta esencia deber\u00eda guardarse como un [tool].pbitool.json y se coloca en C: Archivos de programa (x86) Archivos comunes Microsoft Shared Power BI Desktop Herramientas externas.<\/p>\n<p>Tenga en cuenta que la ruta es para Python.exe y los argumentos cargan el entorno Python predeterminado y ejecutan el <strong>jupyter-notebook-script.py<\/strong> script para iniciar Jupyter.<\/p>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-8680 jetpack-lazy-image\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-5659520.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-5659520.png 640w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-5659520-300x93.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-5659520-16x5.png 16w\" alt=\"image-1-5659520\" data-attachment-id=\"8680\" data-permalink=\"https:\/\/dataveld.com\/2020\/08\/17\/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4\/image-1-5\/\" data-orig-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-1.png?fit=652%2C202&amp;ssl=1\" data-orig-size=\"652,202\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-1\" data-image-description=\"\" data-medium-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-1.png?fit=300%2C93&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-1.png?fit=640%2C198&amp;ssl=1\" data-recalc-dims=\"1\" data-lazy-srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-5659520.png 640w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-5659520-300x93.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-5659520-16x5.png 16w\" data-lazy-sizes=\"(max-width: 640px) 100vw, 640px\" data-lazy-src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-5659520.png\" \/><noscript><img alt='image-1-6665538' data-attachment-id=\"8680\" data-permalink=\"https:\/\/dataveld.com\/2020\/08\/17\/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4\/image-1-5\/\" data-orig-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-1.png?fit=652%2C202&amp;ssl=1\" data-orig-size=\"652,202\" data-comments-opened=\"1\" data-image-meta='{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}' data-image-title=\"image-1\" data-image-description=\"\" data-medium-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-1.png?fit=300%2C93&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-1.png?fit=640%2C198&amp;ssl=1\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-6665538.png' alt=\"\" class=\"wp-image-8680\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-6665538.png 640w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-6665538-300x93.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-1-6665538-16x5.png 16w' sizes='(max-width: 640px) 100vw, 640px' data-recalc-dims=\"1\"><\/noscript><\/figure>\n<p>Sin embargo, no tiene ning\u00fan valor simplemente abrir Jupyter. En esta etapa, no es m\u00e1s que un reemplazo de un atajo. El valor real es integrar Power BI Desktop m\u00e1s estrechamente con el port\u00e1til.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Crear-y-abrir-un-cuaderno-codificado\"><\/span>Crear y abrir un cuaderno (codificado)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yendo un paso m\u00e1s all\u00e1, creemos un cuaderno vac\u00edo y escribamos la informaci\u00f3n de conexi\u00f3n de Power BI Desktop actualmente abierta en las celdas del cuaderno. En este caso, necesitamos un script Python junto con un nuevo [tool]Archivo .pbitool.json.<\/p>\n<p>los [tool]El archivo .pbitool.json tiene algunas diferencias con la versi\u00f3n anterior. En particular, ejecuta un script de Python que he nombrado <strong>powerbinotebook.py <\/strong>y colocado en mi <strong>C: Temp<\/strong> directorio. Tambi\u00e9n ver\u00e1 el <em>servidor<\/em> y <em>base de datos<\/em> argumentos que usa Power BI Desktop para pasar la conexi\u00f3n local actual (servidor: puerto y GUID de la base de datos).<\/p>\n<p>C: \/Temp\/powerbinotebook.py \u201d% servidor% \u201d \u201d% base de datos% \u201d<\/p>\n<p>El resto de los argumentos inician el entorno Python predeterminado y ejecutan Jupyter, pero es importante que el <em>powerbinotebook.py<\/em> El script se ejecuta antes de que se inicie Jupyter. \u00bfPorqu\u00e9 es eso?<\/p>\n<p>El script Python define un cuaderno casi vac\u00edo para Jupyter y luego lo lanza en Jupyter. Pon mucha atenci\u00f3n a <strong>notebook_core<\/strong>, que contiene la definici\u00f3n JSON para el cuaderno y escribe sys.argv[1] y sys.argv[2] en el cuaderno para el servidor de Power BI y la base de datos respectivamente. Cada celda en el <em>c\u00e9lulas<\/em> La matriz aparecer\u00e1 como una celda separada en el cuaderno de muestra. Como lo requiere la definici\u00f3n pbitool.json anterior, la secuencia de comandos de Python se encuentra en <strong>C: Temp powerbinotebook.py<\/strong>, y obviamente podr\u00eda nombrar y guardar el suyo en la ubicaci\u00f3n que elija.<\/p>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-8681 jetpack-lazy-image\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-8664612.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-8664612.png 640w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-8664612-300x92.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-8664612-16x5.png 16w\" alt=\"image-2-8664612\" data-attachment-id=\"8681\" data-permalink=\"https:\/\/dataveld.com\/2020\/08\/17\/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4\/image-2-5\/\" data-orig-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-2.png?fit=650%2C201&amp;ssl=1\" data-orig-size=\"650,201\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-2\" data-image-description=\"\" data-medium-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-2.png?fit=300%2C93&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-2.png?fit=640%2C198&amp;ssl=1\" data-recalc-dims=\"1\" data-lazy-srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-8664612.png 640w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-8664612-300x92.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-8664612-16x5.png 16w\" data-lazy-sizes=\"(max-width: 640px) 100vw, 640px\" data-lazy-src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-8664612.png\" \/><noscript><img alt='image-2-3923653' data-attachment-id=\"8681\" data-permalink=\"https:\/\/dataveld.com\/2020\/08\/17\/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4\/image-2-5\/\" data-orig-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-2.png?fit=650%2C201&amp;ssl=1\" data-orig-size=\"650,201\" data-comments-opened=\"1\" data-image-meta='{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}' data-image-title=\"image-2\" data-image-description=\"\" data-medium-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-2.png?fit=300%2C93&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/dataveld.com\/wp-content\/uploads\/2020\/08\/image-2.png?fit=640%2C198&amp;ssl=1\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-3923653.png' alt=\"\" class=\"wp-image-8681\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-3923653.png 640w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-3923653-300x92.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2021\/01\/image-2-3923653-16x5.png 16w' sizes='(max-width: 640px) 100vw, 640px' data-recalc-dims=\"1\"><\/noscript><\/figure>\n<p>El siguiente video muestra la ejecuci\u00f3n b\u00e1sica del script, donde el script de Python crea el cuaderno, inicia Jupyter y Jupyter inicia el cuaderno.<\/p>\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\">\n<div class=\"wp-block-embed__wrapper\">\n<p><iframe loading=\"lazy\" title=\"Power BI Jupyter External Tool - Basic Notebook Creation\" width=\"1080\" height=\"608\" src=\"https:\/\/www.youtube.com\/embed\/hJexIEr17-s?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<\/div>\n<\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Crear-y-abrir-un-cuaderno-definido-en-un-Gist-de-GitHub\"><\/span>Crear y abrir un cuaderno definido en un Gist de GitHub<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yendo un paso m\u00e1s all\u00e1, cambiemos la definici\u00f3n del cuaderno a una esencia de GitHub en lugar de codificarla en el script de Python. La esencia contiene JSON y tambi\u00e9n marcadores de posici\u00f3n para<strong> &lt;&gt; <\/strong>y <strong>&lt;&gt;<\/strong>, que la secuencia de comandos de Python reemplazar\u00e1 con el archivo sys.argv real[1] y sys.argv[2] valores.<\/p>\n<p>Ejemplo de esencia (no incrustado en la publicaci\u00f3n): <a href=\"https:\/\/gist.github.com\/deldersveld\/fdada06b82621233d6e40fac13cceb55\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">https:\/\/gist.github.com\/deldersveld\/fdada06b82621233d6e40fac13cceb55<\/a><\/p>\n<p>Yo us\u00e9 lo mismo [tool].pbitool.json, ya que solo cambia el contenido del script powerbinotebook.py. Tenga en cuenta que el script es mucho m\u00e1s corto ahora que ya no contiene la definici\u00f3n del cuaderno. Esto usa el <em>peticiones<\/em> biblioteca para obtener la plantilla de cuaderno JSON de la URL definida en <strong>gist_url<\/strong>. Note tambi\u00e9n c\u00f3mo <em>reemplazar<\/em> intercambia los valores actuales del servidor y la base de datos de Power BI.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ampliacion-de-la-definicion-del-portatil\"><\/span>Ampliaci\u00f3n de la definici\u00f3n del port\u00e1til<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Finalmente, construyamos un cuaderno un poco m\u00e1s complejo con una actualizaci\u00f3n <strong>powerbinotebook.py<\/strong> gui\u00f3n. Como antes, no se requieren modificaciones para [tool].pbitool.json. Solo se actualiza la secuencia de comandos de Python.<\/p>\n<p>Aqu\u00ed est\u00e1 el Gist del cuaderno actualizado como referencia (no incrustado en la publicaci\u00f3n):<br \/>\n<a href=\"https:\/\/gist.github.com\/deldersveld\/70e05dbc97086181641592f03d314800\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">https:\/\/gist.github.com\/deldersveld\/70e05dbc97086181641592f03d314800<\/a><\/p>\n<p>Al igual que con el \u00faltimo ejemplo, el script de Python descarga la nueva definici\u00f3n de cuaderno contenida en una esencia de GitHub diferente. Adem\u00e1s, como antes, reemplaza los marcadores de posici\u00f3n &lt;&gt; y &lt;&gt; con los valores reales pasados \u200b\u200ba sys.argv desde Power BI Desktop.<\/p>\n<p>Lo nuevo aqu\u00ed es que este script descarga el <strong>ssas_api.py <\/strong>m\u00f3dulo mencionado en la publicaci\u00f3n de la Parte 3, que es una de las muchas formas posibles de conectar Python a AMO \/ TOM y otras bibliotecas .NET. El cuaderno de muestra actualizado carga el m\u00f3dulo y demuestra la conectividad del modelo b\u00e1sico.<\/p>\n<p>TENGA EN CUENTA que la secuencia de comandos no sobrescribe intencionalmente un cuaderno una vez que se crea para un n\u00famero de puerto espec\u00edfico. Para obtener una nueva plantilla en blanco si est\u00e1 probando esto, simplemente requiere cerrar y volver a abrir Power BI Desktop. La conexi\u00f3n a TOM en este ejemplo tambi\u00e9n requiere una conexi\u00f3n de Power BI Desktop con al menos una tabla existente.<\/p>\n<p>Aqu\u00ed tienes un vistazo al cuaderno de muestra en acci\u00f3n. Ilustra dos cosas: una conexi\u00f3n b\u00e1sica a TOM y la evaluaci\u00f3n de una consulta DAX con el modelo abierto en Power BI Desktop.<\/p>\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\">\n<div class=\"wp-block-embed__wrapper\">\n<p><iframe loading=\"lazy\" title=\"Power BI Desktop Jupyter External Tool - Sample Notebook\" width=\"1080\" height=\"608\" src=\"https:\/\/www.youtube.com\/embed\/E6phRKwDB14?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<\/div>\n<\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Desbloqueo-de-mas\"><\/span>Desbloqueo de m\u00e1s<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Con una conexi\u00f3n en vivo al modelo de Power BI Desktop de Python, puede desbloquear muchas posibilidades. Como se describe en la Parte 1, hay muchos ejemplos que van desde la visualizaci\u00f3n de datos hasta la actualizaci\u00f3n del modelo. Tengo curiosidad por conocer su opini\u00f3n sobre c\u00f3mo le gustar\u00eda usar Python en Power BI.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mucha gente usa Python con cuadernos, as\u00ed que echemos un vistazo a una forma posible de habilitar un Jupyter herramienta externa para Power BI Desktop. El siguiente enfoque escalonado comienza&#8230;<\/p>","protected":false},"author":1,"featured_media":82042,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359],"tags":[],"class_list":["post-98853","post","type-post","status-publish","format-standard","has-post-thumbnail","category-powerbi"],"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>Jupyter como herramienta externa para Power BI Desktop (Python Parte 4) - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"Mucha gente usa Python con cuadernos, as\u00ed que echemos un vistazo a una forma posible de habilitar un Jupyter herramienta externa para Power BI Desktop. El\" \/>\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\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jupyter como herramienta externa para Power BI Desktop (Python Parte 4)\" \/>\n<meta property=\"og:description\" content=\"Mucha gente usa Python con cuadernos, as\u00ed que echemos un vistazo a una forma posible de habilitar un Jupyter herramienta externa para Power BI Desktop. El\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-07T05:41:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Jupyter-7915128.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1705\" \/>\n\t<meta property=\"og:image:height\" content=\"1011\" \/>\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\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Jupyter como herramienta externa para Power BI Desktop (Python Parte 4)\",\"datePublished\":\"2022-08-07T05:41:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/\"},\"wordCount\":1194,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-Jupyter-7915128.png\",\"articleSection\":[\"Power BI\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/\",\"name\":\"Jupyter como herramienta externa para Power BI Desktop (Python Parte 4) - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-Jupyter-7915128.png\",\"datePublished\":\"2022-08-07T05:41:23+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"Mucha gente usa Python con cuadernos, as\u00ed que echemos un vistazo a una forma posible de habilitar un Jupyter herramienta externa para Power BI Desktop. El\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-Jupyter-7915128.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-Jupyter-7915128.png\",\"width\":1705,\"height\":1011,\"caption\":\"power-bi-jupyter-7915128-5848900-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\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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":"Jupyter como herramienta externa para Power BI Desktop (Python Parte 4) - R Marketing Digital","description":"Mucha gente usa Python con cuadernos, as\u00ed que echemos un vistazo a una forma posible de habilitar un Jupyter herramienta externa para Power BI Desktop. El","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\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/","og_locale":"de_DE","og_type":"article","og_title":"Jupyter como herramienta externa para Power BI Desktop (Python Parte 4)","og_description":"Mucha gente usa Python con cuadernos, as\u00ed que echemos un vistazo a una forma posible de habilitar un Jupyter herramienta externa para Power BI Desktop. El","og_url":"https:\/\/rmarketingdigital.com\/de\/energiebi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/","og_site_name":"R Marketing Digital","article_published_time":"2022-08-07T05:41:23+00:00","og_image":[{"width":1705,"height":1011,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Jupyter-7915128.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\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Jupyter como herramienta externa para Power BI Desktop (Python Parte 4)","datePublished":"2022-08-07T05:41:23+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/"},"wordCount":1194,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Jupyter-7915128.png","articleSection":["Power BI"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/","name":"Jupyter como herramienta externa para Power BI Desktop (Python Parte 4) - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Jupyter-7915128.png","datePublished":"2022-08-07T05:41:23+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Mucha gente usa Python con cuadernos, as\u00ed que echemos un vistazo a una forma posible de habilitar un Jupyter herramienta externa para Power BI Desktop. El","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/rmarketingdigital.com\/powerbi\/jupyter-como-herramienta-externa-para-power-bi-desktop-python-parte-4\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Jupyter-7915128.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Jupyter-7915128.png","width":1705,"height":1011,"caption":"power-bi-jupyter-7915128-5848900-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digitales Marketing","description":"SEO Agentur | Werbung f\u00fcr soziale Netzwerke | 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":"de"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digitales Marketing","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/wp-json\/wp\/v2\/posts\/98853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/comments?post=98853"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts\/98853\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media\/82042"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media?parent=98853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/categories?post=98853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/tags?post=98853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}