time out when reading cosmos streams in power bi desktop using ODBC

[colineric]

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?

[v-piga-msft]

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

[v-piga-msft]

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