Forum Discussion
zoho
any one knows power bi and zoho books integration
4 Replies
There is no native connector but you can get a custom connector off-the-shelf here: https://vidi-corp.com/zoho-books-connector-to-power-bi-tableau-looker-studio/
This would get you the code pulls data automatically into Power BIHi fabis
Currently Power BI only has a built-in Zoho Creator connector. I'm not sure if this can connect to Zoho books. As Zoho books has APIs for connection, you can try querying data through its APIs: https://www.zoho.com/books/api/v3/introduction/#overview. You can use Power BI Web connector to connect to APIs or use Power Query M code with Web.Contents() function for connection.
Additionally, there are some third-party integation solutions, you may google and find them.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.yes now i integrate power bi with zoho books via cdata odbc connector api all fine, but i faced many problem with calculating total sales from zoho books invoice table. i cant open a table name "invoiceDetails" without passing invoice id, i need both invoice and invoiceDetails for calculating total sales. so any one face this same issue when calculating total sales. so please reply
Did you get assistance with this Fabis? I am about to try and same thing ...
