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.
