Forum Discussion

erikskov's avatar
erikskov
Advocate II
10 years ago

Marketo Content Pack not working

I can get as far as 'please wait while the data loads' but ultimately it comes back saying 'failed to load'.  
Need Help
markcudiamat's avatar
markcudiamat
Regular Visitor
10 years ago

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

idanca's avatar
idanca
New Member
9 years ago

 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!

  • mbaltrusaitis's avatar
    mbaltrusaitis
    New Member
    9 years ago

    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?

     

    • OliviaHoltz's avatar
      OliviaHoltz
      New Member
      8 years ago

      I am also having issues connecting marketo and when I select email activites in the navigator the below fields appear. I am interested in 'devices, categories, bounced count and percentage, clicked count and percentage, opened count and percentage' to be useful in reporting. 

       


       
       
      Year Quarter Month Day Activity time activityTypeId leadId mktoId primaryAttributeValue primaryAttributeValueId
      2017 Qtr 3 July 31   2003 2003 2003 Newsletter 2003


      EmailActivities Data about email sent to leads/contacts, with details about devices, categories, bounced count and percentage, clicked count and percentage, opened count and percentage, and program name. The Email Activities as shown in Power BI is an absolute email deliverability report, it does not apply any additional logic to the data. You might see some different results between the Marketo client and Power BI because of this.

       

       

      Is there another way to connect this to get all the fields and values to appear.

       

      Thanks, Olivia