You should be able to extract the cube data to Excel, and use the Excel file as source for your table. An SSIS package can be developed to import the data.
That being said, you're just putting a band-aid on the real problem of not storing your historical data in the first place.
Hi, Excel goes to 1 million records, I'm around 1.5+B rows. Thanks
Well now that would've been great information to have at the start, but in any event you can surely limit the data to fit into an Excel workbook...or us multiple workbooks etc.
I think an approach I've not tried before, would be OPENQUERY linked to the SSAS Tab instance, and try to extract that large volume that way, then find a way to build deltas say monthly from that processes. I'll have to ping back in to mention if this was a feasible solution.