Custom Connector merging data

[rcyber]

Hi guys!

What I want to do is getting a data part by part (using date range).

A data source has crazy lot of rows (about 1 billion) so I can't get the ALL data every time when I click the Refresh button in Power BI desktop. Moreover, the most of data is historical data and I need to refresh a few last days only.

I have created my own custom connector and it works well. Is there way to add new rows into existing pbix file?

My main issue is I don't understand how I can get an access to existing table from connector code.

I'll be appreciated for any help.

Alex.