Rest API and SSRS

Discussion created by Ntilton on Jul 10, 2013



I'm trying to utilize the Nimsoft REST API along with SSRS.


Say I make a call along the lines of:


It will prompt me for a user/pass which I can provide in any browser that works fine (returning an xml file)


I can even save that xml document and upload it manually to my report server and query off of it.


My problem arises when I make the same call as a datasource in SSRS (Report Builder to be exact)

I can provide the data source with credentials but I always get the 401 Unauthorized return


Can I somehow embed the user/pass in the URL? Or is there any other way of doing this?


Any help is much appreciated!