Forum Discussion
Import method
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
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
2 Replies
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
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
