PowerPivot External Data connection error: Invalid URI

[LadyMagnus]

I am trying to use a .atomsvc file from an SSRS report as my external data connection in power pivot. Every time I tried to connect to this particular report I get an error message: Invalid URI: the Uri string is too long.

Anyone know what this means? Is there any way I can get around this error -- without having to edit the source SSRS report?

the entire detail of the error message is copied below:





============================
Error Message:
============================

Invalid URI: The Uri string is too long.
----------------------------
Failed to connect to the server. Reason: Invalid URI: The Uri string is too long.

============================
Call Stack:
============================

at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
at Microsoft.Data.OData.Atom.ODataAtomDeserializer.ProcessUriFromPayload(String uriFromPayload, Uri xmlBaseUri, Boolean makeAbsolute)
at Microsoft.Data.OData.Atom.ODataAtomServiceDocumentDeserializer.ReadCollectionElement()
at Microsoft.Data.OData.Atom.ODataAtomServiceDocumentDeserializer.ReadWorkspace()
at Microsoft.Data.OData.Atom.ODataAtomServiceDocumentDeserializer.ReadServiceDocument()
at Microsoft.Data.OData.ODataMessageReader.ReadFromInput[T](Func`2 readFunc, ODataPayloadKind[] payloadKinds)
at Microsoft.Data.DataFeedClient.DataFeedODataReader.InterceptODataException[T](Func`1 function)
at Microsoft.Data.DataFeedClient.ODataHelper.GetCollectionsFromODataReader(DataFeedODataReader reader)
at Microsoft.Data.DataFeedClient.ODataHelper.GetCollectionsFromServiceDocumentUrl(Uri serviceDocumentUrl, DataFeedConnection connection)
at Microsoft.Data.DataFeedClient.DataFeedConnection.Open()
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
----------------------------
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open(String& connectionIdentifier)
at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open()
at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)

============================

 

[Matt Allington]

Well I guess the problem is clear - the URI is too long - but how to fix it? Not sure. You could try loading via power query instead. Not sure if it will work, but it is worth a try.

 

[LadyMagnus]

not a terrible idea, but I don't think power query can connect to a .atomsvc file. I'm going to do some research on connecting directly to the SSRS site, but I've never used power query. I'll share my results once I figure it out.