Hello,
I am using a web api connection and it has 'StartDate" and "EndDate" in its string. At every scheduled daily refresh, I need to fetch only one day data and store it in the report with existing data, so my query cost is always one day data at the max.
I have tried couple of ways, one with parameters wherein I stored StartDate and EndDate and used both in web api. Upon fetching the data, I append the data to master table. But this is the same table from I fetched max date of the record to use in web api.
So as one may realize this is circular reference. I get the max date from a record table, use to fetch data from external source and append in the same table again.
This gives me following error: An error occurred in the ‘Goa-Daily’ query. Expression.Error: A cyclic reference was encountered during evaluation.
To avoid, I did few things, like using all transformation in single query, ignore privacy settings etc. but nothing helps. I think I need to somehow isolate current state of reference table and then upon scedhule refresh (or ordinary refresh) add the data to it and stop. But I could not find how to achieve that?
Thanks.
