Forum Discussion

David_FLConsult's avatar
David_FLConsult
Copper Contributor
Jun 05, 2024

Insufficient rights using OData import in Excel

Hello

I am facing an issue in Excel when I try to import data using OData.

I get an error called "Insufficient rights". The funny / weird thing about this error is that, it only shows up in Excel. When I try to insert the link into a browser I can see all the data with the same user. I have tried to clear permissions in Excel, reinstalled Excel, waited 24 hours for the cache to be cleared and I even cleared it myself. I still get the same error. Do you guys have any recommendations I could try? I have to say it's only affected on my PC. I have tried it out on my colleagues PC and they have no issues. I of course want to use my on PC. Is there also some other places I have to clean the permissions / cache?

BI & Data Analysis
Excel
Power BI
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    Aug 20, 2024
    Ensure that "Enable all Data Connections" and "Enable automatic update for all Workbook Links" are selected. Go to Control Panel > User Accounts > Credential Manager and ensure there are no conflicting or outdated credentials stored. Remove any credentials related to your OData source and try reconnecting.

Share

Resources