Forum Discussion

monikapatil2612's avatar
monikapatil2612
Regular Visitor
9 months ago
Solved

Incremental refresh

Hi friends, I am using python script in power bi to connect Odoo server to get data.I used XML RPC.It hits it's API limit and failed to get refreshed.it has large size of data.How to set incremental ...
Need Help
  • anilelmastasi's avatar
    anilelmastasi
    9 months ago

    Hello my_patil ,

     

    If you company use Microsoft products, you can use Azure SQL Database. 

    And for python script you can use Azure Functions. It runs on a schedule and it is serverless (no virtual machine to manage).

     

    After writing to Azure SQL Database, you can apply incremental refresh policies.

    In Azure SQL DB, create table and add updated_at and write_date columns.

    In python script, you can use xmlrpc.client library.

     

    Hope it gives you an idea.

     

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
9 months ago

Thankyou, anilelmastasi, rodrigosan and lbendlin  for your responses.

Hi monikapatil2612,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by anilelmastasi, rodrigosan and lbendlin  to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.