Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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,
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?