{"id":18183,"date":"2025-01-16T06:30:03","date_gmt":"2025-01-16T09:30:03","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=18183"},"modified":"2025-01-27T20:26:23","modified_gmt":"2025-01-27T23:26:23","slug":"filtrar-filas-con-power-query","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/","title":{"rendered":"POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FILTRAR FILAS"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><strong>Filtrar filas en Power Query<\/strong> es una t\u00e9cnica esencial para organizar y limpiar tus datos de manera eficiente. Con esta herramienta de Excel, puedes eliminar informaci\u00f3n innecesaria, como filas de resumen o encabezados duplicados, y dejar \u00fanicamente los registros relevantes para tu an\u00e1lisis. En este art\u00edculo aprender\u00e1s paso a paso c\u00f3mo utilizar filtros en Power Query para transformar tus datos y optimizar tu flujo de trabajo.<\/p><div id=\"excel-724153023\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>&nbsp;<\/p>\n<h2>\u00bfQU\u00c9 ES POWER QUERY Y POR QU\u00c9 FILTRAR FILAS ES IMPORTANTE?<\/h2>\n<p>Power Query es una herramienta de Excel dise\u00f1ada para conectar, combinar y transformar datos de diversas fuentes. Entre sus funcionalidades clave, filtrar filas te permite:<\/p>\n<ul>\n<li>Eliminar datos irrelevantes o repetitivos.<\/li>\n<li>Preparar tablas limpias para an\u00e1lisis precisos.<\/li>\n<li>Reducir el tama\u00f1o y la complejidad de tus datos.<\/li>\n<\/ul>\n<p>Filtrar filas en Power Query es especialmente \u00fatil cuando trabajas con reportes que incluyen objetos extra\u00f1os, como filas de resumen o n\u00fameros de p\u00e1gina, que pueden dificultar el procesamiento de la informaci\u00f3n.<\/p>\n<p>&nbsp;<\/p>\n<h2>C\u00d3MO FILTRAR FILAS EN POWER QUERY: GU\u00cdA PASO A PASO<\/h2>\n<p><iframe loading=\"lazy\" title=\"PQ Filtrar\" src=\"https:\/\/player.vimeo.com\/video\/1049051916?h=31a30d324d&amp;dnt=1&amp;app_id=122963\" width=\"1200\" height=\"675\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/p>\n<h3 style=\"padding-left: 40px;\">1. CONFIGURA TU ESCENARIO<\/h3>\n<p style=\"padding-left: 80px;\">Las filas que no contienen datos, como las que separan pedidos o muestran n\u00fameros de p\u00e1gina, pueden interferir con el an\u00e1lisis. Por ejemplo, nuestros datos de muestra incluyen filas de resumen despu\u00e9s de las transacciones diarias de cada representante de ventas. Sin embargo, estas filas dificultan la s\u00edntesis de los datos, por lo que se pueden eliminar mediante un filtro simple. En escenarios m\u00e1s complejos, puede ser necesario realizar una serie de filtros para obtener los resultados deseados. Procedamos a eliminarlas.<\/p>\n<h3 style=\"padding-left: 40px;\">2. ABRE EL EDITOR DE POWER QUERY<\/h3>\n<p style=\"padding-left: 80px;\"><strong>1.<\/strong> Ve al panel de <strong>Consultas y conexiones<\/strong> en la parte derecha de Excel (puedes abrirlo desde la pesta\u00f1a <strong>Datos<\/strong> &gt; <strong>Consultas y conexiones<\/strong>).<\/p>\n<p style=\"padding-left: 80px;\"><strong>2.<\/strong> Haz doble clic en el nombre de la consulta para abrir el <strong>Editor de Power Query<\/strong> nuevamente.<\/p>\n<p style=\"padding-left: 80px;\"><strong>3.<\/strong> Esto abrir\u00e1 el <strong>Editor de Power Query<\/strong>, mostrando tus datos en un panel de vista previa.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"padding-left: 40px;\">3. IDENTIFICA LAS FILAS A ELIMINAR<\/h3>\n<p style=\"padding-left: 80px;\">En nuestro ejemplo, las filas de resumen contienen la frase \u00abTotal de ventas por representante\u00bb en la columna \u00abNombre del producto\u00bb.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"padding-left: 40px;\">4. APLICA UN FILTRO DE FILAS<\/h3>\n<p style=\"padding-left: 80px;\"><strong>1.<\/strong> Haz clic en la flecha desplegable de filtro en la columna <strong>Nombre del producto<\/strong>.<\/p>\n<p style=\"padding-left: 80px;\"><strong>2.<\/strong> Selecciona <strong>Filtros de texto &gt; No empieza por<\/strong>.<\/p>\n<p style=\"padding-left: 120px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18207\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-1.png\" alt=\"filtrar filas\" width=\"650\" height=\"411\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-1.png 970w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-1-768x486.png 768w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/p>\n<p style=\"padding-left: 80px;\"><strong>3.<\/strong> Escribe la palabra <strong>Informe<\/strong> y haz clic en <strong>Aceptar<\/strong>.<\/p>\n<p style=\"padding-left: 120px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18208\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-2.png\" alt=\"filtrar filas\" width=\"650\" height=\"321\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-2.png 1174w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-2-1000x493.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-2-768x379.png 768w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/p>\n<p style=\"padding-left: 80px;\"><strong>4.<\/strong> Power Query eliminar\u00e1 autom\u00e1ticamente las filas que contienen esa frase, dejando solo los datos transaccionales.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"padding-left: 40px;\">5. REVISA LOS DATOS FILTRADOS<\/h3>\n<p style=\"padding-left: 80px;\">Aseg\u00farate de que las filas restantes son las que deseas conservar. Si cometiste un error, puedes editar o eliminar el paso en el panel de <strong>Configuraci\u00f3n de consulta<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"padding-left: 40px;\">6. GUARDA LOS CAMBIOS<\/h3>\n<p style=\"padding-left: 80px;\"><strong>1.<\/strong> Ve a la pesta\u00f1a <strong>Inicio<\/strong> en el Editor de Power Query.<\/p>\n<p style=\"padding-left: 80px;\"><strong>2.<\/strong> Haz clic en <strong>Cerrar y cargar<\/strong> para exportar los datos filtrados a una nueva hoja de c\u00e1lculo en Excel.<\/p>\n<p style=\"padding-left: 120px;\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18209 alignnone\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-3.png\" alt=\"filtrar filas\" width=\"650\" height=\"505\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-3.png 929w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/PQ-Filtros-3-768x597.png 768w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/p>\n<h2>CONSEJOS PARA OPTIMIZAR TUS FILTROS<\/h2>\n<ol>\n<li><strong>Combina filtros:<\/strong> Puedes aplicar m\u00faltiples filtros para afinar a\u00fan m\u00e1s tus datos.<\/li>\n<li><strong>Guarda la consulta:<\/strong> Si necesitas usar el mismo filtro en el futuro, guarda la consulta en Power Query.<\/li>\n<li><strong>Documenta tus pasos:<\/strong> Utiliza nombres descriptivos en cada transformaci\u00f3n para entender f\u00e1cilmente tu flujo de trabajo.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2>PREGUNTAS FRECUENTES (FAQ) SOBRE FILTRAR FILAS EN PQ<\/h2>\n<p><strong>1. \u00bfQu\u00e9 ocurre si elimino una fila por error?<\/strong><\/p>\n<ul>\n<li>Puedes revertir cualquier acci\u00f3n en Power Query desde el panel <strong>Pasos aplicados<\/strong>. Selecciona el paso que deseas eliminar y vuelve a intentarlo.<\/li>\n<\/ul>\n<p><strong>2. \u00bfPuedo usar filtros en m\u00faltiples columnas?<\/strong><\/p>\n<ul>\n<li>\u00a1S\u00ed! Power Query te permite aplicar filtros en tantas columnas como desees. Esto es \u00fatil para escenarios complejos con m\u00faltiples criterios.<\/li>\n<\/ul>\n<p><strong>3. \u00bfSe pierden los datos originales al filtrar filas?<\/strong><\/p>\n<ul>\n<li>No. Los datos originales permanecen intactos, ya que Power Query trabaja con una copia de ellos.<\/li>\n<\/ul>\n<p><strong>4. \u00bfQu\u00e9 tipos de filtros puedo aplicar?<\/strong><\/p>\n<ul>\n<li>Puedes usar filtros basados en texto, n\u00fameros, fechas o valores personalizados, como \u00abMayor que\u00bb o \u00abContiene\u00bb.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2>CONCLUSI\u00d3N<\/h2>\n<p><strong>Filtrar filas en Power Query<\/strong> es una habilidad b\u00e1sica pero poderosa para organizar tus datos de manera eficiente. Este proceso no solo te ayuda a eliminar informaci\u00f3n innecesaria, sino que tambi\u00e9n optimiza tus tablas para an\u00e1lisis m\u00e1s precisos y r\u00e1pidos. Sigue estos pasos y transforma tus reportes en herramientas de trabajo efectivas. \u00a1Empieza ahora mismo!<\/p>\n<hr \/>\n<h2>MIRA TAMBI\u00c9N<\/h2>\n<ul>\n<li><a href=\"https:\/\/excelfull.com\/excel\/power-query-en-excel\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY EN EXCEL<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/importar-datos-desde-la-web-con-power-query\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: IMPORTAR DATOS DESDE LA WEB<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/power-query-en-excel-importar-datos\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: IMPORTAR DATOS DESDE UNA TABLA DE EXCEL<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/power-query-para-principiantes-transformar-datos\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 ENCABEZADOS<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/convertir-fechas-con-power-query\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FECHAS<\/a><\/li>\n<li><a href=\"https:\/\/excelfull.com\/excel\/dividir-datos-en-varias-columnas-power-query\/\" target=\"_blank\" rel=\"noopener\">POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 DIVIDIR DATOS EN VARIAS COLUMNAS<\/a><\/li>\n<\/ul>\n<hr \/>\n<p><strong><span style=\"color: #136e42;\">\u00bb <\/span>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\">Facebook<\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\">Instagram<\/a><\/span>.<\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb <\/span>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\">Curso de Excel Online<\/a><\/strong><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Filtrar filas en Power &#8230; <a title=\"POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FILTRAR FILAS\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/\" aria-label=\"Leer m\u00e1s sobre POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FILTRAR FILAS\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":18211,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[328,539,808],"tags":[807,1104],"class_list":["post-18183","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-avanzado","category-power-query","tag-power-query","tag-transformar-datos-con-power-query","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>FILTRAR FILAS INNECESARIAS CON POWER QUERY<\/title>\n<meta name=\"description\" content=\"Aprende a filtrar filas en Power Query y optimiza tus datos en Excel. Sigue este tutorial paso a paso y domina la transformaci\u00f3n de datos.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FILTRAR FILAS INNECESARIAS CON POWER QUERY\" \/>\n<meta property=\"og:description\" content=\"Aprende a filtrar filas en Power Query y optimiza tus datos en Excel. Sigue este tutorial paso a paso y domina la transformaci\u00f3n de datos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-16T09:30:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-27T23:26:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FILTRAR FILAS\",\"datePublished\":\"2025-01-16T09:30:03+00:00\",\"dateModified\":\"2025-01-27T23:26:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/\"},\"wordCount\":828,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png\",\"keywords\":[\"power query\",\"transformar datos con power query\"],\"articleSection\":[\"Excel\",\"Excel Avanzado\",\"Power Query\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/\",\"url\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/\",\"name\":\"FILTRAR FILAS INNECESARIAS CON POWER QUERY\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png\",\"datePublished\":\"2025-01-16T09:30:03+00:00\",\"dateModified\":\"2025-01-27T23:26:23+00:00\",\"description\":\"Aprende a filtrar filas en Power Query y optimiza tus datos en Excel. Sigue este tutorial paso a paso y domina la transformaci\u00f3n de datos.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png\",\"width\":1280,\"height\":720,\"caption\":\"POWER QUERY PARA PRINCIPIANTES TRANSFORMAR DATOS \u2013 FILTRAR FILAS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Avanzado\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/curso-de-excel\/excel-avanzado\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Power Query\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/excel-avanzado\/power-query\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FILTRAR FILAS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FILTRAR FILAS INNECESARIAS CON POWER QUERY","description":"Aprende a filtrar filas en Power Query y optimiza tus datos en Excel. Sigue este tutorial paso a paso y domina la transformaci\u00f3n de datos.","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:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/","og_locale":"es_ES","og_type":"article","og_title":"FILTRAR FILAS INNECESARIAS CON POWER QUERY","og_description":"Aprende a filtrar filas en Power Query y optimiza tus datos en Excel. Sigue este tutorial paso a paso y domina la transformaci\u00f3n de datos.","og_url":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2025-01-16T09:30:03+00:00","article_modified_time":"2025-01-27T23:26:23+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FILTRAR FILAS","datePublished":"2025-01-16T09:30:03+00:00","dateModified":"2025-01-27T23:26:23+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/"},"wordCount":828,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png","keywords":["power query","transformar datos con power query"],"articleSection":["Excel","Excel Avanzado","Power Query"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/","url":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/","name":"FILTRAR FILAS INNECESARIAS CON POWER QUERY","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png","datePublished":"2025-01-16T09:30:03+00:00","dateModified":"2025-01-27T23:26:23+00:00","description":"Aprende a filtrar filas en Power Query y optimiza tus datos en Excel. Sigue este tutorial paso a paso y domina la transformaci\u00f3n de datos.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/01\/POWER-QUERY-PARA-PRINCIPIANTES-TRANSFORMAR-DATOS-\u2013-FILTRAR-FILAS.png","width":1280,"height":720,"caption":"POWER QUERY PARA PRINCIPIANTES TRANSFORMAR DATOS \u2013 FILTRAR FILAS"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/filtrar-filas-con-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"Excel Avanzado","item":"https:\/\/excelfull.com\/excel\/excel\/curso-de-excel\/excel-avanzado\/"},{"@type":"ListItem","position":4,"name":"Power Query","item":"https:\/\/excelfull.com\/excel\/excel\/excel-avanzado\/power-query\/"},{"@type":"ListItem","position":5,"name":"POWER QUERY PARA PRINCIPIANTES: TRANSFORMAR DATOS \u2013 FILTRAR FILAS"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/18183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=18183"}],"version-history":[{"count":5,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/18183\/revisions"}],"predecessor-version":[{"id":18265,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/18183\/revisions\/18265"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/18211"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=18183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=18183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=18183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}