cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
I365SvcUsr
Frequent Visitor

The operation is timed out - DataFlow with OData sources

Hi to everyone.

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

 

FORUM.png

 

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

 

FORUM1.png

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

 

In the Editor I wrote the following steps:

FORUM2.png

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? 

2 REPLIES 2
aj1973
Resident Rockstar
Resident Rockstar

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-...

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!

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?

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors