Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi all, I managed from Excel to connect to an OData feed, using the "From Odata data feed (legacy)"legacy wizard. After entering the user name and password required to that feed, it worked nicely... But when I tried the same with the OData connector in Power BI I got the following message:
Any clue how I should proceed, maybe using another connector??
Thx in advance for your inputs,
Ben
Hi @Anonymous
The odata data feed(legacy) in excel is different with the odata connector in Power BI.
Before try any methods, go to "Option"->clear cache, and go to "data source setting"->clear permission for this odata url, also update Power BI to the last version.
Then you can try to enter root odata url in the odata connector, then if it pops out a window, enter the right credential.
If this doesn't work, please use Fildder web debugger to monitor.
Here are some cases you can refer to:
https://community.powerbi.com/t5/Power-Query/odata-not-loading/m-p/2814
https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-NAV-using-ODAta/td-p/146937
Best Regards
Maggie
Really tough to troubleshoot that. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".