Retrieving different numbers of records if using Cosmos DB or ODBC connector

[tribeira]

Does anyone knows what can causes the scenario below, regarding a Cosmos DB (SQL API) data:

- Records retrieved from a query using Cosmos DB connector: 92982

- Records retrieved from a query using ODBC connector (with DocumentDB driver etc., referenced in this documentation: https://learn.microsoft.com/en-us/azure/cosmos-db/sql/odbc-driver😞 85752

In the last case, each time I refresh my data I get a different number of records.

I've already changed parameters related to timeouts in Odbc.Query function, changed the version of the API (https://learn.microsoft.com/en-us/rest/api/cosmos-db/) in the ODBC settings, changed the connection pool parameter in the ODBC settings and couldn't identify the reason why the connection using ODBC is returning less data than should.

Sometimes the number of records returned is the correct one. But it seems to be random, so not works to me, because I need to be sure that all data are retrieved.

Any suggestions about this problem?

[v-yetao1-msft]

Hi @tribeira 

So in which way is the data searched correct? 

Best Regards,
Community Support Team _ Ailsa Tao

[tribeira]

Hi @v-yetao1-msft ,

Using the Cosmos DB connector de number of records retrieved is correct. Using the ODBC connector, the number of records retrieved is wrong and it's different each time I refreshed it.

Any suggestions about this behaviour?

[v-yetao1-msft]

Hi @tribeira 

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Best Regards,
Community Support Team _ Ailsa Tao