Forum Discussion

clteh9's avatar
clteh9
Icon for Helper I rankHelper I
3 years ago

Periodically refresh dataset and append data into dataset

I retrieve the data via ODBC connection and the datasource only store 30 days data.
I would like to keep 1 year data in power bi dataset.
May i know is there any way it can be done and  how can i automate the date retrieval and data housekeeping periodically. thanks
I am using power BI Desktop app.

Need Help

2 Replies

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi clteh9 ,
    Try to use incremental refresh to refresh your data set . It stores historical data as well as apend lastest data by time to time.

    For your refrence of ODBC connection try to use below concept.
    https://www.youtube.com/watch?v=x7q1DHf8wE4 

    Please accept this as solution if my reply helps you. 
    Atleast dont forget to give kudos.
    Thanks,



    • clteh9's avatar
      clteh9
      Icon for Helper I rankHelper I
      3 years ago

      seems like it is only supported for Power BI Premium. I am not using Power BI Premium and Pro Version. Is there any way it can be done with Free Version?