Work with Power BI, Zoho Desk and Excel

[Anonymous]

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.

[Anonymous]

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.

[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 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 ;

 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

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37752679-integrate-power-bi-to-zo...

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

https://community.powerbi.com/t5/Desktop/Can-I-use-the-Zoho-creator-connector-that-Microsoft-provide-to/td-p/2040422

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.

[amitchandak]

@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

[Anonymous]

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?