Improve Function Manually Add Data In Tables

So I have a PowerBI report where I use 1 SQL server source (ticketsales) and I would like to use 1 OneDrive source with an excelsheet (sales forecast), but this gives problems in the OnPremise Gate way refreshes, or at least is very cumbersome to make this work. SO because the Excel file is static I want to import and update this base table in PBI. BUT editing data in manually entered tables is not intuitive or lacking in functionality.

1.) You have to navigate to > Query Editor > Source where you can edit or add data. This is not intuitive. A button Add data or something like that would work better. Or the button Enter Data should give the option to add data to the current manually entered table.
2.) You can only paste in a couple of rows at the bottom not like 1000 from Excel.
3.) You will have to scroll the bottom of the table to do this, while a function to do this would work better

On a sidenote I would not have this problem if it was easy and intuitive to connect both SQL server and OneDrive source in an on Premise gateway. But still sometimes you just want to add some static basetables which should have a better function to update them.