question

EugeneCloud-5893 avatar image
0 Votes"
EugeneCloud-5893 asked Ehren answered

Is Speedup by replacing queries with custom functions expected?

What does the Power Query team recommend regarding queries vs. custom functions?

Obtaining a result from a ten-query version of an algorithm produced a result in ~ 15 minutes. The custom function version consists of five of the original ten queries with the other five being converted to functions. An eleventh query, serving as the main query, is this statement:

 Source = List.Accumulate({0,2,3,4,6,7,8,9,10},Table.FromList({}),(start,current) => Table.Combine({start, fnPairExpMetrics2(current) }))

The custom function version produces nine results in an elapsed time of 4:14 minutes. (Measured by observing Query Refresh Status)

Is this speed up expected? @ImkeFeldmann-9931

power-query-not-supported
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

Hi there. Power Query is no longer supported here on Q&A. In the future, please post your question over on https://aka.ms/PQCommunity instead.

With the ten query version, were you running with data privacy enabled? If so, do you see a perf difference with data privacy disabled?

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.