Incoming API with paginated data needed to be merged into Power BI report one table - Please advise

Hello, I am new to Power BI and would like to ask for advice, please.   I have an API that sending a data from the Service Now. The Service Now table has a heavy data (a few Gbs) so the pagination...