The operation is timed out - DataFlow with OData sources

[I365SvcUsr]

Hi to everyone.

I'm introducing a new query in my dataflow with 743799 rows and 3 columns.

I want traspose this table using "Pivot column" function in Power Query. The final result must be like this:

PS: I obtained the result of this image using only 1000 rows and not 743799.

In the Editor I wrote the following steps:

but the last step does not give a result and after 10 minutes the following message comes out:

"The operation is timed out".

I also modified the Source like this: Origine = OData.Feed(#"§BusinessCentral_ODataFeed", null, [Timeout = #duration(0,1,0,0)]) but nothing has changed.

What can I do to increase the timeout? 

[aj1973]

Hi @I365SvcUsr 

I don't think you can achieve the Transpose query even if you increase the time out. The limit number of columns in Power Query is 16384.

https://support.microsoft.com/en-us/office/power-query-specifications-and-limits-5fb2807c-1b16-4257-...

[I365SvcUsr]

Hi @aj1973

Thank you for your answer, but at first I have only 22 different values ​​in the column "Cod_caratteristica", so I would like to get 22 columns in the final result (and not more than 16384).

The last step #"Colonna trasformata tramite Pivot" uses the List.Distinct function to have this result.

I think the problem is the timeout: it's 10 minutes but the last step must have more time to finish the job. Do you know how can I increase it?