Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am currently trying to integrate data from Marketo into Power BI Desktop, specifically, data from Marketo's Email Activities table. I've seen that it's a common issue that people run into API call limits enforced by Marketo, but not seen a good way to circumvent this.
I only need data aggregated at the Campaign (primaryAttributeValue column) level I believe, and was wondering if anyone has, or knows if it is possible, to aggregate data at the campaign level within Marketo prior to bringing it to Power BI through the connector. This seems like it would be a good way to prevent hitting the API call limit, but I haven't been able to figure out how to manipulate the query in the advanced editor to do this.
Barring that, does anyone else have ideas or solutions? I am hesitant to build out a large historical table piecemeal and keep it incrementally updated.
You could try to call the API multiple times by invoking a custom function for pagination.
https://msdn.microsoft.com/en-us/library/mt185361.aspx
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |