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?
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.
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.