Limiting Rows in PowerBI

Hi PBandI ,

Thanks for the reply from NaveenGandhi / christinepayton .

Regarding your question about dynamically setting the import to only include rows that contain data, I don't see any functionality in Power BI that automatically adjusts the row limit based on the presence of data.

There are a few ways I can ensure that only necessary rows are imported:

1. Open the Power Query Editor.

Select the first column, then hold down the Shift key while selecting the last column. This should select all columns.

Go to the Home tab and click Remove Rows -> Remove Blank Rows.

2. Sometimes, cells may appear to be empty but contain invisible characters.

Use the Trim function in Power Query to remove any leading or trailing spaces that may cause Power BI to treat the row as containing data.

Feel free to contact me if you have any further questions.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!