Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 duration. (I didn't see PowerBI.Dataflows in the documentation)
SQL Example with timeout:
Sql.Database("Server", "Database", "[Query=" Select * From...", CommandTimeout=#duration(0, 5, 0, 0)])
Where to place the timeout option in power query for a dataflow, if existing:
Source = PowerBI.Dataflows(null),
Thanks,
Paul
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.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |