Hello Sebastian,
Welcome to the QS community. I am not sure how you chart of accounts are set but i guess you may refer to below blog which might be helpful using quicksight paginated report API’s.
hope this helps.
Cheers, Deep