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?
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.
RegardsAmine JerbiIf I answered your question, please mark this thread as acceptedand you can follow me onMy Website, LinkedIn and Facebook
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?
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.