Forum Discussion
Limiting Rows in PowerBI
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.