Forum Discussion
Power Query API Connection
Hi,
I have a data source connected via API. The problem is it does not keep the data anywhere. Would it be possible that previous day data remains in Power BI and when ETL scheduler runs the next day, it fetches the new data and at the same time keeps the old data.
I am thinking of creating a reference of it in power query mode, will it work?
1 Reply
You can do this with incremental refresh where you pass RangeStart and RangeEnd into your API call filters.
Pat
