Forum Discussion

tomas12344's avatar
tomas12344
Icon for Helper III rankHelper III
4 years ago

Performance of referenced table

HI All In power query i have created a query to SAP (SAP connector) = QUERY_A. This load is quite big. In PBI DAX i'm loading from this QUERY_A some data, which i want to move to M query, becuase i ...
Need Help
Tips and Tricks
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

You need to create a reference query not duplicate query. For reference query, only original query will be loaded. Hence, it will be

[SAP->QUERY_A->QUERY_B]

But if you create a duplicate query, then it would be

[SAP->QUERY_A and SAP->QUERY_B]

tomas12344's avatar
tomas12344
Icon for Helper III rankHelper III
4 years ago

Thank you For the answer. Have you the same experience when using SAP BW and SAP Connector. 
I have done some test during the weekend, where the setup of the queries was like [SAP->QUERY_A->QUERY_B, QUERY_A->Query_C,....] (used reference for the other queries B, C,...). When processed only with query_a, refresh was 1hour, when with the other queries refresh was 8hours.