{"id":880,"date":"2020-12-16T10:12:14","date_gmt":"2020-12-16T10:12:14","guid":{"rendered":"https:\/\/www.lacajadeloscables.com\/?p=880"},"modified":"2020-12-16T10:24:00","modified_gmt":"2020-12-16T10:24:00","slug":"conecta-powerbi-con-typeform","status":"publish","type":"post","link":"https:\/\/www.lacajadeloscables.com\/?p=880","title":{"rendered":"Conecta PowerBI con Typeform"},"content":{"rendered":"\n<p>Si est\u00e1s buscando la manera de conectar PowerBI y Typeform te lo voy a poner muy f\u00e1cil. Necesitar\u00e1s lo primero de todo generar un token de acceso que te permitir\u00e1 acceder a la informaci\u00f3n de tu cuenta, para ello ve a la secci\u00f3n del perfil de usuario para generarlo.<\/p>\n\n\n\n<p>Una vez que ya lo tengas, desde PowerBI vamos a generar una conexi\u00f3n en blanco, esto nos permitir\u00e1 meter los siguientes valores. Recuerda que para verlo bien deber\u00edas activar en el men\u00fa Vista avanzada.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>let\n     apiUrl = \"https:\/\/api.typeform.com\/forms\/TU-ENCUESTA\/responses?since=2019-12-31T00%3A00%3A00&amp;until=2020-12-31T00%3A00%3A00\",\n     options = &#91;Headers =&#91;#\"authorization\"= \"bearer TU-TOKEN\"]],\n     result = Web.Contents(apiUrl , options)\nin\n     result<\/code><\/pre>\n\n\n\n<p>Sobre este c\u00f3digo tendr\u00e1s que modificar dos par\u00e1metros:<\/p>\n\n\n\n<p>1\u00ba &#8211; la url que pone \u00abTU-ENCUESTA\u00bb y modificarlo por el id de la encuesta sobre la que deseas realizar las consultas.<\/p>\n\n\n\n<p>2\u00ba &#8211; el token que has generado en el perfil de TypeForm y que deber\u00e1s sustituir por \u00abTU-TOKEN\u00bb.<\/p>\n\n\n\n<p>Como puedes ver en la url existen dos par\u00e1metros de fechas para poder identificar el rango de respuestas que quieres recibir, esta informaci\u00f3n est\u00e1 disponible en la documentaci\u00f3n del API en la secci\u00f3n de Response.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si est\u00e1s buscando la manera de conectar PowerBI y Typeform te lo voy a poner muy f\u00e1cil. Necesitar\u00e1s lo primero<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[384],"tags":[391,389,390],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Conecta PowerBI con Typeform - La caja de los cables<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.lacajadeloscables.com\/?p=880\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conecta PowerBI con Typeform - La caja de los cables\" \/>\n<meta property=\"og:description\" content=\"Si est\u00e1s buscando la manera de conectar PowerBI y Typeform te lo voy a poner muy f\u00e1cil. Necesitar\u00e1s lo primero\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.lacajadeloscables.com\/?p=880\" \/>\n<meta property=\"og:site_name\" content=\"La caja de los cables\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-16T10:12:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-16T10:24:00+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.lacajadeloscables.com\/?p=880\",\"url\":\"https:\/\/www.lacajadeloscables.com\/?p=880\",\"name\":\"Conecta PowerBI con Typeform - La caja de los cables\",\"isPartOf\":{\"@id\":\"https:\/\/www.lacajadeloscables.com\/#website\"},\"datePublished\":\"2020-12-16T10:12:14+00:00\",\"dateModified\":\"2020-12-16T10:24:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.lacajadeloscables.com\/#\/schema\/person\/e1f2c239c39115fd646cd99802e6e9ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.lacajadeloscables.com\/?p=880#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.lacajadeloscables.com\/?p=880\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.lacajadeloscables.com\/?p=880#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.lacajadeloscables.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conecta PowerBI con Typeform\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.lacajadeloscables.com\/#website\",\"url\":\"https:\/\/www.lacajadeloscables.com\/\",\"name\":\"La caja de los cables\",\"description\":\"Inform\u00e1tica y programaci\u00f3n para todos los usuarios\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.lacajadeloscables.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.lacajadeloscables.com\/#\/schema\/person\/e1f2c239c39115fd646cd99802e6e9ee\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.lacajadeloscables.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5b167eadb25012d586b14dc2fd5a5f01?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5b167eadb25012d586b14dc2fd5a5f01?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.lacajadeloscables.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conecta PowerBI con Typeform - La caja de los cables","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.lacajadeloscables.com\/?p=880","og_locale":"es_ES","og_type":"article","og_title":"Conecta PowerBI con Typeform - La caja de los cables","og_description":"Si est\u00e1s buscando la manera de conectar PowerBI y Typeform te lo voy a poner muy f\u00e1cil. Necesitar\u00e1s lo primero","og_url":"https:\/\/www.lacajadeloscables.com\/?p=880","og_site_name":"La caja de los cables","article_published_time":"2020-12-16T10:12:14+00:00","article_modified_time":"2020-12-16T10:24:00+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.lacajadeloscables.com\/?p=880","url":"https:\/\/www.lacajadeloscables.com\/?p=880","name":"Conecta PowerBI con Typeform - La caja de los cables","isPartOf":{"@id":"https:\/\/www.lacajadeloscables.com\/#website"},"datePublished":"2020-12-16T10:12:14+00:00","dateModified":"2020-12-16T10:24:00+00:00","author":{"@id":"https:\/\/www.lacajadeloscables.com\/#\/schema\/person\/e1f2c239c39115fd646cd99802e6e9ee"},"breadcrumb":{"@id":"https:\/\/www.lacajadeloscables.com\/?p=880#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lacajadeloscables.com\/?p=880"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.lacajadeloscables.com\/?p=880#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.lacajadeloscables.com\/"},{"@type":"ListItem","position":2,"name":"Conecta PowerBI con Typeform"}]},{"@type":"WebSite","@id":"https:\/\/www.lacajadeloscables.com\/#website","url":"https:\/\/www.lacajadeloscables.com\/","name":"La caja de los cables","description":"Inform\u00e1tica y programaci\u00f3n para todos los usuarios","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.lacajadeloscables.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.lacajadeloscables.com\/#\/schema\/person\/e1f2c239c39115fd646cd99802e6e9ee","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.lacajadeloscables.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5b167eadb25012d586b14dc2fd5a5f01?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5b167eadb25012d586b14dc2fd5a5f01?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.lacajadeloscables.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=\/wp\/v2\/posts\/880"}],"collection":[{"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=880"}],"version-history":[{"count":2,"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=\/wp\/v2\/posts\/880\/revisions"}],"predecessor-version":[{"id":882,"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=\/wp\/v2\/posts\/880\/revisions\/882"}],"wp:attachment":[{"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lacajadeloscables.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}