Forum Discussion

Resolver I

3 years ago

Solved

Remove rows with blank fields on import

Is it possible to have Power BI filter out any rows that have empty fields during import from an .xlsx file, or would I need to do that manually?

Resident Rockstar

3 years ago

When you load the data into POwr BI Desktop with Power Query you can set a filter on each column.

So you can filter out blanks and as soon as you did the setting it will be filtered out withh each refresh.

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------