CODEWITHSUNDEEP
filternullpowerbipowerquery
Elvino Michel
Elvino Michel

Reputation: 447

Why is Power BI creating null values? How can I prevent Power BI to add null values below my data?

I have an excel file which I regularly update in Power BI.

I added an additional line, which did not cause any issues to my operations, however, Power BI also added three "null" lines afterwards.

I do not understand why.

I thus created a table, because I thought that I would prevent this.

But I still have "null" rows appended to my lines.

The only remedy that I found is to filter rows on a column (Lapin) which as no null (and which should never in future), in the following way:

 #"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Lapin] = "Snip"))
in
    #"Filtered Rows"

This is a really bad solution however, and I wish to address the root issue.

Upvotes: 0

Views: 2883

Answers (1)

Jon
Jon

Reputation: 4967

On importing from Excel, you can get dummy rows that are due to formatting, hidden formulas, rows that are holding over something in the cell reference in the background. Its not just Power BI, this happens on importing into SQL Server tables, Pandas, and on exporting the Excel to csv etc. The best option is to us the remove rows function in the Power Query

enter image description here

Select Remove Rows > Remove Blank Rows

Upvotes: 2

Related Questions