Questions tagged [data-connection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
1k views

OData Query for Azure Data Factory SPO List Connector Doesn't Return Expected Results

I am trying to run an OData query via a SharePoint Online List connector in Azure Data Factory, here is my query: $select=Id, ProjectId, Project/Id, Project/Title&$expand=Project "Project&...
DimUser's user avatar
  • 111
0 votes
0 answers
51 views

EXCEL import: share point calculated field source columns are blank while others can see data in them

I understand that exporting a share point List view with calculated column will pull the source columns for that calculated column to excel even if they are not in the view. my issue is there is no ...
ikas001's user avatar
3 votes
1 answer
7k views

What is Data connection Library?

What is the data connection library in SharePoint online? what is the relation between the Infopath & data connection - library? When to use a data connection library? What are the uses and ...
Geek's user avatar
  • 83
1 vote
1 answer
2k views

Connect to SQL Database from Custom WebPart

I am trying to create a custom web part in SharePoint 2013 that connects to a SQL 2012 database. I have gone as far as I can with the SharePoint BDC to connect to the external data. I am not able to ...
Moe's user avatar
  • 45
0 votes
1 answer
51 views

SharePoint Data Connection vs. InfoPath

I’m facing issues with setting up a data connection between SharePoint and InfoPath. It works fine without any issues until I publish the form. The point is that I would like to get a normal ...
Guido Matis's user avatar
4 votes
2 answers
3k views

How to get the text, not the ID number, from an external look-up field with InfoPath?

I have an InfoPath form with a drop-down list that needs to be populated with a field from an external SharePoint list. However the field is a Look-up Field and when I get it to populate the drop-down ...
wahle509's user avatar
  • 371
0 votes
1 answer
25 views

Use the data of Apps list in the collection site

I created a list (external content type) with Visual Studio in an app within in site collection under Office 365 SharePoint. However, this list is not visible in the site collection, (the app is in ...
ermo's user avatar
  • 1
0 votes
1 answer
199 views

SharePoint 2013 and ReportingServices2010 CreateDataSource Example

Can anybody help me with how to use CreateDataSource with SharePoint 2013 to Create a Data Connection in C# code?
Safiya P's user avatar
3 votes
5 answers
10k views

How to resolve error creating universal data connection file (.udcx)?

Trying to follow along to create a Data Connection Library but run into the following error: The specified location does not exist or could not be opened. Choose a data connection library on a ...
adhoclobster's user avatar
0 votes
1 answer
682 views

Encryption of connection string in Web.Config to separate SQL Server

Server One: OS Windows Server 2008 + MS SharePoint 2010; Server Two: OS Windows Server 2008 + MS SQL Server 2008 I need to encrypt the connection string in web.config on Server One to connect to ...
SPDeveloperGuest's user avatar
0 votes
1 answer
160 views

'Select a measure:' stuck on 'Loading...' in Dashboard Designer KPI Dimensional Data Source Mapping

I am trying to create a KPI in Dashboard Designer, but am getting a timeout. I have been doing this for a while on my site; this is not the first. I haven't had this problem before. I created a new ...
Conrad's user avatar
  • 199
0 votes
1 answer
783 views

InfoPath 2013 data connection error message

A developer has created an InfoPath form (Designer 2013), the form has some custom code behind the scenes, it also has 2 drop down option boxes that connect to a list on a SharePoint 2013 site. When ...
Craig's user avatar
  • 1
3 votes
2 answers
6k views

SharePoint 2013 Excel Services & External Data Refresh Failed

I need advice how I can fix problem with Excel external data connection. I have an excel file, which have connection to SSAS. Excel file "refresh all" works fine if I download it out from SharePoint. ...
user21216's user avatar
1 vote
1 answer
187 views

Infopath 2013 - Cant Use Data connection (Get data from sql )

I build a simple list and customize the new form in infopath. then I add new data connection and check receive data then select database and table (specially I add a table that have 10 row data) So I ...
aMir Kazemi's user avatar
2 votes
1 answer
676 views

Cannot retrieve all items from large SharePoint list via Excel data connection

I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset ...
bgw's user avatar
  • 51
1 vote
1 answer
4k views

Data Connection Library app is missing in SharePoint 2013

I am trying to create a Data Connection library in SharePoint 2013 (for use with InfoPath) but the Data Connection Library app does not appear in the list of available apps. I have already enabled ...
Peter Core's user avatar
1 vote
1 answer
3k views

Submit fields in an InfoPath form to multiple lists

I would like to create an InfoPath form that submits two fields to one list, and two fields to another list. Could I use a button with rules that bind to multiple data connections and then promote ...
Shrout1's user avatar
  • 545
2 votes
1 answer
15k views

How do I create a data connection library on a SharePoint 2013 site?

I am trying to create InfoPath forms based on data connections rather than directly against a list but I am unable to find out how to create the library for storing the connections. I found this ...
Ryan Erickson's user avatar
1 vote
0 answers
386 views

Data Connection Library Event 6932

I am having the worst time connecting to the web service to call in the UserName variable for use in my InfoPath 2007 form. I can do it from a code behind, and want to be able to use this option as ...
Sean's user avatar
  • 404
0 votes
1 answer
1k views

Auto-Set a Sharepoint list field upon submittal of a form

I created an Infopath form and would like to have a particular field to be set to some default value every time this form is submitted (the field is not shown on the form, user should not have to ...
Alex's user avatar
  • 1,089
0 votes
2 answers
5k views

MS InfoPath throws connection error when trying to lookup a list in "Preview" mode

For some time I've been highly annoyed with the data connection errors I receive when trying to preview my InfoPath forms. I had to publish the form before I could see my lookup list working ...
Shrout1's user avatar
  • 545
0 votes
1 answer
7k views

Basic setup for InfoPath 2010 Person/Group picker

After configuring a Person/Group picker in InfoPath 2010 I couldn't get the "Filler" version of the form (client enabled, not web enabled) to successfully pull names from Active Directory. I thought ...
Shrout1's user avatar
  • 545
0 votes
2 answers
189 views

a separate site for a Sharepoint data connection library - why?

Step 1 of procedure "To create a SharePoint Data Connection Library" in msdn article How to: Create and Use a Data Connection Library tells: "1. Browse to an SharePoint Server 2010 site on which you ...
Gennady Vanin Геннадий Ванин's user avatar
5 votes
2 answers
3k views

Data Connection Library Type is Missing in Sharepoint 2010

I have Sharepoint 2010 Foundation installed in Windows 7 Professional(64 bit). Now I noticed that Data Connection Library type is missing in library templates. Do I have to make any changes in my ...
Helen's user avatar
  • 53
1 vote
1 answer
5k views

Slow data connection in one form

We have an issue in one form where when a data connection is pulled in there is an unbearable load time (at least 5 minutes!). This was singled out by stopping the connection on load and having the ...
Craig's user avatar
  • 23
2 votes
2 answers
3k views

PerformancePoint Dashboard Designer - New Excel Services data source

I'm trying to connect a published Excel workbook as a data source in PerformancePoint Designer, but I'm unable to do so. Here's what I'm doing: In PPDD, on the Create tab, I click Data Source. I pick ...
tplive's user avatar
  • 153
4 votes
2 answers
545 views

Sharepoint deployment scenario with absolute urls involved

I currently have dozens of Excel workbooks being displayed in Excel services on our development Sharepoint server. The workbooks are setup to use an .ODC connection file which is hosted in a trusted ...
Brian Scott's user avatar
1 vote
1 answer
399 views

How do I work with data connections programmatically?

How to create/update/read data connections in a SharePoint data connection library?
Hamed's user avatar
  • 512