Currently the Odbc.Query function is triggering 2-4 identical queries against the source DB engine instead of just one.
This is happening even after disabling all functionalities and lowering the settings to minimum in PowerBI Desktop app as noted in the multiple query guide.
The only solution is to put Odbc.Query function inside the Table.Buffer function and then only one query is triggered.
It is not clear to me the reasoning for Odbc.Query to trigger multiple identical queries if Table.Buffer is able to load the data by only triggering one query.
And therefore, I suggest that for this improvement to be done to Odbc.Query function to trigger only one query.
The reasoning is that each query triggered (processed) by the source DB engine comes with a cost. By lowering the number of queries executed at the source DB we are lowering the cost too.
2 Comments
Link to the multiple query guide: https://learn.microsoft.com/en-us/power-query/multiple-queries
- Status added:New
