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

I have the same question (0)

All responses (3)

Answers (1)

AJ_vizMan on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

AJ_vizMan on at

Like (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.

Was this reply helpful? Yes No
Faith12 16 on at

Like (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})))

Was this reply helpful? Yes No