Forum Discussion
ODBC OLEDB Data Source error.
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
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/td-p/159635
4 Replies
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
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?
Hi Anonymous
Can you please clear permission from below option
Again go to File > Option and select below option > and login from browserIf solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/KudosSo 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/td-p/159635
