Forum Discussion
SharePoint List Data Refresh Error: OLE DB or ODBC error
Hi VahidDM
Thank you for your response! I double checked and I have full control over the SharePoint site and the specific SharePoint list. I was able to troubleshoot the issue more in the Power Query window and found the issue was related to blank values in a lookup column within the list.
HI MikePowerBI
-
Check if the user account that is being used to connect to the SharePoint list has the appropriate permissions to access the list. If not, you will need to grant the user the necessary permissions.
-
Check if there are any proxy or firewall settings blocking the connection to the SharePoint list. If so, you will need to update the settings to allow the connection.
-
Check if the SharePoint list is locked for editing by another user, try refreshing again later.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi VahidDM
Thank you for your response! I double checked and I have full control over the SharePoint site and the specific SharePoint list. I was able to troubleshoot the issue more in the Power Query window and found the issue was related to blank values in a lookup column within the list.