I am attempting to connect to an OData 2.0 source using IDT in BI 4.1. I created a connection resource, but each time I go to preview the data set, I get the following error message in IDT:
A problem occurred while communicating with the provider. Detailed message: Server error: (response: status=401, reason=‘Unauthorized’, request=’/FAKEURL/$metadata’)
I confirmed that the user name and password are correct and my permissions are set correctly.
As a test, I created IDT connections to 2 sample OData sources and they both worked perfectly.
https://api.datamarket.azure.com/Data.ashx/data.gov/Crimes/
So the problem appears to be isolated to my specific OData feed; however, I can connect to my feed using Excel/PowerPivot.
In summary: I can connect to my OData feed using Excel/PowerPivot. Also, I can connect to “sample” OData feeds using the IDT. However, I cannot connect to my OData feed in IDT because I get an “Unauthorized” error.
rdi (BOB member since 2011-03-20)