Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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

Submitted by Anonymous on ‎10-06-2022 05:38 PM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎10-10-2022 01:58 AM

Hi @Anonymous 

So in which way is the data searched correct? 

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎10-10-2022 04:51 AM

Hi @Anonymous ,

 

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?

Anonymous
Not applicable
‎10-12-2022 01:20 AM

Hi @Anonymous 

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/683031

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses