Skip to main content
Danielle_Wong
Community Advisor
Danielle_WongCommunity Advisor
Community Advisor
Jul 31, 2020 8:51 PM UTC
Question

Using Power BI to connect Marketo data - Start Date?

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

SanfordWhiteman
User Group Leader
SanfordWhitemanUser Group Leader
User Group Leader
Jul 31, 2020 10:12 PM UTC

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.

Translate
ajaymamgain1
Level 3
Aug 1, 2020 12:03 PM UTC

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. 

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...