For those that use Power BI for reporting, where are you sending your data from Marketo? | Community
Skip to main content
Ross_Smith
Ross_Smith
New Participant
May 27, 2021
Question

For those that use Power BI for reporting, where are you sending your data from Marketo?

  • May 27, 2021
  • 1 reply
  • 2809 views

Hey everyone!

 

We're starting to leverage Power BI for our email analytics reporting. As of right now we're taking that data in monthly data exports and consolidating into 1 large CSV, which we use for Power BI.  There has to be a better way to get the data Marketo/Revenue Explorer over to Power BI. 

 

How are you all getting your data out of Marketo and where are you storing it to connect with your Power BI or any other BI tool?

 

Open to any and all suggestions!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    P
    PhillipWi1
    New Participant
    May 28, 2021

    Hi Ross,

     

    It seems like there used to be a Power BI connector but it doesn't seem like it was much good, so it was deprecated.

     

    The best way is by using the Marketo REST API to extract activities in bulk. You can then throw it into Azure (if you use it) or another data warehouse such as Redshift before importing it into Power BI for analysis. This will require development work but is really the best way to do it since there are considerations around throttling, the activities you want to import, etc etc.

     

    Sorry, not a simple solution but that's the way long term.

      Ross_Smith
      Ross_SmithAuthor
      New Participant
      June 2, 2021

      Thank you, Phillip!

      Terms & ConditionsAccessibility statement

      Loading footer...