zoho

[fabis]

any one knows power bi and zoho books integration

[EugeneLebedev]

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 BI

[Kerry_O]

Did you get assistance with this Fabis?  I am about to try and same thing ...

[v-jingzhang]

Hi @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.

[fabis]

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