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
looks like there is a problem with the path used to connect to an external source via API