Remove rows with blank fields on import

[PowerBINoob24]

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?

[Mikelytics · Accepted solution]

HI @PowerBINoob24 

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.

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

LinkedIn