Blank row with data in columns

[Pranab_C]

In my dataset I have a few blank rows in the beginning but they have data in a few columns, the output results in creation of blanks when I am doing the PowerBI dashboard from this dataset, how to fix this?

[JagdeeshN]

@Pranab_C  If certain columns have values in a row, it would not necessarily be considered a 'blank row'.

If you dont want that in your output to PowerBI, i would suggest filtering those rows out using a filter condition looking for nulls in specific columns/combination of columns.

[Pranab_C]

Thanks Jagdeesh-You mean using a PowerQuery in PowerBI?