
  • BI Pixie Blog
  • DataChant Forums
  • Book (2nd Edition)
    • Book Forum
    • Excerpts & Extras
  • About
    • Who we are
    • Terms of service
    • Privacy Policy
  • Power BI Apps on AppSource
    • Compare data in Excel
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Custom Visuals Exploration Tool
    • Power BI Apps on AppSource – Exploration Tool
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Twitter Dashboard
    • Power BI Apps – Support Page
Automatically remove empty columns and rows from a table in Power BI

Automatically remove empty columns and rows from a table in Power BI

by Maya Raviv | Oct 11, 2021 | Uncategorized

Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns from tables is a very common challenge of data-cleaning. The tutorial in mention, which happens to be one of...
Automatically remove empty columns and rows from a table in Excel using Power Query

Automatically remove empty columns and rows from a table in Excel using Power Query

by Gil Raviv | Dec 9, 2016 | Uncategorized

Follow @gilra In today’s tutorial, we will solve a very common challenge in Excel. You start with an Excel table and you wish to condense it by removing all the columns and/or rows that are entirely empty, and usually, you don’t have prior knowledge of...

Write a Review

A cover picture of the book "Collect, Combine, and Transform Data Using Power Query in Power BI and Excel, 2nd Edition"
A cover picture of the book "Collect, Combine, and Transform Data Using Power Query in Power BI and Excel, 2nd Edition"

Learn about BI Pixie, our flagship product

A screenshot of BI Pixie, a groundbreaking solution built to optimize Power BI adoption and trust. It delivers deep insights into user behavior, performance issues, and security risks—empowering teams to boost engagement, prevent data leakage, and maximize BI impact and ROI.

Tags

#MSDataSummit AppSource Bad Practices Bonus Exercise Book COVID-19 Custom Visuals dataflows Data Quality Automation DAX Excel Excel 2016 Facebook Facebook bug Facebook Insights Facebook Reactions Get & Transform Jedi List.Accumulate List.Generate Logs MailChimp Microsoft Cognitive Services Multiline records MVP Pitfalls PivotTable Power BI Power BI Governance Power Pivot Power Query Power Query Book Robust Queries Sentiment Analysis Star Wars Subscribers Tableau vs Power BI Template Apps Text Analytics Twitter Analytics Unpivot Update US Election Candidates US Presidential Candidates Webinar Web Scraping

  • !
    Home
  • !
    Power BI Apps
  • !
    Book
  • !
    About

Copyright 2024 DataChant Consulting LLC All Rights Reserved

 

Loading Comments...