Forum Discussion
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 60 minutes.
but in power bi when i create dataflow, i get the error exception operation timedout, is there any setting that I need to use to solve this ? Also, the "entity" source for data flow = only tables ? can it not be a view or an oracle pipeline query which is something like select * from table (schema.package_name.procedure) ?
3 Replies
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.
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.- Each dataflow may use only one gateway. As such, all queries should be configured using the same gateway.
