Connecting to Active Campaign accounts API data..

[rob_tucker_168]

Hi, 

I am trying to use Power Bi to connect our Active Campaigns Account data via Web/ API connection

I have tried to to connect to the web api link supplied by our AC account and use the login credentials but this doesn't work. I have tried to add the API key but this fails with an error that required API name to be specified.

Is this connection possible? 

[EugeneLebedev]

Hi there, you can use third-party connector for this integration. I used one provided by Vidi: https://vidi-corp.com/activecampaign-power-bi-connector/

This one helped me a lot! 

[Anonymous]

You can connect ActiveCampaign and Power Bi via Skyvia — the no-coding integration solution. This integration isn't performed directly — Skyvia provides it through a database or cloud data warehouse with automatic schema creation. Then you can connect Power BI to this database or data warehouse easily.

[V-lianl-msft · Accepted solution]

As far as I know, there is no built-in connector, please try custom connector or third-party connector.

https://docs.microsoft.com/en-us/power-query/startingtodevelopcustomconnectors 

https://developers.activecampaign.com/reference#overview