Loading Excel VBA array output to Power BI

[Stilish]

I have a VBA array script that runs through a series of complex calculations.

The output rows can exceed the excel row limit so I need to load the results to a data model in order to run power pivots.

But it doesn’t seem like I can load the array directly.

So I was thinking of breaking the output up, passing a portion to an excel table and then loading to the data model and then deleting the excel table in order to accommodate the next portion of the array output which will then be appended to the data model, and so on and so on until I have all the output rows in the data model.

Can someone clarify how I can do this or provide me with a better solution? @Greg_Deckler and @edhans?

Thanks

[JohnThomas]

Some sample data and a specific 'desired output' would help.