Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

OLE Timeout from Dataflow to Desktop

Hello,   I am having an issue with a timeout connecting to a dataflow in Power BI Desktop. Is there a similiar option for the Dataflow connector as the SQL connector adding an option for timeout du...
dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

You could try to increase timeout when you create dataflow in service by your above M code to see whether it work or not. In addition, you also could refer to Dataflow-Timeout-issue  for moer suggestions. Or you also could create a ticket for this problem(https://powerbi.microsoft.com/en-us/support/ )

Best Regards,
Zoe Zhi

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

The issue is that I do not know how to use that timeout function in the M script for a dataflow when importing into Power BI Desktop.

 

[Timeout=#duration(0, 5, 0, 0)]

 

Or [CommandTimeout=#duration(0, 5, 0, 0)]

 

Where would you put that into the standard auto-generating M script when importing from a dataflow?  Like Below:

 

let
Source = PowerBI.Dataflows(null),
#"----" = Source{[workspaceId="----"]}[Data],
#"----" = #"----"{[dataflowId="----"]}[Data],
DimDate1 = #"----"{[entity="DimDate"]}[Data]
in
DimDate1

 

(I removed the ID info)