Answered

Blank rows are there after combining 2 data files in Power BI data Table

(0) Share

Report

Posted on by AJ_vizMan

Hi, there are 2 files e.g. File 1_Resolved tickets and File 2_Unresolved tickets. Both contain similar data. Files are combined using Power query editor and it combined correctly. But, when i see combined data table then there are 2 issues :

1. Column headers are repeated and coming as new row

2. There are multiple blank cells in the data table.

M Code is attached as available in advanced editor.

Could you please help me to figure out the reason of above 2 issues and how to overcome it?

#Power BI #Power Query

Categories:

Power Query

All responses (3)

Answers (1)

Sort by

AJ_vizMan on at

Like
a
(0)

Report
Copy link

Link copied!

@Syndicate_Admin - Thanks for your response. M - code is attached now.
Verified answer

AJ_vizMan on at

Like
a
(0)

Report
Copy link

Link copied!

@Syndicate_Admin - Thank you for your response.
In share Point hosted Excel files, i deleted the blank rows and that's it. No blanks in Power Query imported data.
Than you so much for quick easy fix.
Faith12 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Your method worked. I applied the following at "Transform Sample File" after the last applied steps: = Table.SelectRows(#"Promoted Headers", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))