{"id":167138,"date":"2023-03-28T09:09:23","date_gmt":"2023-03-28T08:09:23","guid":{"rendered":"https:\/\/datascientest.com\/es\/?p=167138"},"modified":"2023-10-30T17:59:09","modified_gmt":"2023-10-30T16:59:09","slug":"como-conectar-power-bi-y-sql-server","status":"publish","type":"post","link":"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server","title":{"rendered":"\u00bfC\u00f3mo conectar Power BI y SQL Server?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"167138\" class=\"elementor elementor-167138\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c0e92f e-flex e-con-boxed e-con\" data-id=\"0c0e92f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2459707 elementor-widget elementor-widget-text-editor\" data-id=\"2459707\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><b>SQL Server y Power BI son dos herramientas complementarias para analizar tus datos. Por un lado, SQL Server es un sistema de gesti\u00f3n de bases de datos (SGBD) que permite almacenar, controlar, ordenar y actualizar bases de datos utilizando el lenguaje SQL. Por otro lado, Power BI es una herramienta de inteligencia empresarial cuyo objetivo es ayudar a las organizaciones a tomar las decisiones correctas a partir de los datos. Entonces, \u00bfc\u00f3mo conectar SQL Server y Power BI? Descubre tres formas de conseguirlo.<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d868cd4 e-flex e-con-boxed e-con\" data-id=\"d868cd4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-77a309e elementor-widget elementor-widget-heading\" data-id=\"77a309e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">A\u00f1ade aqu\u00ed tu texto de cabecera<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8b7836 elementor-widget elementor-widget-text-editor\" data-id=\"f8b7836\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Para conectar<\/span><a href=\"https:\/\/datascientest.com\/es\/power-bi-es\"> <b>Power BI<\/b><\/a> <span style=\"font-weight: 400;\">y SQL Server mediante un script, puedes utilizar R o Python. Aqu\u00ed encontrar\u00e1s un m\u00e9todo basado en el<\/span><a href=\"https:\/\/datascientest.com\/es\/python-un-zoom-en-el-lenguaje-mas-popular\"> <b>lenguaje Python<\/b><\/a><span style=\"font-weight: 400;\">.<\/span><\/p><p><b>Paso 1<\/b><span style=\"font-weight: 400;\">: Instala estas librer\u00edas usando Pip en el terminal de comandos:<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa00054 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"aa00054\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b>pip install pyodbc<\/b><\/p><p><b>pip install pandas<\/b><\/p><p><b>pip install matplotlib<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d80a314 elementor-widget elementor-widget-text-editor\" data-id=\"d80a314\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">La biblioteca pyodbc permite acceder a bases de datos ODBC (Open Database Connectivity).<\/span><\/p><p><span style=\"font-weight: 400;\">La <\/span><strong><a href=\"https:\/\/datascientest.com\/es\/pandas-python\">biblioteca pandas<\/a><\/strong><span style=\"font-weight: 400;\"> permite manipular y analizar datos.<\/span><\/p><p><span style=\"font-weight: 400;\">Por \u00faltimo, matplotlib permite dibujar gr\u00e1ficos y diagramas directamente desde pandas.<\/span><\/p><p><span style=\"font-weight: 400;\">Recuerda comprobar hacia d\u00f3nde apunta el directorio de inicio de Python. Para eso, ve a \u201cFiles\u201d y luego a \u201cOptions and Settings\u201d. Haz clic en \u201cPython Scripting\u201d y comprueba el \u201cPython Home Directory\u201d hacia el que apunta a tu Local Python Installation Path y tu \u201cPython ID\u201d&#8217; en el que el sistema ejecuta el script.<\/span><\/p><p><b>Paso 2<\/b><span style=\"font-weight: 400;\">: Selecciona \u201cGet Data\u201d en el panel de la parte superior de la pantalla.<\/span><\/p><p><span style=\"font-weight: 400;\">Se abrir\u00e1 el panel de \u201cGet Data\u201d. Selecciona \u201cOther\u201d y luego \u201cPython script\u201d. Haz clic en \u201cConnect\u201d.<\/span><\/p><p><b>Paso 3<\/b><span style=\"font-weight: 400;\">: En el cuadro de di\u00e1logo, escribe el siguiente script:<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-00f453c elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"00f453c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b>import pandas as pd<\/b><\/p><p><b>import pyodbc<\/b><\/p><p><b>conn = pyodbc.connect(&#8216;Driver={Servidor SQL};&#8217;<\/b><\/p><p><b>\u2018Server=servername;\u2019<\/b><\/p><p><b>\u2018Database=databasename;\u2019<\/b><\/p><p><b>\u2018Trusted_Connection=yes;\u2019)<\/b><\/p><p><b>cur= conn.cursor()<\/b><\/p><p><b>sqlquery = pd.read_sql_query(\u2018SELECT * FROM tablename\u2019,conn)<\/b><\/p><p><b>print(sqlquery)<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aeff138 elementor-widget elementor-widget-text-editor\" data-id=\"aeff138\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Esta consulta se conecta a SQL Server utilizando la biblioteca \u201cpyodbc\u201d instalada previamente y utiliza esta conexi\u00f3n para extraer los datos de nuestra tabla. A continuaci\u00f3n, estos datos se convierten y se cargan en Power BI.<\/span><\/p><p><b>Paso 4<\/b><span style=\"font-weight: 400;\">: En el panel \u201cNavigator\u201d, selecciona el resultado y haz clic en \u201cLoad\u201d.<\/span><\/p><p><span style=\"font-weight: 400;\">Entonces obtendr\u00e1s tus datos y podr\u00e1s visualizarlos como prefieras.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7fb63a1 e-flex e-con-boxed e-con\" data-id=\"7fb63a1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b914f31 elementor-widget elementor-widget-heading\" data-id=\"b914f31\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00bfC\u00f3mo utilizar un conector para Power BI y SQL Server ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50d7a7a elementor-widget elementor-widget-text-editor\" data-id=\"50d7a7a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Con este m\u00e9todo solo utilizas Power BI y un conector.<\/span><\/p><ol><li><span style=\"font-weight: 400;\">Abre Power BI Desktop (en tu ordenador).<\/span><\/li><li><span style=\"font-weight: 400;\">En el panel de la parte superior de la pantalla, haz clic en SQL Server.<\/span><\/li><li><span style=\"font-weight: 400;\">A continuaci\u00f3n, escribe el nombre del servidor en el cuadro de di\u00e1logo \u201cServer\u201d de la SQL Server database. Selecciona \u201cDirectQuery\u201d. En el cuadro de di\u00e1logo \u201cName\u201d, puedes especificar el nombre de tu base de datos.<\/span><\/li><li><span style=\"font-weight: 400;\">Haz clic en \u201cOK\u201d.<\/span><\/li><li><span style=\"font-weight: 400;\">De esta forma aparecer\u00e1 la tabla de datos y podr\u00e1s visualizar los datos como prefieras.<\/span><\/li><\/ol><p>\u00a0<\/p><p>Este enfoque es <b>muy pr\u00e1ctico <\/b>si ya has conectado SQL Server a Power BI.<span style=\"font-weight: 400;\"> Conectar estas dos herramientas puede resultar laborioso a veces. La otra desventaja es si seleccionas \u201cImport\u201d como tu Connectivity Mode. Se importar\u00e1n todos los datos: por lo que es dif\u00edcil explotar el potencial de visualizaci\u00f3n de Power BI.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9d1b586 e-flex e-con-boxed e-con\" data-id=\"9d1b586\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4f60253 elementor-widget elementor-widget-heading\" data-id=\"4f60253\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00bfC\u00f3mo exportar los datos de SQL Server a Excel e importarlos a Power BI ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5f805c2 elementor-widget elementor-widget-text-editor\" data-id=\"5f805c2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Este proceso es probablemente el que m\u00e1s tiempo consume, especialmente si repites esta tarea frecuentemente. Sin embargo, este m\u00e9todo de la vieja escuela funciona de maravilla.<\/span><\/p><p><b>Paso 1<\/b><span style=\"font-weight: 400;\">: En SQL Server, haz clic con el bot\u00f3n derecho en la base de datos que contiene tu futura tabla. A continuaci\u00f3n, haz clic en \u201cTasks\u201d y \u201cExport Data\u201d.<\/span><\/p><p><b>Paso 2<\/b><span style=\"font-weight: 400;\">: Se abrir\u00e1 el panel: \u201cChoose a Data Source\u00bb. Selecciona \u00abSQL Server Native CLient 11.0\u00bb como fuente de datos y haz clic en \u00abNext\u00bb.<\/span><\/p><p><b>Paso 3<\/b><span style=\"font-weight: 400;\">: A continuaci\u00f3n, haz clic en \u00abMicrosoft Excel\u00bb como destino. Determina la ruta y el nombre del archivo en el cuadro de di\u00e1logo \u201cExcel file path\u201d. A continuaci\u00f3n, haz clic en \u201cNext\u201d.<\/span><\/p><p><b>Paso 4<\/b><span style=\"font-weight: 400;\">: Si quieres exportar datos espec\u00edficos, selecciona \u201cWrite a query to specify the data to transfer\u201d. Haz clic en \u201cNext\u201d.<\/span><\/p><p><b>Paso 5<\/b><span style=\"font-weight: 400;\">: En el panel \u201cProvide a Source Query\u201d, introduce el siguiente script:<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef0c567 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"ef0c567\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b>SELECT * FROM tablename;<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e58b2e elementor-widget elementor-widget-text-editor\" data-id=\"3e58b2e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Haz clic en \u00abNext\u00bb.<\/span><\/p><p><span style=\"font-weight: 400;\">En los paneles \u201cSelect source tables and views\u201d y \u201cReview data mapping type\u201d, haz clic en \u201cNext\u201d. A continuaci\u00f3n, selecciona \u201cRun immediately\u201d en el panel \u201cSave and Run Package\u201d y haz clic en \u201cFinish\u201d.<\/span><\/p><p><b>Paso 6<\/b><span style=\"font-weight: 400;\">: Abre Power BI y selecciona Excel en el panel de la parte superior de la pantalla. Busca el archivo exportado desde SQL Server.<\/span><\/p><p><b>Paso 7<\/b><span style=\"font-weight: 400;\">: En el panel \u201cNavigator\u201d, selecciona tus datos y haz clic en \u201cLoad\u201d.<\/span><\/p><p><span style=\"font-weight: 400;\">Ver\u00e1s que tus datos aparecen en Power BI.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-29b0764 e-flex e-con-boxed e-con\" data-id=\"29b0764\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-80bac33 elementor-widget elementor-widget-heading\" data-id=\"80bac33\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">A\u00f1ade aqu\u00ed tu texto de cabecera<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-355401f elementor-widget elementor-widget-text-editor\" data-id=\"355401f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Hay varias maneras de conectar SQL Server y Power BI, cada una con sus propias <\/span><b>ventajas y desventajas<\/b><span style=\"font-weight: 400;\">. Puedes usar un script R o Python para realizar la conexi\u00f3n, usar un conector espec\u00edfico o exportar los datos SQL a Excel e importarlos a Power BI. El m\u00e9todo que utilices depender\u00e1 de tus preferencias y <\/span><b>necesidades espec\u00edficas<\/b><span style=\"font-weight: 400;\">.<\/span><\/p><p><span style=\"font-weight: 400;\">Usando cualquiera de estos m\u00e9todos, puedes <\/span><b>conectar f\u00e1cilmente<\/b><span style=\"font-weight: 400;\"> SQL Server y Power BI para acceder a tus datos y obtener informaci\u00f3n para mejorar tu toma de decisiones.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-15a2071 elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"15a2071\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/es\/nuestros-cursos-de-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Descubrir los cursos de DataScientest<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ebc65d8 e-flex e-con-boxed e-con\" data-id=\"ebc65d8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d6fddd4 elementor-widget elementor-widget-html\" data-id=\"d6fddd4\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00bfC\u00f3mo conectar SQL Server y Power BI  ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Para conectar Power BI y SQL Server mediante un script, puedes utilizar R o Python. Aqu\u00ed encontrar\u00e1s un m\u00e9todo basado en el lenguaje Python.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00bfC\u00f3mo exportar los datos de SQL Server a Excel e importarlos a Power BI ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Este proceso es probablemente el que m\u00e1s tiempo consume, especialmente si repites esta tarea frecuentemente. Sin embargo, este m\u00e9todo de la vieja escuela funciona de maravilla.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>SQL Server y Power BI son dos herramientas complementarias para analizar tus datos. Por un lado, SQL Server es un sistema de gesti\u00f3n de bases de datos (SGBD) que permite almacenar, controlar, ordenar y actualizar bases de datos utilizando el lenguaje SQL. Por otro lado, Power BI es una herramienta de inteligencia empresarial cuyo objetivo [&hellip;]<\/p>\n","protected":false},"author":63,"featured_media":167139,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2427],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfC\u00f3mo conectar Power BI y SQL Server?<\/title>\n<meta name=\"description\" content=\"SQL Server y Power BI son dos herramientas complementarias para analizar tus datos. Por un lado, SQL Server es un sistema de gesti\u00f3n de bases de datos (SGBD) que permite almacenar, controlar, ordenar y actualizar bases de datos utilizando el lenguaje SQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfC\u00f3mo conectar Power BI y SQL Server?\" \/>\n<meta property=\"og:description\" content=\"SQL Server y Power BI son dos herramientas complementarias para analizar tus datos. Por un lado, SQL Server es un sistema de gesti\u00f3n de bases de datos\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server\" \/>\n<meta property=\"og:site_name\" content=\"DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-28T08:09:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T16:59:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/es\/wp-content\/blogs.dir\/7\/files\/2023\/03\/connecter-power-bi-slq-server.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"\u00bfC\u00f3mo conectar Power BI y SQL Server?\",\"datePublished\":\"2023-03-28T08:09:23+00:00\",\"dateModified\":\"2023-10-30T16:59:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server\"},\"wordCount\":888,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/es\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server\",\"url\":\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server\",\"name\":\"\u00bfC\u00f3mo conectar Power BI y SQL Server?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/es\/#website\"},\"datePublished\":\"2023-03-28T08:09:23+00:00\",\"dateModified\":\"2023-10-30T16:59:09+00:00\",\"description\":\"SQL Server y Power BI son dos herramientas complementarias para analizar tus datos. Por un lado, SQL Server es un sistema de gesti\u00f3n de bases de datos (SGBD) que permite almacenar, controlar, ordenar y actualizar bases de datos utilizando el lenguaje SQL.\",\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/es\/#website\",\"url\":\"https:\/\/datascientest.com\/es\/\",\"name\":\"DataScientest\",\"description\":\"L\u00edder en formaci\u00f3n en Ciencia de Datos\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/es\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/es\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/datascientest.com\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/es\/wp-content\/blogs.dir\/7\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/es\/wp-content\/blogs.dir\/7\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/es\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/company\/datascientest-spain\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"\",\"url\":\"https:\/\/datascientest.com\/es\/author\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u00bfC\u00f3mo conectar Power BI y SQL Server?","description":"SQL Server y Power BI son dos herramientas complementarias para analizar tus datos. Por un lado, SQL Server es un sistema de gesti\u00f3n de bases de datos (SGBD) que permite almacenar, controlar, ordenar y actualizar bases de datos utilizando el lenguaje SQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server","og_locale":"es_ES","og_type":"article","og_title":"\u00bfC\u00f3mo conectar Power BI y SQL Server?","og_description":"SQL Server y Power BI son dos herramientas complementarias para analizar tus datos. Por un lado, SQL Server es un sistema de gesti\u00f3n de bases de datos","og_url":"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server","og_site_name":"DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-03-28T08:09:23+00:00","article_modified_time":"2023-10-30T16:59:09+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/es\/wp-content\/blogs.dir\/7\/files\/2023\/03\/connecter-power-bi-slq-server.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Escrito por":"","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server#article","isPartOf":{"@id":"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server"},"author":{"name":"","@id":""},"headline":"\u00bfC\u00f3mo conectar Power BI y SQL Server?","datePublished":"2023-03-28T08:09:23+00:00","dateModified":"2023-10-30T16:59:09+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server"},"wordCount":888,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/es\/#organization"},"articleSection":["Data Science"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server","url":"https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server","name":"\u00bfC\u00f3mo conectar Power BI y SQL Server?","isPartOf":{"@id":"https:\/\/datascientest.com\/es\/#website"},"datePublished":"2023-03-28T08:09:23+00:00","dateModified":"2023-10-30T16:59:09+00:00","description":"SQL Server y Power BI son dos herramientas complementarias para analizar tus datos. Por un lado, SQL Server es un sistema de gesti\u00f3n de bases de datos (SGBD) que permite almacenar, controlar, ordenar y actualizar bases de datos utilizando el lenguaje SQL.","inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/es\/como-conectar-power-bi-y-sql-server"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/es\/#website","url":"https:\/\/datascientest.com\/es\/","name":"DataScientest","description":"L\u00edder en formaci\u00f3n en Ciencia de Datos","publisher":{"@id":"https:\/\/datascientest.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/es\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/es\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/datascientest.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/es\/wp-content\/blogs.dir\/7\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/es\/wp-content\/blogs.dir\/7\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/company\/datascientest-spain\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"","url":"https:\/\/datascientest.com\/es\/author"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/posts\/167138"}],"collection":[{"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/comments?post=167138"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/posts\/167138\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/media\/167139"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/media?parent=167138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/categories?post=167138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/es\/wp-json\/wp\/v2\/tags?post=167138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}