Forum Discussion
Marketo Content Pack not working
Tried recreating the user and granted additional rights...now I can't even get past the authentication:
So appears the problem is that attempting to bring in 1 month of data exceeds the allowed API call limit for the day (10k per http://developers.marketo.com/documentation/rest/). I have been successful at returning the schema of things, but in every case even if it's the only query I've made after the API call reset, it eventually comes back and says failed to load:
Given that I've selected the least amount of time that I can and it fails to load, I'd call this an exceedingly broken solution. Two major thumbs down on this one.
I would be interested to know if anyone else has been able to get this to work with the default 10k limit and 1 month of data...
Using the content pack and 1 month of data, I was pulling 4300-4500 API calls. When I attempted to do 3 months this morning, I easily blew through the 10K limit. Please advise
Hey Mark I'm curious have you ever succeeded in connecting Marketo and Power BI? I'm failiing the initial authentication and can't get past it. annoyed as heck.
thanks, Idan.
Hey Mark I'm curious if you've been successful eventually in connecting Marketo to Power BI. I can't even get past basic authentication. Annoying. Thanks!
idanca, have you set up a user with full API permissions and the associated web service? Those are the hurdles needed to get through the authentication step.
On my side, I'm able to connect to our Marketo sandbox and pull data into Power BI but the connection fails on our production.
The only variable I can see is the slight permissions difference in the API user's role between the two environments. The sandbox API user has full API rights but the production API user doesn't have Approve Assets or Execute Campaign rights. Are those required for the data connection to work?
