Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Marketo DIY API

Hello PBI Community,


I have a marketo instance with about 450k contacts with data I am trying to pull in to my power bi model.


The problem is we do not want to pay for the expensive Marketo Bulk Extract connector however we have too much data to utilize the PBI Desktop Connector.


I have found this article and am wondering if anyone has tried to build this out using the PBI Service Dataflows or PBI Desktop and writing out the JSON:



Any help would be greatly appreciated.


Thank you.

Solution Specialist
Solution Specialist

@seanrm42 I never used Marketo but using API is more or less straightforward. 

If you can generate a long-living token in Marketo (as the article says) then you will be just fine doing everything from the PBI Desktop and using Web.Content as a connector.


If there would be a need for some login logic (OAuth) then you'd have to create a custom connector that can handle the login functionality.


I created a couple of custom connectors already and it's really not that difficult.

Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors