Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

dataflow operation timed out

I am creating dataflow for first time, the sql is an oracle pipeline table query, which in oracle runs withing 1 minute when i say select count(*) , (about 3 million rows), I set command timeout to 6...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi Anonymous 

 

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.

Here is the reference document link.

Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Docs

 

If the problem is still not resolved, please provide detailed error information. Let me know immediately, looking forward to your reply.

Best Regards,
Henry

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