Forum Discussion
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?
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.
-----------------------------------------------------
1 Reply
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.
-----------------------------------------------------