Might be worth taking a look at Bedrock data here in Boston. We're friendly with them and they recently launched a product that allows you to feed data out of Marketo into an automated cloud data warehouse that you can use as a data source for PowerBI (or whatever). It gives you tables you can point to directly from your PowerBI. It gets around the API uses by pre-loading the warehouse, and then bringing updates from there rather than continuously trying to pull data and hitting limits. https://www.bedrockdata.com/fusion/marketo-data-warehouse
... View more