Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
When I read cosmos streams in power bi desktop , sometimes it doesn't work and says "Vertex execution did not finish in 00:00:30 time". I'm using ODBC to connect cosmos reference to this link : https://osgwiki.com/wiki/Connecting_to_Cosmos_Streams_from_PowerBI_Desktop
So how to set connection time out ? The sentence to connect is like Odbc.Query("dsn=Cosmos", "SSTREAM ""/my/test.ss""") , no matter where I put ConnectionTimeout=1800 or ConnectionTimeout=#duration(0, 50, 0, 0), it doesn't work.
Any help?
Hi @colineric ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, feel free to ask.
Best Regards,
Cherry
Hi @colineric ,
Firstly, please check if you have installed the latest version of Power BI Desktop 2.68.5432.841.
In addition, based on the syntax of the ODBC.Query function, the ConnectionTimeout should be like bleow:
Odbc.Query(connectionString as any, query as text, ConnectionTimeout=#duration(0, 0, 20, 0)) as table
An optional record parameter, options
, may be provided to specify additional properties. The record can contain the following fields:
ConnectionTimeout
: A duration which controls how long to wait before abandoning an attempt to make a connection to the server. The default value is 15 seconds.CommandTimeout
: A duration which controls how long the server-side query is allowed to run before it is canceled. The default value is ten minutes.Besides, do you have any error message when you use ConnectionTimeout=#duration(0, 50, 0, 0)?
Please try if you set the parameter like below, will it work?
ConnectionTimeout=#duration(0, 0, 50, 0)
Best Regards,
Cherry
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |