cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Dataflow Timeout

Hi all,

 

Anyone know a way to stop the dataflow timing out.

 

Datasource is on-prem SQL database, using a native query. Result set is in the millions

 

Thanks

 

Mike

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: Dataflow Timeout

Hi Mike,

 

Please send to our support email the screenshot with the failure you got, so we can investigate further.

 

Thanks,

Galia

View solution in original post

15 REPLIES 15
Highlighted
Community Support
Community Support

Re: Dataflow Timeout

@Anonymous,

 

Please refer to below:

 

There are a few known limitations to using Enterprise Gateways and dataflows:

  • Each dataflow may use only one gateway. As such, all queries should be configured using the same gateway.
  • Changing the gateway impact the entire dataflow.
  • If several gateways are needed, the best practice is to build several dataflows (one for each gateway) and use the compute or entity reference capabilities to unify the data.
  • Dataflows are only supported using enterprise gateways. Personal gateways will not be available for selection in the drop down lists and settings screens.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Anonymous
Not applicable

Re: Dataflow Timeout

Hi,

 

We are using an enterprise gateway and just have one gateway for all dataflows.

 

Regards

 

Mike

Highlighted
Regular Visitor

Re: Dataflow Timeout

Hi Mike,

 

Can you please share the refresh log (by downloading the CSV file from the refresh history)?

Please mail it to dataflow support DL: pbidf@microsoft.com

 

Thanks,

Galia

Highlighted
Anonymous
Not applicable

Re: Dataflow Timeout

Hi Galia

 

I don't get to the refresh stage as the dataflow times out when I am previewing the data when building the dataflow.

 

I am unable to save the dataflow.

 

Regards

 

Mike

Highlighted
Regular Visitor

Re: Dataflow Timeout

Hi Mike,

 

Please send to our support email the screenshot with the failure you got, so we can investigate further.

 

Thanks,

Galia

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Dataflow Timeout

I am also having a problem like this.  Do we know any more about Time Out control?

 

I am trying to retrieve a portion of a large table - about 10 of 88MM rows.  If I load that data into its own SQL table, the Dataflows priview loads instantly.  But if I try to load from the correct table, DataFlows works at it for about 10 minutes and quits.  

 

I wouldn't expect the query to complete in SSMS in that time.  How can we get Dataflows preview to be a little more patient?

Highlighted
Frequent Visitor

Re: Dataflow Timeout

What is the solution to this? 

Highlighted
Frequent Visitor

Re: Dataflow Timeout

Can anyone share the solution to this? Not sure the marked solution is actually a solution

Highlighted
Advocate I
Advocate I

Re: Dataflow Timeout

I have no solution for the problem, but did use the following workaround. 

 

I created the desired query in PowerBI Desktop.  Then I captured the M code from the advanced editor and pasted it into the editor in Dataflows.  Then I just clicked 'Close and Save' and navigated away without waiting for the preview to finish.

 

The dataflow loaded without problem, but managing the query has to be done out of Power Query Editor, and then copied into the editor in the Dataflows interface.  

 

Not a very satisfying approach, but it is functional.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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

Top Solution Authors