Forum Discussion
Work with Power BI, Zoho Desk and Excel
Hello,
I want to get from Zoho desk all my tickets and data, From what i found in the network, the only way to do it is with their API,
Zoho Desk API limits each request to 100 elements, So my idea is to run python script that wil fetch each time 100 elemnts from Zoho desk and will move to the next 100.
Then i want to upload it to Power BI, I tought on load the data to excel file and loat it to the BI after all the requests.
Is there a way to update from POWER BI this excel file ? or mayb to active in some way the python script in every click on 'refresh'?
Or maybe a different way to integrate Power BI with Zoho desk?
Thank you.
5 Replies
- amitchandak
Super User
Anonymous , You can use DAX append.
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/My suggestion would first get the data into some DB and combine it there and read it.
Or check pagination of API
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
Thanks amitchandak ,
In Zoho Desk API, i need to generate every X time new token to be able to fetch data so i think i will need to add my script to the BI, is it possible?
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
I doubt you could use thrid part connector; Unless there is Webservice from which you can take required data .
https://www.zoho.com/developer/rest-api.html
There is an idea for that
Vote for it
No direct connector : https://help.zoho.com/portal/en/community/topic/integrate-with-power-bi
Third part : https://tray.io/connectors/microsoftpowerbi-zoho-crm-integrations
https://www.zoho.com/creator/newhelp/workflows/formworkflows/understand-zoho-desk-integration.html
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- v-yalanwu-msft
Hi, Anonymous ;
Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can integrate Zoho Desk and Power Bi via Skyvia — the no-coding integration solution. This integration isn't performed directly — Skyvia provides it through a database or cloud data warehouse with automatic schema creation. Then you can connect Power BI to this database or data warehouse easily.
