Has anyone had any success getting their Marketo data into Power BI using this out of the box integration? We went through all the steps documented in this Microsoft article, but we keep receiving Marketo notifications for web services errors. It's the same error each time. Error code 606: Max rate limit ‘%s’ exceeded with in ‘%s’ secs. The number of calls in the past 20 seconds was greater than 100. We selected the minimum amount of data -- it asks how many months to load, and we selected "1" -- and for fives days running it made anywhere from 23,000 to 43,000 API calls each day... but that never resulted in a working dashboard. If we keep letting it grind along, will we eventually get reports? Or should we give up on this and build something on our own? (Or is there a way to modify it to avoid those errors and eventually get the data we need?)

A quick, temporarily workaround that worked for me: In the "All People" System Smart List set a customized a view including columns you are interested in.Set a daily subscription for the table to be sent to an email.In Outlook, create a rule that downloads the .csv file and saves it to a Sharepoint file.Connect PowerBi to that Sharepoint file. This way I can export any column without restriction while I learn to deal with the API. I can also do it for any subset of the Database (smart lists). The VBA script is very simple, works on demand too.Works ok so far. 30 min set up.