Zoho CRM API and Power Query

[Anonymous]

Hi People,

Have somebody ever connected to ZOHO CRM api trhough Power Query? 

Best Regards

Daniel

[Syndicate_Admin]

With Zoho Projects, I've created a similar (with Zoho Reports). There are API end points for obtaining specific tables in CSV, JSON, etc., through Zoho Reports' API end points Using a Node.js API, they can be loaded into a SQL Azure (runs on a daily croon job which manages refresh).

Connecting to PowerBI - the desktop and web versions - is easy once you've set up Azure SQL.

Because Zoho Reports is integrated with Zoho CRM and other products, it should work similarly.

This is a huge improvement over using IFTTT, which used to call the same Zoho Reports endpoints and store them in a OneDrive for Business folder that could be accessed through PowerBI.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Based on my research, we can use costom connector to work on it. Please refer to the third - party case here.

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=cc917da8-ad43-4f37-b584-4d96cc13210c&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

BTW, There is an idea about that you can vote it up to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7023583-zoho-crm