0
votes
1answer
96 views

Can local SQL Server data be made available in SharePoint Online

We have a SharePoint Online account and local data in a SQL Server instance. The data from the SQL Server is available as an OData feed in SharePoint and can be worked with in Excel Power Query. We ...
3
votes
2answers
271 views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
1
vote
1answer
615 views

SharepointOnlineCredentials not working in an app

I want to authenticate against sharepoint online site using SharepointOnlineCredentials class. Below code works fine in a console application. But the same code is generating error when written in wcf ...
0
votes
0answers
206 views

Unable to refresh SPO 2013 Excel Web external oData source

First of .. I see the Excel Web access webpart on SPO 2013, but is Excel Services available on SPO 2013 and if so, where is it and how do you enable it? So, I have this cloud test users. I ...
0
votes
1answer
111 views

SPO CSOM Development without installing SharePoint 2013 on my Development Client or even On-Prem

We have this simple requirement. Using Data in an existing SharePoint Custom List on SPO 2013. We need to develop a simple wildcard/partial string search across mutiple columns and display matching ...
0
votes
1answer
487 views

403 Error connecting to ODATA via External Content Type with SharePoint

I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at ...