Import method

[haseeb]

Hi,

   I am trying to import data from following sources :-

1. LinkedIn (company page)

2. Facebook (company page)

3. Wordpress

4. Zoho Creator

5. Mail Chimp

Is API (web option under get data) the best way to go?  Any performance issues? 

Thanks

H

[amitchandak · Accepted solution]

@haseeb , you can use rest API

https://community.powerbi.com/t5/Power-Query/Get-data-from-web-api/td-p/70273

https://www.progress.com/tutorials/odbc/directquery-your-custom-rest-api-in-power-bi

For some of these connector are available

https://www.zoho.com/creator/newhelp/setup/zoho-creator-connector-for-microsoftpowerbi.html

https://datachant.com/2016/05/20/analyze-linkedin-company-page-with-excel-and-power-bi/

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-tutorial-facebook-analytics

[Greg_Deckler]

@haseeb - If you can use a built-in connector for the specific platform that is best. There is a LinkedIn Sales Navigator connector in preview as well as a Zoho Creator (Preview). Otherwise you will have to go with whatever the platform offers, REST API, OData, etc. CData has a ton of connectors