cancel
Showing results for 
Search instead for 
Did you mean: 

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

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?

Status: Investigating

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

Comments
Ailsa-msft
Community Support
Status changed to: Needs Info

Hi @tribeira 

So in which way is the data searched correct? 

 

Best Regards,
Community Support Team _ Ailsa Tao

tribeira
Regular Visitor

Hi @Ailsa-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?

Ailsa-msft
Community Support
Status changed to: Investigating

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