Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Stilish
Frequent Visitor

Loading Excel VBA array output to Power BI

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

1 REPLY 1
JohnThomas
Helper II
Helper II

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors