cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Memorable Member
Memorable Member

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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

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