Hi,
I'm looking for a way to load more recent data as date x in Power Pivot and link/add them to an existing table.
Background:
The user downloads data from a datafeed and saves them in Excel Power Pivot. The data will be deleted from the server afterwards. In the next step, new data must be added to the existing table in Power Pivot, so that the workbook graphics can access the complete dataset.
I know there's no API for VBA access to power pivot, but possibly there's a workaround with linked tables and direct access to the database?
Would be glad if someone can help me!
Greetings Patrick