.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

2010 Visio Services Data Auto Refresh Issue

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :SharePoint

I have published vdw diagram in Sharepoint 2010 Shared Documents. The diagram data is linked to SQL database.

When I view the diagram in the browser, unless I click dedicated "Refresh" button on the top left at the sharepoint page, data is not updating.

I have changed all the SP 2010 Global settings to minimal value = 0 (as per previous post called 2010 Visio Services Data Refresh Issue).

Still you need to click dedicated "Refresh" button on the top left at the sharepoint page in order to see updated data.

In the article called "Visio Services for SharePoint 2010" is stated that new Visio service supports AUTOMATIC REFRESH.

Am I missing something? Is it possible to have a visio diagram with AUTOMATIC REFRESH published in SharePoint 2010?

I can do some workarounds like publishing in web parts page that has auto pooling, but my understanding was that the Visio diagram refresh is event based on data change only - means if data do not change 10 minutes there will be no calls?



View Complete Post

More Related Resource Links

visio services - can't get rid of data refresh error


keep getting this error message on trying to refresh data

"Viso services was unable to refresh external data connections in this web drawing because of changes in teh structure od an underlying data source. one or more columns in this data source have been deleted after this web drawing was last saved."

The underlying data source has not been changed and I have tried re-creating the visio web drawing from scratch - always this error!

any ideas on how to progress?



Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)



In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

VS 2010: Entity Framework 4.0 and WCF Data Services 4.0 in Visual Studio 2010


Elisa Flasko takes you through a sample weblog application to demonstrate how new improvements in Entity Framework and WCF Data Services work together to simplify the way data is modeled, consumed and produced in Visual Studio 2010.

Elisa Flasko

MSDN Magazine April 2010

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Integrating External Data and Microsoft SharePoint 2010 Platform Services in Microsoft Office 2010 S

Microsoft Office 2010 integrates with SharePoint more closely than in previous versions. The resources here show you how to take advantage of the powerful collaboration infrastructure.

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.

Excel Services no refresh data & no error logs

Hi! I'm trying to publish an Excel workbook which loads data from SQL Server. The result is: no data loaded in the workbook and no error logged on Sharepoint logs. Notice that if I try to refresh the workbook in Office Excel all works fine! I try to set up Windows Authentication, None (to use unattended account) and with .odc file but with no result! The procedure I follow is: 1) create a new Excel file and create new data connection to the database (SQL Server 2008) 2) upload the file in the trusted file location 3) open the file in a web part and click on the "refresh all" button I used the same unattended account which I setup for this purpose with BCS and it works fine! I also try to set with PowerShell the Application ID created ("ES"): "set-spexcelserviceapplication -identity 6d871d92-19dd-4421-b33b-0012f9a5ea18 -unattendedaccountapplicationid ES" with no result. I noticed that the identity of the Excel Service application shown in the Central Administration isn't in the IIS Application Pool list: could it be the problem? I also tried to delete / re-create the application but the two IDs remains disequal! Have someone of you already worked with Excel Services and could give me any help? Thanx in advance, Elena

CAFM/ Space Management using: Visio/ Visio Services/ SharePoint 2010?


We accomplish Space accounting using  Autocad and Archibus to calculate square feet on a facilities floor plan. We would like to have that ability to use Autocad drawings imported into Visio and use Visio services to calculate square footage information and publish the smart drawings on the web using Sharepoint.

Is there anyone that has accomplished this type of work using the Visio/ SharePoint?  Any help is appreciated.  

SQL Reporting Services Data Connector for Dynamics CRM 4.0 issue


I can't find a Dynamics CRM topic and I'm hoping someone here will recognize the problem that we are having with integration between Dynamics and SRS.


Dynamics CRM server deployed fine. But we are having this problem when trying to install the Dynamics SRS Data Connector (an additional component that is supposed to be installed locally on the SRS server):



Trouble is, the SQL server is a default instance, and SRS is hosted on a default web site listening on port 80. In fact, this is just a plain default install of SQL 2005 and SRS 2005 on one server. Nothing has been customized. And yet we get this error when we try to install SRS Data Connector on the local SRS machine:

"Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."


But the SRS is installed and running fine! I can even see and run reports that the Dynamics CRM Server install had created on the SRS server! And yet the setup program insists that SRS is not installed and it won't proceed with installation.

How to activate auto-refresh the visio drawing



we are using the Visio Services in Sharepoint. I have condected my Visio VDW File with the data (from SQL, from SP Site etc.) If I click on the file I see thatauto refresh is desabled and I can see the updated data only if I click refresh, or refresh always, refresh for this session.

If I open it again it's the same history about the update. How can I activate auto-refresh when I open the vdw-drawing?

P.S. Sorry what I post the topic in the false forum, I did not find the visio in sharepoint.

thanks in advance


Visio service data refresh help


I have created Visio 2010 diagram hwich gets the data from SQL 2008 server. vsd diagram works fine on the client, data is refreshed when I click Refresh from Visio 2010.

I have published it as vwd using "Share" option of Visio 2010 on SharePoint 2010 server in Shared Documents site library. It opens fine in browser, you see the diagram, but data is not refreshing, although I force it with dedicated SharePoint Refresh button on the top of the page. No errors, just the data is not updating.

SQL 2008 server is actually on the same Windows 2008 server where the SharePoint 2010 server is. The question is how it connects and works fine from the client PC but cant refresh the data on the server. I am admin on all boxes.

Do I need to publish ODC file on the SharePoint 2010 server too ?

Any help is appreciated.



Sharepoint Designer 2010 - Collect Data from User Issue


I am currently running Sharepoint 2010 Foundation and Sharepoint Designer 2010

I am creating a custom workflow where I am asking 1 user for input using collect data from user.  Following this I am asking a different user the same question using another collect data from user.

Since these creates 2 tasks (1 for each user) I wanted to store the information in the same column, but I seem unable to do so.  Each collect data from user seems to create it's own column even if you name both the same (you end up with 2 columns with the same name but different column id's).

Is there a way to point them both to the same column?  Is there a better way to do this?


More the less I am asking the both persons a yes/no question.  in my workflow if they both say yes I send an e-mail but wanted to have only 1 column in the vew to see the results on the tasks.




Excel Services data refresh from SSAS: How to?


Hello everybody,

I know there's been several threads already on this topic, but I haven't been able to distill a solution to my particular situation. The problem is largely because of my ignorance on the SharePoint part, I'm afraid.

Anyway, here's the situation:

  • SharePoint 2010 Ent in Stand-Alone mode
  • Windows Server 2008
  • Analysis Services 2008 R2 on the same box
  • No windows domain, all people using the system are outside the company
  • All users are created as local windows users
  • We're using the msmdpump to allow access to Analysis Services
  • Excel 2010 is the client for SSAS
  • The user id and password are both stored in the ODC file
  • The user in the ODC is member of a role that allows read-access to the cube
  • The ODC is in a trusted location
  • Since I want Excel Services to use the connection string, the Authentication setting is set to None in the ODC

Now, if I publish an Excel Pivot table to SharePoint and the try to open it in the browser, the initially cached data is displayed. As soon as I try to refresh the data, I get a Data Refresh Failed error. I've been reading for two days straight, and I think I understand that I need to configure the unattended service account using the Secure Store Service.

This is where I'm getting confused. i

WCF Ria Services data loading issue


 Hi, here is my problem: I need to load some set of data. I wrote following code(I use Linq2Sql as ORM):


var query = from sensors in Context.GetWCM_SensorsQuery() where sensors.DeviceID == 1 select sensors;
            Context.Load(query, OnMeasLoaded, null);

  private void OnMeasLoaded(LoadOperation<WCM_Sensor> obj)
            var tmpStore = new List<WCM_Sensor>(obj.Entities);


After this code execution i see situation below:

I found the reason of incorrect queries execution. I have services endpoints dclaration in web.config file. There looks like this:


      <service name="StreamEase.Web.Services.AuthenticationService"
        <endpoint address="" binding="wsHttpBinding"
        contract="StreamEase.Web.Services.AuthenticationService" />
        <endpoint address="/soap"
        contract="StreamEase.Web.Services.AuthenticationService" />

SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

I have user IP instead of host name in the report server url.

Please help.



Excel Services data connection issue. Single environment, none authentication


I really need someone's help to configure my SharePoint 2007/ Excel services connectioon to SSAS 2008. It surely cannot be that complicated???

MOSS on server 1
SSAS 2008 cube on server 1
Trusted data provider created (OLE DB, MSOLAP.4)
Trusted data connection library created
Trusted File location created - children trusted, allow external data = "Trusted data connection libraries and embedded"
Unattended Service Account - setup

I use Excel and create a new .odc file with athenticated type = NONE and save it to the Trusted data connection library. Using the odc I open a new workbook. I firstly get a security warning saying that "MS Office has identified a potential security concern. Data connections have been blocked. If you choose to enable data connections..."

I click on Enable, and now have access to my cube. I create a pivit table and chart and publish the workbook back to a child folder in the Trusted File location. All okay so far!!

Now I open the new workbook, and as soon as I try and interact with it, I get the dreaded error "Unable to retrieve external data for the following connections:


The data sources may be unreachable, may not be responding, or may have denied you access

Verify that data refresh is enabled for the

Building InfoPath forms against Sharepoint 2010 Data Connection Library and Form Services...


Hi Sharepoint Experrts,

I'm trying to develop InfoPath 2010 forms that use External Lists that have been created in Sharepoint Server 2010.  I have problems when testing the forms because access is denied to the external lists.

When I try deploying the forms to the sharepoint site, I cannot upload the form template because it says I have to be a member of the local administrators group.  However, I'm running the administrator account used to install and setup sharepoint on the Windows 7 development machine I'm using.

I also tried loading the InfoPath Data Connections to a data connection library on my Sharepoint site... I can see the files when I login to the site but when I try creating a New form from a Data Connection File, I get an error message "This location does not contain any data connection files with the appropriate settings".  What ARE the appropriate settings?

I'm just really confused about this because I cannot seem to be able to build forms that use data connection files loaded onto a Sharepoint site or central server....

I appreciate any help I can get!




Thanks, KBW
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend