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

Using Power BI to connect Marketo data - Start Date?

  • July 31, 2020
  • 2 replies
  • 6581 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

SanfordWhiteman
SanfordWhiteman
Level 10
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.

A
ajaymamgain1
Level 3
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. 

    Terms & ConditionsAccessibility statement

    Loading footer...