The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
45 |