dataflow operation timed out

[Anonymous]

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) ? 

[Anonymous]

I am experiencing the same issue with the  "Dataflow operation is timed out" issue. The M Code works in PowerBI Desktop, but you are unable to work in the Data Flows it won't Preview the data

[v-henryk-mstf]

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.

[Anonymous]

Can anyone please help, thank you