ODBC OLEDB Data Source error.

[Anonymous]

Hi,

My data source is the SharePoint list. I am getting the below error. There are no errors in the Transformation steps or any data type mismatch. I am not able to debug it. 

Regards,
Ashfiya

[Anonymous · Accepted solution]

So when importing the list I got a message there are errors in the query. However, if I tried to check the error, the query errors would either be blank or took a very long time to load. I applied "Remove Blank rows" to the Primary column and reloading my queries to the report returned no errors.
The thread below was helpful to me.
https://community.powerbi.com/t5/Desktop/error-message-after-building-query-returns-zero-rows-in-the...

[PijushRoy]

Hi @Anonymous 

Can you please clear permission from below option


Again go to File > Option and select below option > and login from browser

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[amitchandak]

@Anonymous , Clear Data Source Credentials and Try again.  Home Tab -> Transform data -> Data Source Setting

If you are on August 2022, check issue, few users reported issues in the past

https://community.powerbi.com/t5/Issues/idb-p/Issues

[Anonymous]

hi @amitchandak 
Thanks for the reply. I am using Jan 2022 version. I tried clearing Data Source Credentials and still facing the same error. 
I am getting the data using OData Feed is that an issue?