Using Power BI to connect Marketo data - Start Date?

Danielle_Wong
Level 8 - Community Advisor

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?

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: Using Power BI to connect Marketo data - Start Date?

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.

Ajay_Mamgain2
Level 3

Re: Using Power BI to connect Marketo data - Start Date?

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.