Forum Discussion

fabis's avatar
fabis
Frequent Visitor
4 years ago

zoho

any one knows power bi and zoho books integration
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

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's avatar
    fabis
    Frequent Visitor
    4 years ago

    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