Empty row displayed in a table

[Zakaria_1980]

Hello,

i've uploaded a DB from Excel in power Bi (see below screenshot)

when i report this table in the report, i get the following with the first row Empty. how can I remove that Empty row please ?

Br,

[Pragati11 · Accepted solution]

Hi @Zakaria_1980 ,

It clearly shows there are some empty rows imported in Power BI through excel.

What you can do is, in Edit Query, you can filter these blank rows by applying a filter on one of the columns like COUNTRY.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[amitchandak · Accepted solution]

@Zakaria_1980 , Open Edit Query/ Data Transformation. There you have the option to remove blank rows.

Step can found on this page

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-data

[Pragati11 · Accepted solution]

Hi @Zakaria_1980 ,

It clearly shows there are some empty rows imported in Power BI through excel.

What you can do is, in Edit Query, you can filter these blank rows by applying a filter on one of the columns like COUNTRY.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati