Forum Discussion
Limiting Rows in PowerBI
Are entire rows blank, or just certain fields? The Excel connections work much better if you insert a table in Excel around the data from the insert menu. Then when you connect to the file in Power BI, you check the box next to the table name you want to import, and it will only pull the content of the table, not the whole sheet. This is assuming its picking up blank rows above or below your table right now, though.
christinepayton thank you for the advice! If I was to do this and insert a table in the excel file around the already existing data, would I need to redo my Power BI connection and any relationships thereafter?
It'd change your query a bit, but you can use the same query table so that you don't have to redo things. What I usually do is create a separate query with the "new" technique, then go to the advanced editor and copy/paste the connection chunk from the top few rows and replace the connection chunk in the original query. When you do that, you have to update whatever the next step is below the connection to reference the last step name that you pasted in, because it will be slightly different. You can make a copy of the file beforehand or discard the query changes if something gets screwed up.