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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
seanrm42
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:

 

        http://marketo.topowerbi.com/

 

Any help would be greatly appreciated.

 

Thank you.

1 REPLY 1
JirkaZ
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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors