Forum Discussion
Solved
Append Data
I have this two queries. One contains data from Jan 2023 until June 2023 and the second pulls data from July 1 until now. Both of these are done via API to an external database. When I do refresh bo...
Hey stribor45 ,
you can't because this is how it works. You can consider using incremental refresh, even if API-based data sources are not supporting incremental by default. Start reading everything GilbertQ wrote about incremental refresh: https://www.fourmoo.com/2020/07/01/how-to-configure-incremental-refresh-with-power-query-in-power-bi/
Hopefully, this provides enough to get you started.
Regards,
Tom
TomMartens I tried to follow his example but can't really track what he is doing. The downloaded example doesn't work. What is he doing here in the configuration of the data table? Is that the table that contains the data? If it is why is there only those two dates?