Hi Chris.

Thank you for your question. I notice that the URL that you use in the PowerBI screenshot is shortened, have you tried the same shortened URL in the OData reader in FME?

If you can share the log when you receive the "Failed to retrieve feature types" error that would also be helpful.

Are there certain permissions that are applied to the OData accounts?

I look forward to hearing back from you.

Thanks, Daragh

Thanks for your reply Daragh! Sorry it's taken me so long to investigate and get back to this. I have been poking at it again today.

I have tried the shortened URL in the OData Reader as well (the one which in PowerBI is the "level to apply these settings to." Alas, it produced the same results - an error of "failed to retrieve feature types."

I have attached a log from a failed connection attempt. (n.b. I have replaced the real username with 'name' in the text) I believe the user has permission to only read the tables - I can confirm if this is a salient point.

I still haven't been able to browse the tables which are exposed in the OData feed using FME's reader settings dialogue. However, I have had success with a reader if I include the name of the table. Obviously that's not perfect, as I have to know the exact name of everything I want to use before I try to connect to it. At least it works though, and it has let me continue with this task.

To make this work, I have used:

• the full OData service URL as provided to me and shown above
• basic authentication with the username and password provided to me
• spatial type of none
• a value in "Feeds" which exactly matches a table name I need to retrieve

This last point is what got it to work for me.

Clearly, it would be handy to be able to browse, but for now this gets the job done.

Thanks!

Chris J

I've just talked one of my customers through this process and can confirm that @cdejacob​'s workaround works. It's not very practical though so I do hope that this can be solved.