Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I'm trying to understand how is the "reference table" works.
Having 2 queries A, B, where B is a reference to A, and A is a query to my data source.
When refreshing A and B, I expect only 1 call to my data source (from A), but I see 3 calls.
2 calls are running in parallel at the same time and when finished I see the 3rd call being executed for the same query.
Can someone elaborate on that process?
Will it be more efficient if I wouln't "reference" to A but "duplicate"?
Thanks
@nadian I am not entirely 100% on how query calls are made but i would assume that if you have two queries A and B, where B is reference of A then during refresh only one call is made as B is reference of A and is going to be updated once A is updated. On other hand duplicate B of A means they both refernce data source seperately and so two calls will be made.
Perhaps MS insider like @SamLester can confirm this for us on how query calls are made for reference and duplicates.