Using Power BI to connect Marketo data - Start Date? | Community
Skip to main content
Danielle_Wong
Danielle_Wong
Community Manager
July 31, 2020
Question

Using Power BI to connect Marketo data - Start Date?

  • July 31, 2020
  • 2 replies
  • 6551 views

I am exploring using Power BI to create Marketo dashboards. I've gotten to the step where I have to enter Marketo REST API endpoint and a Start Date. Does anyone know what the Start Date means?

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

2 replies

A
ajaymamgain1
New Participant
August 1, 2020

It will be better to extract the data in SQL Database using bulk export or Rest APIs and then create a direct query to create the PowerBI report and dashboard.

 

Initially, I used Power M Query to fetch the data using Rest API instead of PowerBI Connector (which is not good and will make too many rest API calls)  another reason was that because I wanted to have more control over the data. However, if you have the option go for SQL Server and Rest APIs approach. 

    SanfordWhiteman
    SanfordWhiteman
    New Participant
    July 31, 2020

    The date from which you want to start extracting activities.

     

    Be very, very careful with this connector. Don't start from more than a few days back as you gauge its load on your Marketo instance. Extracting your data in bulk is infinitely safer.

    Terms & ConditionsAccessibility statement

    Loading footer...