Using Power BI to connect Marketo data - Start Date?

[Danielle_Wong]

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?

[SanfordWhiteman]

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]

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.