• RELEVANCY SCORE 4.34

    DB:4.34:Manage Data Refresh From Powepivot Gallery Is Not Working x9




    Hello-
    The manage data refresh feature is not working in our SharePoint 2013 BI center PowerPivot gallery.
    In attempting to use this feature, we receive the following error. Please advise.
    Sorry, something went wrong
    An unexpected error has occurred.
    Technical Details
    Troubleshoot
    issues with Microsoft SharePoint Foundation.
    Correlation ID:
    26058d9c-df9e-c006-9afd-3b8b01efda1d
    Date and Time: 5/2/2014 2:15:06 PM

    DB:4.34:Manage Data Refresh From Powepivot Gallery Is Not Working x9

    Thanks Waqas-

    Here are the results. It does not seem that this information will be that useful. Do you have any other suggestions?

    Timestamp Process
    TID Area Category
    EventIDLevel Message Correlation
    05/05/2014 14:51:12.00 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8SharePoint Foundation Database
    ahjqpHigh[Forced due to logging gap, cached @ 05/05/2014 14:51:11.98, Original Level: Verbose] SQL connection time: 0.110907950591486 for Data Source=SP2013DB01.ezesoft.net;Initial Catalog=EzeSoftBI;Integrated Security=True;Enlist=False;Pooling=True;Min
    Pool Size=0;Max Pool Size=100;Connect Timeout=15;Application Name=SharePoint[w3wp][2][EzeSoftBI]69fe8d9c-2f0c-c006-9afd-33466ee175f0
    05/05/2014 14:51:12.00 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8SharePoint Foundation Database
    8acbHigh[Forced due to logging gap, Original Level: VerboseEx] Reverting to process identity69fe8d9c-2f0c-c006-9afd-33466ee175f0
    05/05/2014 14:51:12.25 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8SharePoint Foundation Database
    ahjqpHigh[Forced due to logging gap, cached @ 05/05/2014 14:51:12.00, Original Level: Verbose] SQL connection time: 0.109511125017286 for Data Source=SP2013DB01.ezesoft.net;Initial Catalog=EzeSoftBI;Integrated Security=True;Enlist=False;Pooling=True;Min
    Pool Size=0;Max Pool Size=100;Connect Timeout=15;Application Name=SharePoint[w3wp][2][EzeSoftBI]69fe8d9c-2f0c-c006-9afd-33466ee175f0
    05/05/2014 14:51:12.25 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8SharePoint Foundation Monitoring
    b4lyHigh[Forced due to logging gap, Original Level: High] Leaving Monitored Scope ({0}).{1}69fe8d9c-2f0c-c006-9afd-33466ee175f0
    05/05/2014 14:51:12.43 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8
    0x6FB7003 ahjqpHigh[Forced due to logging gap, cached @ 05/05/2014 14:51:12.26, Original Level: Verbose] SQL connection
    time: 0.134933350467727 for Data Source=SP2013DB01.ezesoft.net;Initial Catalog=EzeSoftBI;Integrated Security=True;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Connect Timeout=15;Application Name=SharePoint[w3wp][2][EzeSoftBI]69fe8d9c-2f0c-c006-9afd-33466ee175f0
    05/05/2014 14:51:12.43 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8Web Content Management Publishing
    7fz3High[Forced due to logging gap, Original Level: Medium] Setting [{0}] as the FormContext.FormMode for the current page69fe8d9c-2f0c-c006-9afd-33466ee175f0
    05/05/2014 14:51:12.75 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8SharePoint Foundation Database
    ahjqpHigh[Forced due to logging gap, cached @ 05/05/2014 14:51:12.43, Original Level: Verbose] SQL connection time: 0.123479380759286 for Data Source=SP2013DB01.ezesoft.net;Initial Catalog=EzeSoftBI;Integrated Security=True;Enlist=False;Pooling=True;Min
    Pool Size=0;Max Pool Size=100;Connect Timeout=15;Application Name=SharePoint[w3wp][2][EzeSoftBI]69fe8d9c-2f0c-c006-9afd-33466ee175f0
    05/05/2014 14:51:12.75 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8SharePoint Foundation General
    g3qlHigh[Forced due to logging gap, Original Level: Verbose] GetUriScheme(/PowerPivot Gallery/Consulting/2013-TimeCard-PowerPivot-Model-SP-v1.xlsx)69fe8d9c-2f0c-c006-9afd-33466ee175f0
    05/05/2014 14:51:12.76 w3wp.exe (SP2013WEB01:0x06C4) 0x0BA8SharePoint Foundation Micro Trace
    uls4MediumMicro Trace Tags: (none)69fe8d9c-2f0c-c006-9afd-33466ee175f0

  • RELEVANCY SCORE 3.75

    DB:3.75:Powerpivot Gallery : Data Refresh Schedule Have Been Reset After Edit File 71




    Dear all,

    I have configured SharePoint 2013 and PowePivot (SQL 2012 SP1). I created PowerPivot gallery, uploaded file and configured manage data refresh schedule. After that I had to edit my report in excel file and re-upload on same name. But the configuration about
    manage data refresh is always reset as none.
    I want keep the configuration of data refresh schedule. Is there anyway to do that or it's a limitation of products.

  • RELEVANCY SCORE 2.82

    DB:2.82:Powerpivot Date Issues fd




    Hi,

    Ihavecreatedadatetablewith arelationshipto a data set in powerpivot 2010.

    Powerpivot is changing some of the dates from the excel sheet to the powepivot window view. The excel sheet still says the correct datebut the powerpivot window has a new date in the future 04-Nov-14.This is only happening for a certain range of dates,
    which have no apprent difference from the other date ranges,

    I've tried variousformatting a new work book to see if that was the problem, but no joy.

    Any suggestions.

    Thanks in advance,

    DB:2.82:Powerpivot Date Issues fd

    Hi,

    Upload your file to OneDrive and share the link of the file here.

  • RELEVANCY SCORE 2.82

    DB:2.82:How Do I Manage Auto Backup In My Picture Gallery With My Galaxy Note 2? ff



    Please help me figure out how to delete and manage pictures from the Auto backup album in my picture gallery.

    DB:2.82:How Do I Manage Auto Backup In My Picture Gallery With My Galaxy Note 2? ff







    Thank you for reaching out to us regarding your Note 2, and backup picture management, Ash_1. To assist, what auto backup service are you currently utilizing? Please share these additional details so we may help out.

    Thank you!

    NicandroN_VZW

    Follow us on twitter @VZWSupport

  • RELEVANCY SCORE 2.66

    DB:2.66:How To Refresh Photo Gallery On N79? xx


    Why photo gallery doesn't show new downloaded/received/captured screen shots,without turn off mobile? Is there anyway to get them on image gallery without turn off phone?

    DB:2.66:How To Refresh Photo Gallery On N79? xx

    Why photo gallery doesn't show new downloaded/received/captured screen shots,without turn off mobile? Is there anyway to get them on image gallery without turn off phone?

  • RELEVANCY SCORE 2.65

    DB:2.65:Mview Refresh How 8s


    hi all,if we do materialized view refresh, how it will get refresh. does mview pull the data from master table or master table only will push the data in the mview.thank you

    DB:2.65:Mview Refresh How 8s

    That's correct, thanks for reminding me of that restriction!

  • RELEVANCY SCORE 2.59

    DB:2.59:Image Gallery Navigation x3


    I was able to manage to create a working image gallery by following the tutorial from Florin Carlig. However, after showing the arge image, i want to make it possible to navigate throught the entire album.

    I used ASP VBscribt in creating this page.

    DB:2.59:Image Gallery Navigation x3

    I was able to manage to create a working image gallery by following the tutorial from Florin Carlig. However, after showing the arge image, i want to make it possible to navigate throught the entire album.

    I used ASP VBscribt in creating this page.

  • RELEVANCY SCORE 2.57

    DB:2.57:Web Gallery 9j


    I can only add 10 images to the Web Gallery in Bridge CS4 even if I choose more than 10 images from the Content Panel before clicking Refresh Preview. Are 10 images the maximum for the Web Gallery?

    DB:2.57:Web Gallery 9j

    Whoops. Just found the answer in another post...

    http://www.adobeforums.com/webx/.59b70a2d/0

    Good luck.

  • RELEVANCY SCORE 2.57

    DB:2.57:Power Pivot Work Book Data Refresh jf


    Hi,
    I have Published a PowerPivot Workbook in Sharepoint powerpivot gallery.
    The Changes in the work book needs to be refreshed in the workbook.
    Pls let me know how this refresh happens or should i need to schedule?
    Thank you

    DB:2.57:Power Pivot Work Book Data Refresh jf

    Hi,
    here are some useful sources to enable data refresh in power pivot gallery. Don't forget to mark as answer if helpful.
    http://msdn.microsoft.com/en-us/library/ee210651.aspx
    http://powerpivotgeek.com/2009/11/12/steps-taken-during-a-powerpivot-data-refresh/

  • RELEVANCY SCORE 2.55

    DB:2.55:How Can I Block Ad Hock Data Refresh Of Published Power Pivot Model In Sharepoint? 19


    Hi eb
    I want to allow certain users only to ad-hock refresh published reports and power pivot models in sharepoint..
    Who can refresh which report\model should be set on a report\model resolution
    not on the entire content level of the power pivot Gallery.

    Same question for enabeling the download of a copy of published power pivot model from sharepoint but with
    the possebility of editing the original published model blocked!
    TIA!
    Rea

    DB:2.55:How Can I Block Ad Hock Data Refresh Of Published Power Pivot Model In Sharepoint? 19

    Rea,
    Is this still an issue?
    Thanks!Ed Price, Azure & Power BI Customer Program Manager (Blog,
    Small Basic,
    Wiki Ninjas,
    Wiki)

    Answer an interesting question?
    Create a wiki article about it!

  • RELEVANCY SCORE 2.51

    DB:2.51:Help Please! Automatically Refresh Data In Powerpivot xj


    I really need your help. Today is my deadline for this task and I need to Manage data refresh of powerpivot. Any idea on how to do it?

    Based from this article, (http://msdn.microsoft.com/en-us/library/gg413467.aspx)

    It says that i need to select the workbook and then click the down arrow to display a list of commands and
    Click Manage PowerPivot Data Refresh. Unfortunately, I can't see it in the down arrow.. Can anyone help me please? Thanks you!

    Regards, Glenn

    DB:2.51:Help Please! Automatically Refresh Data In Powerpivot xj

    A timer job manage the refresh in power pivot which runs on every 24 hrs. Unfortunately you can't automate this as far as I know. Yes, there are some tricks to do that but they are not standard way of getting this done.

  • RELEVANCY SCORE 2.50

    DB:2.50:Returning Text Values From Related Table In Powerpivot 81


    Hi,
    I'm having trouble figuring out how to return text values - in this case state abbreviations - when using the Related function in the Powepivot window. I can use Sumx, maxx and so forth for numerical values- is there a text equivalent?
    Thanks!

    DB:2.50:Returning Text Values From Related Table In Powerpivot 81

    For issues related to Power Pivot, post your question in the forum mentioned below.
    http://social.technet.microsoft.com/Forums/en/excel/threads

  • RELEVANCY SCORE 2.49

    DB:2.49:Refresh Picture Gallery On Nokia N8 xs



    Hi there,

    I have just updated my NOkia N8 to 013.016, all went fine apart from lots of missing pics icons in my pictures' gallery which I cannot delete.

    When I select them all and try to delete them I simply get back a "General: System Error" message.

    How do I refresh the picture gallery, avoiding a hard reset?

    Thanks,

    QaTQat

    DB:2.49:Refresh Picture Gallery On Nokia N8 xs


    i have tried that hard reset so many times it does not work,if i want to send a pic or vid i have to go to file manager then e:drive then video and look for what i want to send and then send that way.when in photo gallery the all photo's album is empty and no way of adding media to the album.the favorite album give the add but does not go to any folder to add photos.......then you get that annoying (GENERAL SYSTEM ERROR)message!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • RELEVANCY SCORE 2.48

    DB:2.48:Sharepoint 2010 - Powerpivot Datarefresh Not Working - Credential Delegation Failed 73


    Hi Everyone,
    I have two server, the server 1 contains the SharePoint 2010 Server and the server 2 contains the SQL Server.
    I am trying to get working the PowerPivot DataRefresh. I have followed some MSDN guides about it. But the data refresh is not working for me. I have looked at the ULS logs and the error is the following:
    Credential delegation failed because Excel Services Application was unable to obtain a Windows Identity.

    Until now, as I said I have followed the MSDN guides and I have configured the following:
    In the Reporting server Central Administration:
    o
    In the Secure Store Service I have create a new Target Application called PowerPivotDataRefresh. And as Target Application Administrators I have added TestUser account (because this is the PowerPivot application pool account).

    o
    In the Excel Services Application , in Global Settings, in External Data block I have added the PowerPivotDataRefresh as Application ID.

    o
    In the PowerPivotServiceApplication1, in Configure service application settings in the Data Refresh block I have added the PowerPivotDataRefresh as PowerPivot Unattended Data Refresh Account.
    In the SharePoint site:
    When I click on the Data Refresh button (in the PowerPivot gallery) or Manage PowerPivot Data Refresh I am obtaining an error. In the Event Viewer the error appears as critical and says the following:

    SQL Database 'WSS_Content_8377ec3e66bf488292593c7c53eff9fe' on SQL Server instance 'ReportingSQL' not found. Additional error information from SQL Server is included below.

    Cannot open database WSS_Content_8377ec3e66bf488292593c7c53eff9fe requested by the login. The login failed.
    Login failed for user 'TestUser'.

    Maybe Kerberos authentication isrequired??
    Any advice will be very welcome!!!
    Thanks and best regards,
    Joss

    DB:2.48:Sharepoint 2010 - Powerpivot Datarefresh Not Working - Credential Delegation Failed 73


    Hello Joss,

    The instructions on how to create it you can find here:
    http://msdn.microsoft.com/en-us/library/ee210671.aspx
    Can youconfirm that the 'WSS_Content_8377ec3e66bf488292593c7c53eff9fe' database exists? If it does exist, does the TestUser has rights to it?

    Thanks,
    MarianoMariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

  • RELEVANCY SCORE 2.48

    DB:2.48:My Gallery 88



    How do I delete a picture from My Gallery?

    DB:2.48:My Gallery 88


    THis was the problem exactly!! As soon as I changed the snc Picasa photos to off ,the pictures disappeared from My gallery!

    THanks for the help.

  • RELEVANCY SCORE 2.47

    DB:2.47:General System Error 7a


    cant View some image in the gallery, it shows General system error, ive done hard reset, so many times, once i restore my data from back up i see those images again which i cant delete, i really need a help on this, secondly my music library will never refresh or add music from my memory card, m sick and tired of this

    DB:2.47:General System Error 7a

    Hi, Electropiz. Welcome to the Nokia Support Discussions. What's your phone's model? Just to verify, each time you perform a hard reset on the phone, the issue is being rectified, correct? However, after restoring back your backup data, the issue reappears? Have you tried to reinstall your phone's software, if this is possible for your phone's model? Can you try to restore limited data on your backup file? If you are using the Nokia Suite, you can select the files that you want to restore back to the phone like contacts messages only.

    For your music concern, does it display the same error message? Can you also try to format your memory card try again after reinstalling your phone's software? Keep us posted with the outcome.




  • RELEVANCY SCORE 2.47

    DB:2.47:N8 Gallery Broken - How To Refresh? 9a



    I had my N8 connected to a Mac via USB while it was turned off and I copied off the photos from the DCIM directory and deleted the photos. Now my gallery just shows a broken icon where the photos were.

    How can I make the N8 refresh the gallery?

    Thanks.

    DB:2.47:N8 Gallery Broken - How To Refresh? 9a

    hi again mate,

    ideally updating the firmware if there is an update available is the best choice, but if there isn't any update, then re-installation of firmware is the next step. Failing that, you can try performing a three-finger hard reset (please make a backup of all data to PC and/or online storage first as reset deletes everything). And if nothing else works, you will need to take your phone to your local Nokia care for inspection: http://nokia.com/support

  • RELEVANCY SCORE 2.46

    DB:2.46:[Forum Faq] Excel Services Data Refresh Does Not Return Updated Data From Data Source 93


    SYMPTOMS
    Excel Services has been configured and is able to refresh data. However, after data in the data source has been updated, the customer doesn't see the data updated in the Excel Web Access web part when he performs a data refresh or select a new filter in
    the PivotTable.
    ROOT CAUSE
    This is most commonly the case because Excel Services is retrieving data from its server data cache. The cache lifetime is controlled by the External Data Cache Lifetime settings for Automatic refresh (periodic/on-open) and Manual refresh. (The
    former is related to automatic refresh settings and the latter is related to manual refreshes generated via the Excel Web Access web part).

    The lower the number (in seconds, down to zero) is set for the cache lifetime, the closer to real-time the data cache becomes. Note that the shorter the data cache lifetime, the more frequent the calls from Excel Services to the data source,
    which may affect overall performance for Excel Services.
    SOLUTION
    The External Data Cache Lifetime can be found as the followings:

    Open Central Administration
    Click on Application Management in the left Quick launch
    Click on Manage service applications under Service Applications
    Scroll to Excel Services Application, and click on its name
    On Manage Excel Services Application, click on Trusted File Locations
    Click on the trusted location that you use
    On the External Data section, you can change the Cache lifetime for Automatic refresh(periodic / on-open) and Manual refresh
    The solution is available for SharePoint 2010 and SharePoint 2013

    Please click to vote if the post helps you. This can be beneficial to other community members reading the thread.

    DB:2.46:[Forum Faq] Excel Services Data Refresh Does Not Return Updated Data From Data Source 93

    SYMPTOMS
    Excel Services has been configured and is able to refresh data. However, after data in the data source has been updated, the customer doesn't see the data updated in the Excel Web Access web part when he performs a data refresh or select a new filter in
    the PivotTable.
    ROOT CAUSE
    This is most commonly the case because Excel Services is retrieving data from its server data cache. The cache lifetime is controlled by the External Data Cache Lifetime settings for Automatic refresh (periodic/on-open) and Manual refresh. (The
    former is related to automatic refresh settings and the latter is related to manual refreshes generated via the Excel Web Access web part).

    The lower the number (in seconds, down to zero) is set for the cache lifetime, the closer to real-time the data cache becomes. Note that the shorter the data cache lifetime, the more frequent the calls from Excel Services to the data source,
    which may affect overall performance for Excel Services.
    SOLUTION
    The External Data Cache Lifetime can be found as the followings:

    Open Central Administration
    Click on Application Management in the left Quick launch
    Click on Manage service applications under Service Applications
    Scroll to Excel Services Application, and click on its name
    On Manage Excel Services Application, click on Trusted File Locations
    Click on the trusted location that you use
    On the External Data section, you can change the Cache lifetime for Automatic refresh(periodic / on-open) and Manual refresh
    The solution is available for SharePoint 2010 and SharePoint 2013

    Please click to vote if the post helps you. This can be beneficial to other community members reading the thread.

  • RELEVANCY SCORE 2.45

    DB:2.45:How To Manage Snapshot Updates With "Complete Refresh" sp


    We try to update the client data-structures (e.g. add a column to
    a snapshot) with "complete refresh" synchronization.
    Unfortunetly after a complete refresh some database objects
    (e.g. foreign keys, sequences) seem to be lost.
    With Option "compelte refresh", the database tables seem to be
    dropped (and all depending objects).
    How can we manage this ?
    We're using Oracle Lite 5.0.1.1

    Best wishes
    Dirk Faulhaber

    DB:2.45:How To Manage Snapshot Updates With "Complete Refresh" sp

    We try to update the client data-structures (e.g. add a column to
    a snapshot) with "complete refresh" synchronization.
    Unfortunetly after a complete refresh some database objects
    (e.g. foreign keys, sequences) seem to be lost.
    With Option "compelte refresh", the database tables seem to be
    dropped (and all depending objects).
    How can we manage this ?
    We're using Oracle Lite 5.0.1.1

    Best wishes
    Dirk Faulhaber

  • RELEVANCY SCORE 2.45

    DB:2.45:Refresh From Crystal Viewer? 11


    Is it possible to refresh report data using Crystal Reports Viewer X1? If so, how?Thanks,Tracy

    DB:2.45:Refresh From Crystal Viewer? 11

    See list of 3rd-party Crystal Reports viewers at: http://kenhamady.com/bookmarks.htmlAll of them can refresh data.

  • RELEVANCY SCORE 2.45

    DB:2.45:Scanner Not Detected In Photo Gallery k3


    I want to copy some old photos, via scanner, onto Photo Gallery. When I click Import from camera or scanner the window only shows my DVD player as available after clicking Refresh. If I go to Scanners and Cameras through Control Panel, the scanner is
    there - as it also is in Device Manager. The scanner is CanoScan D125ou2 and its driver is up to date; I have uninstalled and reinstalled the Canon software. I am using Vista Home Premium. I have now spent several hours on this.

    DB:2.45:Scanner Not Detected In Photo Gallery k3

    I have checked and I do have the latest version of Photo Gallery. I have also checked that my drivers are up to date, using Hardware Helper and nothing appears for Canoscan. I have now sent an email to Canon Support.

    The problem persists and I will notify you if anything useful comes from Canon.

  • RELEVANCY SCORE 2.44

    DB:2.44:Powerpivot Data Refresh Error: Ole Db Or Odbc Error: The Microsoft Access Database Engine Cannot Open Or Write To The File pj


    Hi,
    I have uploded Powerpivot workbook in sharepoint powerpivot gallery. I have a source excel file(ABC) also in the gallery. I am tring to connect ABC(excel file) as my source file. The connection is like \\server\\DavWWWRoot\Powerpivotgalley\ABC.xlsx

    Manage data refresh in sharepoint gives me the below error. I am using windows credentials and have full permissions.
    OLE DB or ODBC error: The Microsoft Access database engine cannot open or write to the file ‘\\server\\DavWWWRoot\Powerpivotgalley\ABC.xlsx. It is already opened exclusively by another user, or you need permission to view and write its data.; 3051. A connection
    could not be made to the data source with the DataSourceID of ‘a8aca1f4-f683-40ce-ae63-f971c9b8d098′, Name of ‘Excel ABC’. An error occurred while processing the table. The operation has been cancelled.

    What would be the cause.
    Thanks

    DB:2.44:Powerpivot Data Refresh Error: Ole Db Or Odbc Error: The Microsoft Access Database Engine Cannot Open Or Write To The File pj


    I figured this one out for me..
    as PowerPivot is using webdav and we are using FQDN internally.
    we have to configure webdav to allow users to automatically logon.
    follow this on your powerpivot servers, solved it for me.
    http://support.microsoft.com/kb/943280

    Best regards

    Michael ThøgersenBest regards Michael Thøgersen

  • RELEVANCY SCORE 2.44

    DB:2.44:Excel Services Data Refresh Timeout On Embedded Powerpivot Cube 8c


    I am trying to perform a manual data refresh from the PowerPivot gallery on an Excel document. This document is using an embedded PowerPivot cube as the source data for the Pivot Table inside of the report. the message is: The request exceededed the
    amount of time allowed. It has been canceled
    Any help would be great.

    DB:2.44:Excel Services Data Refresh Timeout On Embedded Powerpivot Cube 8c

    Just go through this link and see if it helps-http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/761c360a-c5d9-45ff-91ec-f8f1bbfe9f25/
    sharing is learning Whenever you see a reply and if you think is helpful, click Vote As Helpful! And whenever you see a reply being an answer to the question of the thread, click Mark As Answer

  • RELEVANCY SCORE 2.44

    DB:2.44:No Sound On Liquid E3 Phone Speaker And Distorted Ringtone z1



    Hello again.

    On my Acer E3 phone I did the following to remove this problem “Unfortunately, Gallery has stopped”:

    1. Remove all your pictures from your phone to your PC, external drive, storage etc2. Go to settings Applications Manage Applications Make sure “All” is selected above scroll to Gallery Press on it and hit “Clear Data”.3. Back out of settings.4. Turn your phone off.

    5. Turn phone on.

    What has happened now is I get no AUDIO output out of the phone speaker.... but it's fine when I plug the headphones in to listen to a video, audio source. AND - the phone rings with a "normal" UK ring tone - but distorted like the volume is too high and has blown the speakers?

    E380

    4.2.2.

    Build Number: Acer_AV052_E380_1.006.00_EMEA_3UKs

    Thanks

    Paul

    DB:2.44:No Sound On Liquid E3 Phone Speaker And Distorted Ringtone z1


    Hi y'all!

    In the end it went back. No-one could work out what the problem was.

    Swapped back to a reliable Samsung (S4 Mini)

    Thanks for all the help/advice everyone.

    Paul

  • RELEVANCY SCORE 2.44

    DB:2.44:Data Refresh For Powerpivot For Sharepoint Creates An Error 8s


    Hi,
    When I click om Manage Data Refresh on a powerpivot in PowerPivot Gallery a get an errormessage:
    ERROR
    An unexpected error has occured. Troubleshoot issues with Microsoft Sharepoint Foundation
    Does anyone has any idea what is wrong
    /Larra

    Larra

    DB:2.44:Data Refresh For Powerpivot For Sharepoint Creates An Error 8s

    Thanks Mariano,

    Is the Secure Store proxy associated with the default web application (Central Administration Application Management Configure service application associations)?
    We have design BI as a custom webapp and forgetten to associate Secure Store proxy with the BI custom app!
    Now it's possible to define the Data Refresh, hopefully it will run the refresh when scheduled!

    /LarraLarra

  • RELEVANCY SCORE 2.44

    DB:2.44:Powerpivot Reading Contents From List Of Another Web Application. 1z


    I have 2 web applications using different authentication methods. One with classic and another in clams authentication. Also Secure Store Service is used in one of these.

    Each have site collection and SharePoint List in it. PowerPivot is used to display data from list to End-users.
    1) I wonder is possible for powepivot to read data from list of another web application with different authentication method. Possible even secure store service is used?

    2) Also wondering if is possible to list to use list of another web application as source. I means that list A could show contents of list B so that Powepivot reading data from list A could actually show contents in list B.

    Kenny_I

    DB:2.44:Powerpivot Reading Contents From List Of Another Web Application. 1z

    How did you read SharePoint list data with PowerPivot in Excel? I use the Data Feed connection and SharePoint RESTful api, the URL for the feed can be something like:

    https://sp2013.guyuming.com/_api/lists/getbytitle('Products')/items
    You can configure authentication for the data feed connection in the advanced setting:

  • RELEVANCY SCORE 2.43

    DB:2.43:Powerpivot For Sharepoint Data-Refresh Error Unexpteced Error On Clicking Manage Data Refresh kx


    Hallo,
    I installed power pivot for sharepoint (as sql server 2012 feature) and an application service within the central adminsitration.
    - Configured Secure Store Service for Unattended Account
    - CWTS is running
    - Unattended Account is configured for PowerPivot
    I created a power-pivot-site and uploaded a powerpivot-workbook (data source is sql server 2008r2 dw adventure works cube) to the power-pivot-gallery. I can open the workbook and whenever I click on a filter i receive the error message:

    An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: PowerPivot Data
    Nothing to find in the event viewer or sharepoint ULS
    Also when I click on manage data refresh I receive an unexpected error. Strange thing here is: I also cant find anything in the ULS or event viewer.
    Please help. This is driving me crazy.

    Best regards,
    Lou

    DB:2.43:Powerpivot For Sharepoint Data-Refresh Error Unexpteced Error On Clicking Manage Data Refresh kx

    Here is one post explaining same issue
    http://sureshpydi.blogspot.in/2013/09/external-data-refresh-failed-error.html

  • RELEVANCY SCORE 2.42

    DB:2.42:Exif Info And Mobile Me Gallery jd


    When making a MM gallery from Aperture the exif data is missing when clicking on the "i" button in the gallery when viewing on the web. It shows on other apps. (Bridge, Aperture etc.)

    When posting from iPhoto it is there.

    Any ideas why Aperture strips the camera info when posting a MM gallery?

    Sue

    DB:2.42:Exif Info And Mobile Me Gallery jd

    see previous message. Allow downloading.

  • RELEVANCY SCORE 2.40

    DB:2.40:Refresh Function - Rss As Rest Again zz


    Hello,
    Maybe by design but I noticed some strange behaviour
    When using Refresh(rss!channel!item) (e.g. refresh RSS when used as REST) it doesn't actually refresh the data or at least it's not visible in the gallery displaying the data.
    No errors, viewing the feed directly in browser shows updated articles but the gallery doesn't update till reload of the application itself.
    This happens regardless of how the refresh is called (button, timer, etc.).
    Some context or guidance would be helpful.
    Update:
    I've added the same RSS feed as RSS with a refresh and that one does work after a while (assume there is a mandatory delay to avoid too many requests).
    Could it be that it's not working because when refreshing Refresh(rss!channel!item)you are actually not targetting the whole feed but just the needed data part?
    Regards
    StonyArc

    http://www.stonyarc.com http://www.xboxlivenation.com

    DB:2.40:Refresh Function - Rss As Rest Again zz

    Hello,
    this seems to be fixed in the new version
    The following will now refresh the RSS when used via Rest (even if it actually refers to a record and not a table).
    Refresh(Mashable)http://www.stonyarc.com http://www.xboxlivenation.com

  • RELEVANCY SCORE 2.40

    DB:2.40:Data Refresh Dates x7



    Can i find out from my bill my Mobile Broadband Data Refresh Dates?

    DB:2.40:Data Refresh Dates x7


    Hi mumbles27,

    Do you mean when your allowance resets? If so, then on your bill will be a date range (for example 12th March to 11 April). This shows that your allowances reset on the 12th of each month and will run to the 11th of the following month.

    Thanks

    Andrew





    I’m part of the Vodafone Tech Team and here to help. As this is a public forum, we can only answer non account specific queries. Please note, we’re unable to reply to private messages.

    If you see a helpful post, please click the 'Thanks' button to let the author know. If a post solves your query, please click the ‘This is the Answer?’ button. This helps others find helpful answers in the community too.

  • RELEVANCY SCORE 2.39

    DB:2.39:Web Gallery Gone From Iphoto 8j


    I created a web gallery in iPhoto last night now it is gone from the sidebar so I can't add more pictures, delete pictures, or do anything to it.

    It is still on our website, but I can't manage it anymore from iPhoto. How do I get it back?

  • RELEVANCY SCORE 2.39

    DB:2.39:Powerpivot Sharepoint Data Refresh Error-Version Mismatch fs


    I am new to this PowerPivot and Sharepoint world.I can upload powerpivot documents in Powerpivot gallery but ehnever I am trying to click Manage Data Refresh' getting the below error-
    SQL Server Analysis Services (PowerPivot) instance returnned the following error Error Code :3239968790 Description:The embedded PowerPivot Data in the workbook cannot be loaded due to version mismatch.

    DB:2.39:Powerpivot Sharepoint Data Refresh Error-Version Mismatch fs

    I am facing same issue , did you respove and psot your soltion..thank you
    MOSS Lahoti

  • RELEVANCY SCORE 2.39

    DB:2.39:Powerpivot Data Refresh Error - Deserialization c3


    Hello together,

    After upgrading my PowerPivot instance from 2008R2 to 2012, the data refresh doesnt work anymore.
    Errors:
    1. Opening the Excel/PowerPivot in SharePoint or just clicking on a slicer I get the following error:
    Unable to refresh data for a data connection in the workbook.
    Try again or
    contact your system administrator. The following connections failed to refresh: PowerPivot Data
    2. Automatic Data Refresh via Configure/Schedule/Manage Data Refresh for a Workbook, I get the following error message in the SharePoint ULS log:
    Deserialization failed: The 'FormatString' element in the 'http://schemas.microsoft.com/analysisservices/2011/engine/300/300'; namespace is unexpected.
    The Situation:
    I've upgraded the following:
    - PowerPivot for Excel 2010 from SQL2008R2 to SQL2012
    - PowerPivot for SharePoint 2010from SQL2008R2 to SQL2012.
    - The Data still comes from an SQL2008R2 Database Server

    I found this one:
    http://social.technet.microsoft.com/wiki/contents/articles/13937.deserialization-failed-and-other-errors-when-using-sql-server-analysis-services-ssas-systems-and-databases-in-a-multi-version-environment.aspx
    but it doesnt help me to solve it, as I dont know how to change something and what!?

    It also mentions some PowerPivot Configuration tools (separate versions for SharePoint 2010 and SharePoint 2013). But when opening the SQL installation center, this option is greyed out!

    Can anyone help?

    Thanks!

    DB:2.39:Powerpivot Data Refresh Error - Deserialization c3

    Hello Daniel,

    thanks a lot for your answer! I was following the upgrade procedure that you listed Upgrade PowerPivot for SharePoint. The Discovery Report shows me following result:

    Microsoft SQL Server 2012
    POWERPIVOT
    MSAS11.POWERPIVOT
    Analysis Services
    1033
    Enterprise Edition: Core-based Licensing
    11.2.5058.0
    No
    Yes

    Microsoft SQL Server 2012

    Client Tools Connectivity
    1033
    Enterprise Edition: Core-based Licensing
    11.2.5058.0
    No
    Yes

    Microsoft SQL Server 2012

    Client Tools Backwards Compatibility
    1033
    Enterprise Edition: Core-based Licensing
    11.2.5058.0
    No
    Yes

    Microsoft SQL Server 2012

    Client Tools SDK
    1033
    Enterprise Edition: Core-based Licensing
    11.2.5058.0
    No
    Yes

    Microsoft SQL Server 2012

    Reporting Services - SharePoint

    11.2.5058.0
    No
    Yes

    How do I use the Setup Wizard to INSTALL the PowerPivot Configuration Tool? Do I need to install the Management Tools for the PowerPivot instance?

    A litte additional info:
    SharePoint 2010 is installed on Server A
    PowerPivot 2012 is installed on Server A
    SharePoints' SQL Server is a 2008R2 and is installed on Server B

    Thanks a lot.

    Martin

  • RELEVANCY SCORE 2.39

    DB:2.39:Refreshing Data In Powerpivot With Sharepoint List Data 71


    Hi,
    I exported SharePoint List to excel and created PowerPivot Table and Chart, and uploaded it in PowerPivot Gallery. I'm having problem when I click on Manage Data Refresh. I have the error below;
    SQL Server Analysis Services (PowerPivot) instance returned the following error: Error Code: 3241607174 Description: A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook,
    file 'C:\Program Files\Microsoft SQL Server\MSAS10_50.POWERPIVOT\OLAP\Backup\Sandboxes\PowerPivotServiceApplication1\ReadOnlyExclusive-ee4daf7b-04c9-4654-8b23-9a9c2d1a75b5-xyz.xlsx'.
    Is there any solution? Thanks
    Orrin

    DB:2.39:Refreshing Data In Powerpivot With Sharepoint List Data 71

    Orrin05
    This video may help you. It shows you how to link excel spreadsheet exported from a SharePoint List.
    Link Excel Workbook to SharePoint List
    You may want to check your connection string to the SSAS data source inside Excel

  • RELEVANCY SCORE 2.38

    DB:2.38:Sharepoint 2013 Access Services And Power Pivot Gallery xm


    For SharePoint 2013, can I 1) use Access Services to create a custom web application and link to existing lists (all on the same site) and then
    2) connect Power Pivot to that custom access application via a query so that I can
    3) still be able to leverage the automated or manage schedule refresh feature on a Power Pivot Gallery?
    (Don't have the ability to use SQL Server)

    Johnny

    DB:2.38:Sharepoint 2013 Access Services And Power Pivot Gallery xm

    Thanks Patrick for your response and the sources. I posted my question in that forum as you suggested.
    Cheers, JohnnyJohnny

  • RELEVANCY SCORE 2.38

    DB:2.38:Excel 2010 Powerpivot Load Data From Oltp Or Olap? pf


    Hi, I would like to have some recommendatation regarding best approach to use either OLTP (Online Transaction Processing) or OLAP (Online Analytical Processing) data-source for Excel 2010 PowePivot data analysis :
    Currently my company has SQL Server database for one of the application. I can run T-SQL queryusing Excel data-connection andload data inside the PowerPivot. Butwe are thkinking to design SQL Server Analysis Service (SSAS) cubeand
    then use this cube as data-source for Excel PowerPivot.

    My concern is that if we use T-SQL (OLTP) system then we can get ALL data like for example to dispaly Invoice_Number and Invoice_Line Number insde SSAS cube it requires to create seperate Dimension for this.

    1) What is best approach to load data in PowerPivot? Also my understanding that once data load inside PowerPivot, it become OLAP format. So best to use T-SQL or SSAS cube as data-source?

    2) With reporting data analysis requirement, I need to create around 6-to-5 different excel spreadsheets with multiple workbooks inside it. What is best approach with it? (We already have SharePoint 2010 as company's intranet site)

    3) How to refresh data inside PowerPivot for using BOTH T-SQL or SSAS? like every 10-hours or when user open spreadsheet? how's this affect performance of loading?
    Any idea? Thanks.

    DB:2.38:Excel 2010 Powerpivot Load Data From Oltp Or Olap? pf

    2) If PowerPivot use in SharePoint 2010 than doesclient computer require to Excel 2010ORExcel only require on SharePoint server?
    Any idea? Thanks.

    Hi KM IT,
    Thanks for Javier giving the clarification, just give some explanation to your second question.If the clientjust want to view thePowerPivot table except deploying the PowerPivot table to SharePoint site, orsaving itfrom SharePoint
    site, surely it can work well without installing the Office 2010 on SharePoint server and client computer. If you want to do some operation, such as design the powerpivot table, deploy the powerpivot table to SharePoint server, of course, you should install
    office 2010 in local computer.
    Hope this is clear for you.
    Thanks,
    Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.37

    DB:2.37:Are Oledb Data Types Restricted In Powepivot? c9


    Hi there,
    we are trying our OLEDB Provider (own developed for SAP tables) with PowerPivot and it seems that some of the OLEDB datatypes are not supported.
    When I try to import a certain table I get this message:

    The following system error occurred:
    The operation has been cancelled.
    The same table works on the preview and filter page well!
    When I am using only string columns from this table it also works.
    So I think the problem will arise with some OLEDB datatypes (DBTYPE_DBTIMESTAMP,DBTYPE_NUMERIC).

    Any Ideas or documentations?
    Thanks,
    Andi

    DB:2.37:Are Oledb Data Types Restricted In Powepivot? c9

    Hello Andi, after making decent number of tests I can tell that issue is 100% reproducible with your provider, but I cannot reproduce it with anything else. The first error I got
    might be related to the low memory conditions on my VM, and I never was able to reproduce it again.
    So here is the plan: attach PowerPivot to the debugger and check metadata being sent in working and failing queries.
    I suspect that something is not transferred properly when first field is of the Date type.
    If you want, you can email me symbols for your demo provider and I will take look on it too.
    Thanks, Vlad.

  • RELEVANCY SCORE 2.36

    DB:2.36:Unexpected Error When I Click On Manage Data Refresh In Powerpivot Gallery In Sharepoint c1


    When I click on Manage Data Refresh in Powerpivot in sharepoint, I get Unexpected Error. When I see the sharepoint log files System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host at System.Net.Sockets.NetworkStream.Read(Byte[]
    buffer, Int32 offset, Int32 size) . I see this error. There are other power pivot reports that were configured refresh and are working fine. Could anyone help me ?
    Enviroment - sharepoint 2010, powerpivot 2010.
    Below is the log file :
    03/03/2014 09:16:26.41 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Monitoring nasqMedium Entering monitored scope (Request (GET:https://test/rec/_layouts/PowerPivot/ViewDataRefreshHistory.aspx?list=%7b2A368E31-D35F-4575-A1E2-46E1AFB5F819%7dID=14Source=https%3a%2f%2ftest.net%2frec%2fCloseout%2520Readiness%2520Gallery%2fForms%2fGallery.aspx))

    03/03/2014 09:16:26.41 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Logging Correlation Data xmnvMedium Name=Request (GET:https://test/rec/_layouts/PowerPivot/ViewDataRefreshHistory.aspx?list=%7b2A368E31-D35F-4575-A1E2-46E1AFB5F819%7dID=14Source=https%3a%2f%2ftest.net%2frec%2fCloseout%2520Readiness%2520Gallery%2fForms%2fGallery.aspx)586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.43 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Logging Correlation Data xmnvMedium Site=/rec586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.45 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Monitoring b4lyHigh Leaving Monitored Scope (EnsureListItemsData). Execution Time=14.608560585214586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.48 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Topology e5mcMedium WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/f1e524780f8f45598b197fa12df36130/SSASMidTierService.svc'
    Channel: 'Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplicationClient' Action: 'http://tempuri.org/IGeminiServiceApplication/GetItemDataRefreshHistory' MessageId: 'urn:uuid:ed8a5473-b7d3-484d-84ff-44ce348fe613'586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.88 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Runtime tkauUnexpectedSystem.Net.Sockets.SocketException: An existing connection was forcibly closed
    by the remote host at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.90 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Monitoring b4lyHigh Leaving Monitored Scope (ExecuteWcfOperation:http://tempuri.org/IGeminiServiceApplication/GetItemDataRefreshHistory).
    Execution Time=419.91349459219586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.98 w3wp.exe (0x21F8)

    DB:2.36:Unexpected Error When I Click On Manage Data Refresh In Powerpivot Gallery In Sharepoint c1

    When I click on Manage Data Refresh in Powerpivot in sharepoint, I get Unexpected Error. When I see the sharepoint log files System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host at System.Net.Sockets.NetworkStream.Read(Byte[]
    buffer, Int32 offset, Int32 size) . I see this error. There are other power pivot reports that were configured refresh and are working fine. Could anyone help me ?
    Enviroment - sharepoint 2010, powerpivot 2010.
    Below is the log file :
    03/03/2014 09:16:26.41 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Monitoring nasqMedium Entering monitored scope (Request (GET:https://test/rec/_layouts/PowerPivot/ViewDataRefreshHistory.aspx?list=%7b2A368E31-D35F-4575-A1E2-46E1AFB5F819%7dID=14Source=https%3a%2f%2ftest.net%2frec%2fCloseout%2520Readiness%2520Gallery%2fForms%2fGallery.aspx))

    03/03/2014 09:16:26.41 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Logging Correlation Data xmnvMedium Name=Request (GET:https://test/rec/_layouts/PowerPivot/ViewDataRefreshHistory.aspx?list=%7b2A368E31-D35F-4575-A1E2-46E1AFB5F819%7dID=14Source=https%3a%2f%2ftest.net%2frec%2fCloseout%2520Readiness%2520Gallery%2fForms%2fGallery.aspx)586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.43 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Logging Correlation Data xmnvMedium Site=/rec586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.45 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Monitoring b4lyHigh Leaving Monitored Scope (EnsureListItemsData). Execution Time=14.608560585214586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.48 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Topology e5mcMedium WcfSendRequest: RemoteAddress: 'http://sp-prd-pp01:32843/f1e524780f8f45598b197fa12df36130/SSASMidTierService.svc'
    Channel: 'Microsoft.AnalysisServices.SharePoint.Integration.IGeminiServiceApplicationClient' Action: 'http://tempuri.org/IGeminiServiceApplication/GetItemDataRefreshHistory' MessageId: 'urn:uuid:ed8a5473-b7d3-484d-84ff-44ce348fe613'586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.88 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Runtime tkauUnexpectedSystem.Net.Sockets.SocketException: An existing connection was forcibly closed
    by the remote host at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.90 w3wp.exe (0x21F8) 0x0AD0SharePoint Foundation
    Monitoring b4lyHigh Leaving Monitored Scope (ExecuteWcfOperation:http://tempuri.org/IGeminiServiceApplication/GetItemDataRefreshHistory).
    Execution Time=419.91349459219586d550a-867c-446f-a66b-00f3bf3b482b
    03/03/2014 09:16:26.98 w3wp.exe (0x21F8)

  • RELEVANCY SCORE 2.36

    DB:2.36:Odata Feed And Powerpivot Filter 9m


    When I use PowerPivot against database , in the PowerPivot Filter options , I'm able to add my filters. When I use PowerPivot against Odata feed , filter options are not enabled. Do I have to do anything on the Odata feed service to enable this options ?
    Or How do I add Filter parameters in the Odata feed url in the PowePivot data configuration wizard ?
    Thanks

    DB:2.36:Odata Feed And Powerpivot Filter 9m

    When I use PowerPivot against database , in the PowerPivot Filter options , I'm able to add my filters. When I use PowerPivot against Odata feed , filter options are not enabled. Do I have to do anything on the Odata feed service to enable this options ?
    Or How do I add Filter parameters in the Odata feed url in the PowePivot data configuration wizard ?
    Thanks

  • RELEVANCY SCORE 2.35

    DB:2.35:Powerpivot Error - Unable To Refresh Data For A Data Connection In The Workbook 98


    All,
    I have a top levelSP BI site - http://business.mydomain.com
    I have a sub site which contains a Power Pivot Gallery.
    Within the Power Pivot gallery is a power pivot based excel spread sheet which works as expected i.e. slicers work and the data refreshes.
    I then created a Power Pivot Gallery at the top level,uploaded the same spread sheet into it and the slicers now don't work. I get the error:

    Unable to refresh data for a data connection in the workbook.
    Try again or contact your systems administrator. The following connection failed failed to refresh: Power Pivot Data
    The PowerPivot Data connection hasn't changed within the spread sheet.
    Checked Manage Excel Services Applilcation.
    Trusted File Location
    Trusted Data Connection Libraryes
    The domain business.mydomain.com is in there.
    The following services are running:
    Claims to Windows Token Service
    Excel Calculation Services
    PerformancePoint Service
    PowerPoint Service
    SQL Server Analysis Services
    SQL Server PowerPivot System Service
    The library permission are identical. It doesn't mater who uploads the spread sheet to the top level Power Pivot Gallery, the slicers still don't work.
    I've checked the following -
    http://technet.microsoft.com/en-us/library/ff487856(v=sql.105).aspx to still no avail.
    IISReset was done this morning.
    What have I missed in creating this second Power Pivot Gallery, at the top level of my BI site?
    Thanks
    W

  • RELEVANCY SCORE 2.35

    DB:2.35:Issue With Data Refresh In Sharepoint 1x


    Hello,
    I am stuck with an issue where I am not able to configure manage data refresh.
    We are trying to configure SQL db with power pivot. and Then Upload this excel sheet in sharepoint.But When I am selecting manage data refresh, it says version mismatch.
    Our SQL is on a sql farm. SO we have full access only for our DB.The SQL farm ver. is 2008R2.
    Secondly, I tried installing all power pivot version but not able to get into the data refresh.

    Please help.

    Thanks
    Manas

    DB:2.35:Issue With Data Refresh In Sharepoint 1x

    Hi Manas,
    The workbook you are attempting to open might have been created in a different version of PowerPivot for Excel. As such, the embedded PowerPivot database cannot be queried by the current version of PowerPivot for SharePoint that is running in your SharePoint
    farm. Please refer to the following article to troubleshoot this issue:
    Unable to refresh data for a data connection in the workbook:
    http://technet.microsoft.com/en-us/library/ff487856(v=sql.105).aspx
    Powerpivot for sharepoint error: Unable to refresh data for a data connection in the workbook:
    http://social.technet.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/thread/ef5c4016-148d-4aa5-b981-ee9720ce4d8c
    If this issue still persists, please post the detail error message to us for further investigation.

    Regards,
    Bin Long
    TechNet Community Support

  • RELEVANCY SCORE 2.35

    DB:2.35:Icloud Web Gallery sm


    Hi,is there some web photo gallery (maybe Photo stream gallery or something) simmilar to MobileMe gallery from Apple?

    DB:2.35:Icloud Web Gallery sm

    Perhaps, by now, everyone knows this..but if not, let me just say that zingzang is OUT as a Mobile Me Gallery solution. They are shutting down all services on August 31, 2012.

  • RELEVANCY SCORE 2.34

    DB:2.34:I Click Manage Data Refresh, It Said An Unexpected Error Has Occured. ak


    Hi,
    After several times of uninstalling and reinstalling, I think I have got powerpivot installed. But it still hasa problem: it cannot do data refresh. I can create a powerpivot site or gallery, export as datafeed button exists, but when I click manage
    data refresh, it said An unexpected error has occured. In central admin, I can create a powerpivot application, but after creating and click the powerpivot application, an unexpected error has occured appears again. Do someone has the same problem?
    Or I still did not install powerpivot well? Thank you!

    DB:2.34:I Click Manage Data Refresh, It Said An Unexpected Error Has Occured. ak

    Hello Wendy,

    Are you able to open a powerpivot workbook hosted in a powerpivot-enabled document library (Share Documents or PowerPivot Gallery, for instance)? If so, are you able to click on a slicer/drilldown or Refresh All Connections?

    Please, do share the ULS logs with us. You may change the logging level to Verbose for PowerPivot for SharePoint and Excel Services applications. That might help us narrow down the issue.

    Thanks,
    MarianoMariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.

  • RELEVANCY SCORE 2.34

    DB:2.34:Gallery j8


    can you manage gallerys from within iweb?

    DB:2.34:Gallery j8

    No need to use iweb if the gallery is all your interested in. Just stick to the ease of uploading photos with iphoto

  • RELEVANCY SCORE 2.34

    DB:2.34:Refresh Data ac



    I have a chart that takes data from an excel exported from SAP.

    How to refresh the excel data pressing a "Refresh" button on the swf application ?

    Thank you.

    DB:2.34:Refresh Data ac


    Hope this helps...

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/805a03d5-7b64-2b10-48ab-c5009ac29aa4

    -Anil

  • RELEVANCY SCORE 2.34

    DB:2.34:Can Web Content Overlay Refresh When A User Re-Enters The Page? 89



    I have a page that has a web content overlay that id like to refresh when a user re-enters the page.

    To be exact i have a photswipe gallery that works great butid like it to restart from the beginning when a user renters the page

    DB:2.34:Can Web Content Overlay Refresh When A User Re-Enters The Page? 89


    There is no simple way to disable swiping to a new page. You could put an empty scrolling frame in, I suppose, but I dont see how that would make the readers experience very good.

    Bob

  • RELEVANCY SCORE 2.34

    DB:2.34:Photo Gallery Resets Picture Library To Incorrect Location So Lists No Photos 71


    My pictures are located here: D:/Users/Public/Public Pictures
    The Windows 7 library was perfectly happy with thisand now (after upgrading) Windows 8 library and 'Photos' app are perfectly happy with this; however, WL Photo Gallery suggests I have no photos.
    If I go 'File' 'Include Folder' or right click 'Pictures' 'Manage Pictures Library' within WL Photo Gallery it shows that it's looking at
    C:\Users\Public\Public Pictures (Despite File Explorer still showing the correctpath beginning D:/)
    If I remove that folder from the library and add the correct directory (in drive D:) my pictures start to appear, but after a few seconds it goes blank again and reopening File Include Folder or 'Manage Pictures LIbrary' shows that it has again reset to
    drive C:

    DB:2.34:Photo Gallery Resets Picture Library To Incorrect Location So Lists No Photos 71

    Hi AlexRat,

    It is possible that it is an issue of Photo Gallery for Windows 8. We would like you to try and change the compatibility mode of the Photo Gallery running in Windows 8 just isolate the issue further. To do this, please follow the steps provided below:

    1. Locate Photo Gallery by hitting Windows Logo in the keyboard then type Photo Gallery.
    2. Right-click Photo Gallery, on the options below, click
    Open file location.
    3. Right-click Photo Gallery and then click Properties.
    4. Go to Compatibility tab.
    5. Under Compatibility mode, tick Run this program in compatibility mode for: , click the dropdown below and then selectWindows 7.
    6. Try to import again and see if the issue persists.

    Please do update us through this thread if the issue has not been corrected.

    Thank you.

  • RELEVANCY SCORE 2.34

    DB:2.34:Diasble/Hide Manage Data Refresh In Power Pivot Gallery In Sharepoint 77


    Hi All,

    My requirement is to disable or hide manage data refresh option in power pivot gallery. Please let me know if we can achieve this.

    Thanks for the help in advance!

    Regards,
    Balaji

    DB:2.34:Diasble/Hide Manage Data Refresh In Power Pivot Gallery In Sharepoint 77

    Hi,

    Workbook owners or authors must have Contribute permission to schedule data refresh on a workbook. Given this permission level, he or she can open and edit the workbook’s data refresh configuration page to specify the credentials
    and schedule information used to refresh the data.

    Screenshotwhile logged in as a test user in the Contoso Visitors Group, the Refresh Linkis security trimmed
    Reference: http://msdn.microsoft.com/en-us/library/ee210595.aspx

    -IvanIvan Sanders My LinkedIn
    , My Blog,
    @iasanders, BI in SP2013,
    SP2013 Content Packs.

  • RELEVANCY SCORE 2.34

    DB:2.34:Dev Qa Refresh From Prod. 1a


    Please let me know the best procedure to refresh QA with PROD data.

    Thanks
    jeevan.

    DB:2.34:Dev Qa Refresh From Prod. 1a

    Jeevan,

    Are you running your production database in noarchive log mode or archive log mode?
    Are you taking any backups using RMAN? If yes then you can use existing backup to restore in dev env.
    Do you have enough storage to hold backup?

    Startegies you can discuss with your team

    1. If any, using existing RMAN backup and restoring in dev. In case if you are taking incremental backups, then restore base backup first and apply inremental backup.
    2. Use of datapump at schema level (export needs to be done at production server, so be cautious on resources- import will be done in dev env)
    3. Use of coventional export/import utility at schema level. This can be done in dev env just need access to production server from dev env.

    Hope this helps, post if you have any specific questions.

    Regards

  • RELEVANCY SCORE 2.34

    DB:2.34:Load Changed Data From Xml File,But The Data Model Can't Refresh. cx


    Load changed data from xml file.
    When I change the xml file content,data model do not refresh.

    DB:2.34:Load Changed Data From Xml File,But The Data Model Can't Refresh. cx

    Is it is in upper case .

    Is your issue resolved ?
    If so then can you please mark this thread as answered so that in future if anyone is referring to similar issue they can find the answer/solution .

    Thanks,
    Sutirtha

  • RELEVANCY SCORE 2.33

    DB:2.33:Transfer Pictures From Gallery To Sd Card k1



    My Motorola Droid Razr Maxx does not have the Manage internal storage. Please provide step by step instructions to move pictures from phone gallery to SD card.

    Discussion title adjusted to be more accurate.

    Message was edited by: Admin Moderator

    DB:2.33:Transfer Pictures From Gallery To Sd Card k1


    see if this helps:

    Transfer Pictures/Videos - DROID RAZR / RAZR MAXX by MOTOROLA

  • RELEVANCY SCORE 2.33

    DB:2.33:Manage Data Refresh - Congigure A Different Data Source 8a


    Hi,
    Please let me know, if the following scenario is possible and any links/steps to configure the same.
    1. I have excel 2010 which has got the data from data source 1 using the power pivot for excel.
    2. Uploaded to the SP 2010 power pivot gallery.
    3. Configure Manage Data Refresh. Here I see that the Data source has been configured to data source 1.
    4. Instead of data source 1, i would like to get the data from data
    source 2. Is this possible?
    5. So every time the user refreshes the excel in browser, the data is fetched from data source 2
    Thanks and Regards,
    Manjunath
    manjunath

    DB:2.33:Manage Data Refresh - Congigure A Different Data Source 8a

    Manjunath,
    Is this still an issue?
    Thanks!Ed Price, Power BI SQL Server Customer Program Manager (Blog,
    Small Basic,
    Wiki Ninjas,
    Wiki)

    Answer an interesting question?
    Create a wiki article about it!

  • RELEVANCY SCORE 2.33

    DB:2.33:How To Refresh The Cache mx


    How to Refresh the Cache in java to fetch the data from database

    DB:2.33:How To Refresh The Cache mx

    How to Refresh the Cache in java to fetch the data
    from databaseToggle the "refresh the cache" option found under Settings- Tools - Nonexistant Options in your IDE.

    Failing that do give some consideration to just perhaps being slightly less vague.

  • RELEVANCY SCORE 2.33

    DB:2.33:Sharepoint Powerpivot Manage Data Refresh : Unspecified Error For The Excel Source as


    Hi All,
    I uploaded the powerpivot to sharepoint gallery and tried to do refresh. I have given windows credentials for the refresh.
    I configured/installed everything as per the blog
    http://powerpivotgeek.com/2010/08/18/working-with-the-2010-office-ace-provider/
    still it is showing below errors..
    06/22/2012 14:49:34.69 w3wp.exe (0x13B8) 0x2608SSAS Mid-Tier Service
    Data Refresh 99High EXCEPTION: Microsoft.AnalysisServices.OperationException: OLE DB or ODBC error: Unspecified
    error. A connection could not be made to the data source with the DataSourceID of 'a8aca1f4-f683-40ce-ae63-f971c9b8d098', Name of 'Excel NodeAdjustmentValue'. An error occurred while processing the 'Adjustments' table. The operation has been cancelled.
    at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError) at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject
    obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact, XmlaWarningCollection warnings) at Microsoft.AnalysisServices.Se...

    DB:2.33:Sharepoint Powerpivot Manage Data Refresh : Unspecified Error For The Excel Source as

    Hi Swe,
    Check the Microsoft Access Database Engine 2010 for 64 - bit on your SharePoint WFE has installed or not. If not download and install the same from the following link:
    http://www.microsoft.com/en-in/download/details.aspx?id=13255
    After installing it, kindly Configure the PowerPivot Unattended Data Refresh Account by following given link :
    http://msdn.microsoft.com/en-us/library/ff773327.aspx
    Hope this will resolve your error.
    Thanks!!
    Regards,
    Vijay

  • RELEVANCY SCORE 2.33

    DB:2.33:Can't Find My Saved Image In Android Gallery ad



    You have to refresh the gallery after saving the snapshot, it will be done by writing Java function and calling it from Unity3D.


    I have used same thing in this plugin:


    http://u3d.as/content/devesh-pandey/capture-and-save/86U


    If you need that java code write me at devesh.pandey19@gmail.com

    DB:2.33:Can't Find My Saved Image In Android Gallery ad


    You have to refresh the gallery after saving the snapshot, it will be done by writing Java function and calling it from Unity3D.


    I have used same thing in this plugin:


    http://u3d.as/content/devesh-pandey/capture-and-save/86U


    If you need that java code write me at devesh.pandey19@gmail.com

  • RELEVANCY SCORE 2.33

    DB:2.33:Problema Schedule Refresh Powerpivot pj


    Buongiorno,
    ho installato PowerPivot su Sharepoint 2010.
    Dopodich ho creato un foglio di lavoro contenente un grafico powerPivot con degli slicer che ha come origine dati un file di Excel contenuto in una raccolta documenti diSharepoint 2010. Ho pubblicato la cartella di lavoro di Excel che ho creato
    in una Powerpivot gallery ed ho impostato da essa il rispettivo Manage Data Refresh giornaliero.
    Il problema che non viene effettuato nessun refresh giornaliero.
    Qualcuno mi sa dare qualche suggerimento?
    Grazie

    Gian

    DB:2.33:Problema Schedule Refresh Powerpivot pj

    Ciao,
    Questo thread e' stato chiuso senza una soluzione, per mancanza di risposta da parte di Gian.
    Eventuale domande sull'argomento rimangono ancora aperte.
    Saluti,Anca Popa
    Come inserire immagini nei post

    Microsoft offre questo servizio gratuitamente, per aiutare gli utenti e aumentare il database dei prodotti e delle tecnologie. Il contenuto viene fornito cos come e non comporta alcuna responsabilit
    da parte dellazienda.

  • RELEVANCY SCORE 2.33

    DB:2.33:Powerpivot And Odata Feed With Filter xj


    When I use PowerPivot against database , in the PowerPivot filter options , I'm able to add my filters. When I use PowerPivot against Odata feed , filter options are not enabled. Do I have to do anything on the Odata feed service to enable this options ?
    Or How do I add Filter parameters in the Odata feed url in the PowePivot data configuration wizard ?
    Thanks

    DB:2.33:Powerpivot And Odata Feed With Filter xj


    Challen Fu,
    Thank you so much for your effort to help the community. I will followup this in the connect.
    Regards

  • RELEVANCY SCORE 2.33

    DB:2.33:Download Photos From Multiply j3


    I would like transferring this system http://staystrong1.multiply.com/manage#_li_photos here. Is this possible?

    DB:2.33:Download Photos From Multiply j3

    Hi Carey,

    You can save the photosfrom Multiply to your Picture library by right-clicking the photo and clicking
    Save Picture As. From there, you need to locate the Picture library and save it there. If you want to save a whole photo album directly to your computer, please contact Multiply's support team and ask if there is a feature to batch download
    the photos.

    Thanks!

  • RELEVANCY SCORE 2.32

    DB:2.32:Client Refresh From Prod To Quality - How Long kp


    Hi ExpertsCould someone please advise how long a client refresh from Production to Quality should normally take. We do not currently have in house basis expertise and the external consultancy who manage the basis functions for us are saying it will take 5 days to do this refresh. Our production system does not have massive amounts of data in it so i would have thought it would take 2 days maximum.Could someone please advise how long a normal refresh would take?Many thanks.Simon

    DB:2.32:Client Refresh From Prod To Quality - How Long kp

    Dear Simon,Its depend upon which method you wants to use and your server database size but its not take more than 2,3 days

  • RELEVANCY SCORE 2.32

    DB:2.32:Missing Gallery In Iphoto zp


    One of my 15 or so iphotos galleries does not appear in iPhoto (in the left pane) but does appear on the gallery Website. I can see the directory with all the files in it in idisk but iPhoto seems to ignore it. If I try to refresh the web gallery photos by Checking for New Photos, the Web Gallery list in the left nav briefly flashes with the missing gallery but then just as quickly removes it from the list of galleries, like a tease.

    How do I get my missing gallery back to iPhoto? The web seems to think it's there and I can verify the files are in fact in the idisk directory.

    Thanks for any help...

    A Musliner

    DB:2.32:Missing Gallery In Iphoto zp

    Is there no need to backup Library.iPhoto?

    No. It seems that the Library.iPhoto file is somewhat of a leftover from earlier versions. Sort of like our appendix. Every thing is now kept in the iPhoto6.iPhoto dB file. That file will have the library structure encoded in it along with the correct paths the original files. The images are stored in the Originals folder that is in the library package.

  • RELEVANCY SCORE 2.32

    DB:2.32:Linking Into Gallery Tree z8


    I have three gallerys and id like to link them together in a tree sort of structure, like Filter does from one gallery to another, except once it filters that gallery i want to filter a third from that already filtered gallery:

    Gallery one {
    item 1
    item 2
    item 3
    }
    Gallery two {
    item 1 (Picture02)
    item 1 (Picture03)
    item 1 (Picture04)
    item 2 (Picture07)
    item 2 (Picture05)
    item 2 (Picture09)
    item 3 (Picture06)
    }
    Gallery three {
    (Picture02) [data]
    (Picture06) [data]
    }

    if that makes sense, if not, reply with a question please

    DB:2.32:Linking Into Gallery Tree z8

    Hi Michael,
    When you say Siena can't find Gallery2, do you mean that the formula is not valid, and there is a red squiggle under Gallery2 that says Invalid Name ?
    If so could you please check that the name of the second Gallery is Gallery2 by clicking on it and checking in the dropdown in the top left corner ? You can also press and hold the ALT key to see all the names for all the controls.
    Thanks,
    Olivier

  • RELEVANCY SCORE 2.32

    DB:2.32:Refreshing Excel 2010 Workbook With Connection To Access Database On Shared Network Drive xs


    I have an Excel 2010 workbook that has a connection to an Access database that's on a shared drive on the company network. I can refresh the data in the regular Excel application but when it's hosted in the browser I get this error message The data
    connection uses Windows Authentication and user credentials could not be delegated.
    Next, I installed PowerPivot for SQL server 2008 and used PowerPivot to connect to the same Access database. I uploaded it to a PowerPivot gallery but when I try to refresh the data but it says the workbook was created in an older version of Excel
    and PowerPivot and cannot be refreshed until the file is upgraded. I tried to go to Manage data refresh but I get the Sorry, something went wrong page. Do I need to install PowerPivot for SQL server 2012 to do scheduled data refreshes?
    What about manual refreshes?

    DB:2.32:Refreshing Excel 2010 Workbook With Connection To Access Database On Shared Network Drive xs

    I have an Excel 2010 workbook that has a connection to an Access database that's on a shared drive on the company network. I can refresh the data in the regular Excel application but when it's hosted in the browser I get this error message The data
    connection uses Windows Authentication and user credentials could not be delegated.
    Next, I installed PowerPivot for SQL server 2008 and used PowerPivot to connect to the same Access database. I uploaded it to a PowerPivot gallery but when I try to refresh the data but it says the workbook was created in an older version of Excel
    and PowerPivot and cannot be refreshed until the file is upgraded. I tried to go to Manage data refresh but I get the Sorry, something went wrong page. Do I need to install PowerPivot for SQL server 2012 to do scheduled data refreshes?
    What about manual refreshes?

  • RELEVANCY SCORE 2.32

    DB:2.32:Sharepoint 2010: Refresh Excel Document Containing Powerpivot k9


    We have a range of Excel 2010 documents containing PowerPivot repports, which are published to a PowerPivot gallery in Sharepoint 2010. PowerPivotget its data from views
    in a SQL server. Sharepoint 2010 should refresh these documents once per day (get new data, refresh Excel document). The documents are stored in binary format since thisseemed to be more stable(storing them in the XLSX format resulted in slicers
    dissapearing and document failingwhen published to Sharepoint 2010). A data refresh schedule is set for each document in Sharepoint 2010.

    DB:2.32:Sharepoint 2010: Refresh Excel Document Containing Powerpivot k9


    Hi Motroen

    Couple questions.
    1. Do you see any errors when you click on the Manage data refresh Icon (the calendar icon in the gallery)?
    2. When your users click on Refresh All Connections while viewing the workbook in the browser, they get the updated data that is on the cube?
    If number 2 above is a yes, then we may have a timing/caching issue.But I would like to see the results from the Manage data refresh page.

  • RELEVANCY SCORE 2.32

    DB:2.32:How Do I Import To Wl Photo Gallery From External Hard Drive mc


    Exzternal hard drive is plugged in. When I go to Windows Live Photo Gallery and click "Import" a blank box comes up which doesn't show the external hard drive. Clicking "refresh" doesn't open the drive either.

    DB:2.32:How Do I Import To Wl Photo Gallery From External Hard Drive mc

    Instead of Importing,
    Click on the blue file button on the top left and click on Include folder,
    Click on Add, then navigate to the external drive and the folder you want to include in wlpg search,

    Then click on Include folder.
    When you edit a file in wlpg it saves the Original file on the C:drive if you want to Move this location you can,
    Click on the blue file button again and click on Options,
    Go to the Originals section, click on Go to this folder,
    It will appear on the Navigation pane near the bottom,
    Right click the listing and select Properties,
    Make a Target folder where you want these Original images to be stored,
    Then click on Find Target and navigate to the new folder, click on Move.
    Adding external drive to library,
    http://windows.microsoft.com/en-US/windows7/Redirect-a-folder-to-a-new-location
    Change the default save location,
    http://windows.microsoft.com/en-US/windows7/Customize-a-library

  • RELEVANCY SCORE 2.32

    DB:2.32:Inserting Multiple Html Issue p8



    Hi,

    I have embedded a video and an image gallery on my mobile site (WIP) using the insert html (each inserted separately) . I am having a strange issue where after viewing the photo

    gallery the video from vimeo becomes static and the play button does nothing! If I refresh the page the video becomes active!? Its only when viewing the gallery that this happens.

    Any Ideas will be greatly appreciated.

    Thanks

    DB:2.32:Inserting Multiple Html Issue p8


    Hi,

    I have embedded a video and an image gallery on my mobile site (WIP) using the insert html (each inserted separately) . I am having a strange issue where after viewing the photo

    gallery the video from vimeo becomes static and the play button does nothing! If I refresh the page the video becomes active!? Its only when viewing the gallery that this happens.

    Any Ideas will be greatly appreciated.

    Thanks

  • RELEVANCY SCORE 2.31

    DB:2.31:Gallery Taking A Lot Of Time To Load The Pictures... 7k



    I'm facing this problem with mu sola., bought very recently!!

    I am having a problem with my gallery it takes up a lot of time to load up the pictures. Even if i open any one before letting it load fully, the images appear blurred.

    I got a soln from xperia 2011 forum as

    Try this, do not worry it does not delete your data:

    Main Menu Settings Applications Manage Applications All Gallery Clear Data.

    I tried that,

    I think, if we try to do that, getting alert as 'it may clear all existing data"

    Is it so??







    Solved!
    Go to Solution.

  • RELEVANCY SCORE 2.31

    DB:2.31:Data Refresh History Not Displaying For Pp Galleries In An Ssl Enabled Site zk


    Hello again! I've discovered something interesting with the PowerPivot Management Dashboard. We have PowerPivot configured in a site with SSL enabled. From the Gallery I'm able to set up a schedule and it executes successfully. Now
    when I go to check the history of this refresh in the PowerPivot Management Dashboard (Data Refresh - Recent Activity.... click on the workbook that just refreshed) and all that displays is a blank white screen.
    I've determined that this has something to do with SSL since I can create a new site collection on the same server, without using SSL, and following the same procedure as outlined above, I'm able to see the refresh history of the workbook.
    Anyone else run in to this problem?
    Thanks,
    Jeff.

    DB:2.31:Data Refresh History Not Displaying For Pp Galleries In An Ssl Enabled Site zk

    Jeff,
    Is this still an issue?
    Thanks!Ed Price, Power BI SQL Server Customer Program Manager (Blog,
    Small Basic,
    Wiki Ninjas,
    Wiki)

    Answer an interesting question?
    Create a wiki article about it!

  • RELEVANCY SCORE 2.31

    DB:2.31:Sharepoint Powerpivot Refresh Error: Ole Db Or Odbc Error: The Microsoft Access Database Engine Cannot Open Or Write To The File. zk


    Hi,
    I have uploded Powerpivot workbook in sharepoint powerpivot gallery. I have a source excel file(ABC) also in the gallery. I am tring to connect ABC(excel file) as my source file. The connection is like \\server\\DavWWWRoot\Powerpivotgalley\ABC.xlsx

    Manage data refresh in sharepoint gives me the below error. I am using windows credentials and have full permissions.
    OLE DB or ODBC error: The Microsoft Access database engine cannot open or write to the file ‘\\server\\DavWWWRoot\Powerpivotgalley\ABC.xlsx. It is already opened exclusively by another user, or you need permission to view and write its data.; 3051. A connection
    could not be made to the data source with the DataSourceID of ‘a8aca1f4-f683-40ce-ae63-f971c9b8d098′, Name of ‘Excel ABC’. An error occurred while processing the table. The operation has been cancelled.

    What would be the cause.
    Thanks

    DB:2.31:Sharepoint Powerpivot Refresh Error: Ole Db Or Odbc Error: The Microsoft Access Database Engine Cannot Open Or Write To The File. zk

    Try adding the port, even for port 80. So try something like:\\server@80\\DavWWWRoot\Powerpivotgalley\ABC.xlsx

  • RELEVANCY SCORE 2.31

    DB:2.31:Can't Get Data Source Changed To Sld In Smsy pc



    SolMan 4.0

    I have a system in the SLD but cannot get the SLD to update the system in SolMan. The data source is Manual (Automatic Refresh). I've tried changing this to the other manual data source, running the landscape fetch, changing back to manual (automatic refresh) and running landscape fetch again. Still, the data source says Manual (Automatic Refresh). I even tried to delete everything about this system and add it back. I couldn't get the corresponding system component deleted but did manage to delete everything else. After re-creating, I still have the problem. I can't find the solution. Any ideas from anyone? Thanks!

    DB:2.31:Can't Get Data Source Changed To Sld In Smsy pc


    SolMan 4.0

    I have a system in the SLD but cannot get the SLD to update the system in SolMan. The data source is Manual (Automatic Refresh). I've tried changing this to the other manual data source, running the landscape fetch, changing back to manual (automatic refresh) and running landscape fetch again. Still, the data source says Manual (Automatic Refresh). I even tried to delete everything about this system and add it back. I couldn't get the corresponding system component deleted but did manage to delete everything else. After re-creating, I still have the problem. I can't find the solution. Any ideas from anyone? Thanks!

  • RELEVANCY SCORE 2.31

    DB:2.31:Powerpivot In Sharepoint Data Refresh 77


    Hi Guys,

    I've reviewed other posts on this forum about data refresh issues, however dont see one with my issue.

    I have a 200mb excel 2010 document using powerpivot. I've added it to my PowerPivot Gallery and configured data refresh.
    According to the refresh history, it shows all Ticks, and legitimate time frames for what the refreshes should take.
    The issue is, that if I view the sheet, (i've tried all the refresh options there), in the gallery, i dont see new data at all.
    I did a download, and when it arrived, the download was indeed missing all the new data.
    So what we have is a data refresh that runs for the right amount of time, shows success on every level, but doesn't add the data to the workbook in sharepoint. How can i fix this?

    Charles

    DB:2.31:Powerpivot In Sharepoint Data Refresh 77

    Hi Charles,
    Generally, we can view data refresh history to check status for all PowerPivot workbooks. Herearesome articlesfor your reference, please see:

    View Data Refresh History:
    http://technet.microsoft.com/en-us/library/ee210622
    Verify Data Refresh: http://technet.microsoft.com/en-us/library/ee210651.aspx#drverify
    In your case, you can try to redeploy the workboos to the SharePoint site to see if this help.
    Regards,
    Bin Long
    Bin Long
    TechNet Community Support

  • RELEVANCY SCORE 2.31

    DB:2.31:Word Building Blocks: Refreshing Gallery Entries? 3f


    On my ribbon, I'm displaying the building blocks in Custom 1 gallery, using:
    galleryidMso=CustomGallery1label=Reusesize=large/
    I'm programmatically adding a building block to that gallery usingBuildingBlockEntries.Add, adding the building block to mytemplate.dotx
    The problem I'm having is that when the user clicks on the gallery to see its entries, the new entry is not displayed.
    The new entry is immediately present in the building blocks organizer.
    The new entry does display on the quick access toolbar after right clicking to add the gallery there (but it
    still doesn't display in the gallery in my ribbon).
    The new entry does display in my gallery after Word is
    restarted
    How to get it to refresh?
    - invalidating the ribbon doesn't help
    - saving mytemplate.dotx doesn't help
    -Globals.ThisAddIn.Application.Templates.LoadBuildingBlocks() doesn't help
    Interestingly, when a new building block is saved manually via a click on Save selection to quick part gallery, it does show up immediately in the gallery on my ribbon. For one I have added programmatically though, merely looking
    at it in the building blocks organizer is not enough to force it to show up via the gallery on my ribbon. Nor is using it. But editing its properties is.
    Maybe I can programmatically remove the gallery from my ribbon, and then add it again. Any better ideas?
    Testing conducted here with Word 14.0.6112.5000 (64 bit).

    DB:2.31:Word Building Blocks: Refreshing Gallery Entries? 3f

    HI Jason
    Thanks for letting us know it worked - and what worked. I was going to suggest changing the Installed property, but I thought, given what you'd already tried, that it wouldn't be enough. Glad to learn it was!Cindy Meister, VSTO/Word MVP

  • RELEVANCY SCORE 2.30

    DB:2.30:Need To Hide Manage Data Refresh Option In Power Pivot Gallery Of Sharepoint pc


    Hi All,

    My requirement is to hide/disable the manage data refresh option in Power pivot gallery. Please let me know if we have any approach to do this.

    Thanks in advance for the help.
    Regards,
    Balaji

    DB:2.30:Need To Hide Manage Data Refresh Option In Power Pivot Gallery Of Sharepoint pc

    Disable or Hide the Refresh Button

    You cannot hide the Manage Data Refresh button. However the button is disabled if the user does not sufficient permissions.

    Workbook owners or authors must have Contribute permission to schedule data refresh on a workbook. Users with Contribute permissions can open and edit the workbook’s data refresh configuration page to specify
    the credentials and schedule information used to refresh the data.
    So, users that only have View or Read permission levels, will not be able to access the refresh button. The refresh button is visible but disabled.

  • RELEVANCY SCORE 2.30

    DB:2.30:Powerview Is Not Refreshing In A Site Which Is Created From Site Template 71


    Hi All,
    I'm new to sharepoint. I have asked to create a site from site template and make the necessary connections to new site.
    I have created a site called MainSite, which contains lists and powerviews. One of the lists has multiple data in a field. So, we have used MSAccess to get a detail report of the data. And then we have loaded data to PowerPivot in Excel2013
    from MSAccess . Then we have loaded this excel file into powerview gallery and created a powerview for the same. We've tested the report by updating/inserting the corresponding lists. Everything works fine. And then we have created this MainSite
    as site as template. Then created a new site called TestSitefrom this site template. I've taken a copy of the accessdb and changed its connection to the lists in TestSite. It is getting updated if
    we manipulate the lists in TestSite. Everything is fine till this. Then I've gone to the Powerview in the TestSite. I've changed the connection of the excel file we have uploaded to the newly created Accessdb(which is connected to the
    list in the TestSIte). No data is getting refreshed in the powerview. we have tried to refresh in the poweview by using Manage data refresh option also. Nothing is working for us. Please suggest.

    Thanks,
    Julie

    DB:2.30:Powerview Is Not Refreshing In A Site Which Is Created From Site Template 71

    Hi Julie,
    How is your thing going? Is there any update for this issue?
    ThanksDaniel Yang
    TechNet Community Support

  • RELEVANCY SCORE 2.30

    DB:2.30:Refresh The Bso Cube zj


    Hi

    How to refresh(Loading data) the BSO Cube from command prompt or using script?

    Thank You,

    Karthi

    DB:2.30:Refresh The Bso Cube zj

    Refresh the BSO CubeBased on this, I am going to guess that this is a cube refresh issue from Planning to Essbase. It was a little confusing.

    You didn't state if you were on 9.3.x or 11x -- the syntax between the two releases is slightly different, with the 11x version requiring an encrypted password file.

    Per the other posts, see:
    9.3.1
    http://download.oracle.com/docs/cd/E10530_01/doc/epm.931/html_hp_admin/ch11s06s01.html
    11x
    http://download.oracle.com/docs/cd/E12825_01/epm.111/hp_admin/ch10s06s01.html

    Regards,

    Cameron Lackpour

  • RELEVANCY SCORE 2.30

    DB:2.30:Excel Data Refresh - Problem With Data Source Configuration xj


    Hi,
    I am trying to refresh Excel spreadsheets using Power BI Gateway, but I am struggling for last couple of days to create a data source. The gateway seems to be working correctly. The Excel is using Power Query getting data from SQL Server 2008 R2, and loads
    it into data model. I go to Power Pivot/Manage/Existing Connections/Advanced and copy the connection string. Then I go Power BI for Office 365, add data source/Power Query and paste the string. I am getting error message:
    Unsupported data source types detected

    The Power Query connection string contains one or more unsupported data source types: {DataSourceKind}. Please refer to the data source support matrix to review the data source types supported from a Power Query connection string.

    DB:2.30:Excel Data Refresh - Problem With Data Source Configuration xj

    While I will look around to see if this limitation is planned to be removed, an option is to use views, of course if you need to create a lot of views that might not be relevant.GALROY

  • RELEVANCY SCORE 2.30

    DB:2.30:Change In Source Database Not Showing Up In The Powerpivot Window f3


    I added a column to the source database in my Powerpivot table. When I refresh the PowePivot window the column is not showing up. What else do I need to do? I'm using Excel 2010.

    DB:2.30:Change In Source Database Not Showing Up In The Powerpivot Window f3

    Doing that will wipe out all my measures. Turns out the problem is related to a known bug in Excel 2010. When I try to turn on a column I get the famous the text file Specification 'x' doen not exist . . . . I will try to run the hotfix
    for it.

  • RELEVANCY SCORE 2.29

    DB:2.29:Apk Data In My Gallery 9c



    i installed Need For Speed Hot Pursuit game on my Xplay... when i checked my gallery, i found the picture from the game's data... can i delete that picture without removing the games?? thanks before...

    DB:2.29:Apk Data In My Gallery 9c


    install file expert from the anroid market..

    after instaling

    search for .nomedia

    there will be many files..

    just copy 1 of them

    ok..

    then go to your games folder.and look for the folder where all those pics are..

    then paste the copied nomedia file in that folder..

    u'll no longer get the game pics in your gallery..

  • RELEVANCY SCORE 2.29

    DB:2.29:Unable To Use Powerpivot With Office Beta mz


    Hello,I have tried every solution that has been posted so far excel reinstalling the operating system which I can not do and I still can not get PowePivot To Load. Please help:Here are the facts:1) Up until last night I had the Tech Prev version of office 2010 along with Gemini installed. It worked fine.2) Last night I manually uninstalled Office 2010 TP and installed Microsof Office Professional Plus 2010 (Beta) version 14.0.4536.1000 (32 bit)3) I uninstalled Gemini and reinstalled powerpivotThe error message I am getting is:Initilization of the data failed.Check the database server or contact your database administrator. Make sure the external database is available, then try the operation again...the message continues. When I click Ok the error message is:The embeded Gemini data is corrupt. Would you like to delete and continue using the workbook.I click ok a few times and the next error message is:Unable to load the Gemini in memory server. Reason: there was a COM exception  While loading...the message continues.The actual details of the error are:============================Error Message:============================
    Exception from HRESULT: 0x800A03EC
    ============================Call Stack:============================
    Server stack trace:
    Exception rethrown at [0]:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData msgData, Int32 type)   at Microsoft.Office.Interop.Excel.OLEDBConnection.Reconnect()   at Microsoft.AnalysisServices.Modeler.FieldList.InProcServer.LoadOLEDBConnection()
    ============================Please help.

    DB:2.29:Unable To Use Powerpivot With Office Beta mz

    Hi,After installing XP SP3 the problem is resolved. It also resolved the problem described here http://social.msdn.microsoft.com/Forums/en-US/sqlkjsetupandupgrade/thread/29286cef-f452-4c3a-ac7d-b1b359ddd366.Thanks,Tiago.

  • RELEVANCY SCORE 2.29

    DB:2.29:Photo Gallery c3



    how do you delete photo's from the photo gallery ?

    DB:2.29:Photo Gallery c3


    Again read your owners manual it will tell you what you want to know.

    Simple way is to long press the photo you want to delete and select "delete"

    You can also click the setting tab in Gallery and do multiple deletes

    Good Luck

  • RELEVANCY SCORE 2.29

    DB:2.29:Send Link To Dps Gallery z3



    Hi,

    How I can send my apple and Android app stores links to DPS Gallery from Adobe.

    Until last Viewer Builder update I could to send from Manage Panel...but now this option vanish.

    Any tip?

    Tks

    DB:2.29:Send Link To Dps Gallery z3


    Hi,

    How I can send my apple and Android app stores links to DPS Gallery from Adobe.

    Until last Viewer Builder update I could to send from Manage Panel...but now this option vanish.

    Any tip?

    Tks

  • RELEVANCY SCORE 2.29

    DB:2.29:Mangage Silverlight View State a7


    I have asp.net page that includes a silverlight controls and another server side controls also its includes submit button, my page shows data or fill data from database to pages controls(silverlight, and asp.net controls) now when the user change the data and click the submit button or refresh the page the Asp.net server side control mantain the data or keep the change data(Manages View State), but the silverlight control lose the changed data, So how can i manage my silverlight contorls to keep thier changed data??

  • RELEVANCY SCORE 2.29

    DB:2.29:Data Refresh Issue With Sql Server 2008 R2 Cu4 91


    I am hoping someone might be able to point me in the right direction regarding an issue I have encountered. In an attempt to solve another PowerPivot issue, we upgraded to SQL Server 2008 R2 CU4 last night. This morning, when I go into my PowerPivot
    gallery and click on Manage Power Pivot Data Refresh, I get the following error in SharePoint:
    An unexpected error has occurred.
    Troubleshoot issues with Microsoft SharePoint Foundation.
    Correlation ID: 8581cc48-2ae0-4bbb-b378-ae3d1f3732ec
    Date and Time: 2/1/2011 11:39:00 AM
    So, I went digging in the SharePoint logs and found the following message:
    Local Analysis Services in VertipaqMode instance version, '10.50.1600.1', does not match bits on machine, '10.50.1746.0'. PowerPivot Setup Extension timer job will be started to correct the problem.
    That kind of makes sense considering the upgrade to CU4. So, I went to Central Admin and checked the PowerPivot Setup Extension Timer Job. It completed sucessfully (several times in fact with all my testing). But, the error is still there.
    Does anyone have an idea of where I might go next to figure this one out? Any assistance would be greatly appreciated.
    -Robert-Robert

    DB:2.29:Data Refresh Issue With Sql Server 2008 R2 Cu4 91

    Mariano,
    We started the Windows Claims Service (not sure if this was a part of the solution) and then did a IISRESET. Now
    Manage Power Pivot Data Refresh works. We are pretty sure it was just the IISRESET.
    Thanks for all your help.-Robert

  • RELEVANCY SCORE 2.29

    DB:2.29:Excel Workbook Using Powerpivot Not Getting Refreshed On Sharepoint Power Pivot Gallery 7z


    Excel workbook using PowerPivot not getting refreshed on SharePoint Power Pivot Gallery.
    The refresh is working but the data is inconsistent every time for different cells at different time.
    Please help

    DB:2.29:Excel Workbook Using Powerpivot Not Getting Refreshed On Sharepoint Power Pivot Gallery 7z


    Hi Swati G,

    The Excel refresh and the PowerPivot refresh are distinct operations. Refreshing in the PowerPivot window pulls data from all of the original sources
    but does NOT refresh the pivots in Excel. Refreshing Excel will make sure that the latest PowerPivot data is reflected in your pivots, but if you want to see new data from your original sources (db's for instance), you need to refresh PowerPivot and then Excel.
    You can refer to this whitepaperhttp://msdn.microsoft.com/en-us/library/ff976569.aspx Similar thread here:http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/thread/0709a288-e22c-4d77-9cc2-274035dd0d9f/

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.29

    DB:2.29:Table Selection &Amp; Refresh sp


    Hi all!

    I've a table that display variable amount of data.
    The rows have a selector (and a view button) to view the detail of the data in another page.

    In page definition, the iterator settings are

    pageDefinition xmlns="http://xmlns.oracle.com/adfm/uimodel"
    version="..." id="..."
    Package="..." EnableTokenValidation="true"

    ...
    methodIterator id="..." Binds="..."
    DataControl="..." RangeSize="10"
    BeanClass="..." Refresh="always"
    CacheResults="false"
    /
    ...

    The (main) code for the selection is

    public String getCurrentCallid() {
    JUCtrlValueBindingRef tableRowRef=(JUCtrlValueBindingRef) this.getOl_table().getRowData();
    return (String) tableRowRef.getRow().getAttribute("callid");
    }

    that return a string that I store in session, that will be used in the next page.

    If the table data doesen't change from the rendering to the change submit, all works fine.

    But, if I select a record that has been deleted from the DB in the meanwhile, the getCurrentCallid() returns me the string of another record (the next one).

    How can I manage the refresh to avoid this problem?

    many thanks!

    DB:2.29:Table Selection &Amp; Refresh sp

    Why don't you use #{row.rowKeyStr} in SetActionListener in the f:facet name="Selection" ?

    or find out current row key in backing bean similar to the following

    ctx = FacesContext.getCurrentInstance;
    currentCallId = ctx.createValueBinding("#{row.CallId}").getValue(ctx);

  • RELEVANCY SCORE 2.29

    DB:2.29:Web Galleries: Retrieving And Transferring Settings / Content jj


    I use multiple LR databases to manage different websites. For each one, I use a few standard Web Gallery templates to create different pages for photos with different themes. When I first created the pages, I entered different information on each page for the Collection Title, Description, etc. I noticed that LR somehow remembered what that information was, pulling up the correct data when I go back later to recreate the web page from the original set of photos! How does it do that? Clearly, this is not part of the image metadata or the Web Gallery template; it seems to be stored elsewhere.

    Unfortunately, the settings do not transfer when exporting the image folder as a catalog. I would like to be able to duplicate them on another LR database. How can I retrieve and transfer these? Any suggestions would be greatly appreciated!

    Thanks,

    Peter

    DB:2.29:Web Galleries: Retrieving And Transferring Settings / Content jj

    I use multiple LR databases to manage different websites. For each one, I use a few standard Web Gallery templates to create different pages for photos with different themes. When I first created the pages, I entered different information on each page for the Collection Title, Description, etc. I noticed that LR somehow remembered what that information was, pulling up the correct data when I go back later to recreate the web page from the original set of photos! How does it do that? Clearly, this is not part of the image metadata or the Web Gallery template; it seems to be stored elsewhere.

    Unfortunately, the settings do not transfer when exporting the image folder as a catalog. I would like to be able to duplicate them on another LR database. How can I retrieve and transfer these? Any suggestions would be greatly appreciated!

    Thanks,

    Peter

  • RELEVANCY SCORE 2.29

    DB:2.29:Work Items Refreshed From Project And Progess Tracking 93


    Hi,
    i'm using MS Project to manage the progress of the plan. The developers and testers update their work items and i refresh the plan regularly.
    Is there a way to preview what has changed since the last time i refreshed? When i refresh, the data is downlaoded from TFS and if there are changes in schedule, it's hard for me t know the cause.
    Thanks
    Francesc

    DB:2.29:Work Items Refreshed From Project And Progess Tracking 93

    Hi Francesc,
        Not yet but wouldn't it be cool if we could get functionality in TFS like Project Server has where I can preview a set of changes (by hitting refresh) and then back them out (automagically) if I don't like them? I'd like that too.
    Cheers,
    Randy

  • RELEVANCY SCORE 2.28

    DB:2.28:Excel 2010 - Pivot Table On Powerpivot Wrong Sorting mp


    I've a problem with a pivot table based on PowePivot (Excel 2010 - PowerPivot v10.50.1600 ).
    The Table has just a list of names and a ranking, something like :
    Name Ranking
    Allowances 5
    V.A.T. 6
    Total Excise 7

    The column is nicely sorted in Powepivot using the Ranking column. However when I create a pivot table the column names is sorted by name (5,7,6). This both in the pivot table columns , rows as well as in the filter. I checked carefully the settings and
    the sort is using 'Data source order'.
    Do I'm missing something ?
    (migrating power pivot or excel is not an option as it's for a corporate customer).

    DB:2.28:Excel 2010 - Pivot Table On Powerpivot Wrong Sorting mp

    im afraid you are right
    as far as i knw the sorting was introduced with PowerPivot v2- www.pmOne.com -

  • RELEVANCY SCORE 2.28

    DB:2.28:Picture Gallery Refresh fm



    Is there a way to refresh the picture gallery without rebooting?

    I moved a few pictures around trying to consolidate folders in the picture gallery and they aren't showing in the gallery. The files are definitely there but the gallery isn't refreshing and I don't see any way to refresh it manually.

    DB:2.28:Picture Gallery Refresh fm


    I found elsewhere that there is an app called sdrescan that will rescan the contents of your SD card. It will refresh the gallery.

  • RELEVANCY SCORE 2.28

    DB:2.28:Sharepoint Power Pivot Gallery - The Following Connections Fails To Refresh: Power Pivot Data 79


    Hi
    I am getting following error when trying to refresh the data in an excel(having power pivot data) uploaded in a Share point 2010 power pivot gallery.
    The data connection uses windows authentication and user credentials could not be delegated. The following connections fails to refresh: Power Pivot Data
    Tried few solutions like the one given below, without much help.
    http://msdn.microsoft.com/en-us/library/ff487975.aspx
    Thanks and Regards,
    Manjunathmanjunath

    DB:2.28:Sharepoint Power Pivot Gallery - The Following Connections Fails To Refresh: Power Pivot Data 79

    Not sure exactly why that is happening,you could trygoing throughthe steps detailed
    here toensure everything is properly configured:

    Kind Regards Bjoern
    http://spviking.com

  • RELEVANCY SCORE 2.28

    DB:2.28:Manual Data Refresh In Power Pivot Is Not Working (Sharepoint 2010) 7f


    Hello
    I am using SharePoint 2010 Environment and I am facing issue in the power pivot Data refresh.
    When I set a schedule for the Excel sheet in the power pivot gallery it gets refreshed according to the schedule but when I try to refresh the sheet in the gallery manually nothing happen.

    I click the Refresh all connections button in the web version of excel sheet in the power pivot gallery but no new data is pulled while it works when schedule is set.

    DB:2.28:Manual Data Refresh In Power Pivot Is Not Working (Sharepoint 2010) 7f

    did you see any error in ULS logs or event logs?Thanks -WS SharePoint administrator, MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog *Please remember to mark your question as answered & Vote helpful,if this solves/helps your problem.*

  • RELEVANCY SCORE 2.28

    DB:2.28:Are Calculated Columns Compressed In A Powerpivot Model? s8


    Hi all,
    I am optimizing a PowerPivot model (in Excel) and I found that removing all calculated columns made a big difference on performance. Does any body know if the results of calculated columns are also compressed (and persisted) with the data imported from external
    sources?
    As per the behaviour of PowePivot for Excel I would say that values are calculated, compressed and saved with the rest of the model's data. Yesterday talking with a mate we said that calculated columns were not compressed. I would like to know I bit more
    about it.
    Thanks,
    Ben

    DB:2.28:Are Calculated Columns Compressed In A Powerpivot Model? s8

    Based on your description of the slow refresh time, it sounds like you are performing either an incredible amount or incredibly complex calculations in your calculated columns. Note that the complexity here must be considered from a DAX point of view - what
    may seem simple at first glance can actually be very inefficient when implemented in the Tabular engine as opposed to a relational database or an ETL tool.
    My suggestion would be to perform all the transformations and calculated column calculations on your database server, creating physical tables that can be read by your model, rather than depending on your analysis tool to do this work. Personally, when I
    work with Tabular/Power Pivot, I strive to have no calculated columns whatsoever in my model. Beyond avoiding problems like you are seeing, it also allows for better re-use of data. If anyone wants to use my datasource, they can get all of the data structure
    and all of the data from one place.
    Edit: As an example of something I would see as a good idea to use a calculated column for, I'd suggest finding the last sales date for a given product, or today, yesterday, this month flags in a date dimension (if that's
    how you wish to implement these elements of date logic). These are very specific to the context of the refresh time.
    Anything like a lookup, or concatenation, or other transformations belong in the database or an ETL tool.
    A final thought, based on Michael's post above it may be a significant savings to implement alternative versions of your calculated columns as measures instead where possible.

  • RELEVANCY SCORE 2.28

    DB:2.28:Programmatically Create A Powerpivot Data Refresh Job In Sharepoint xx


    Hello, and thank you for reading my post.
    I am using power pivot to consume list data exposed by the newSharePoint 2010 list data services. The requirements I am dealing with though mandate that I provide the ability to refresh power pivot workbooks on demand.
    From my understanding OOTB PowerPivot for SharePointdoes not provide this ability. At the most frequent, data refresh jobs can be configured to run on a daily basis.
    I doknow however, that it is possible to schedule a job on thefly, because there is thatcheckbox on the manage schedule page which allows a job to be set up immediately.
    I did a little digging and I've found this function call -

    script language=javascript
    var _GeminiDataRefresh = new GeminiDataRefresh(ctl00_PlaceHolderMain_ctl02_cbEnableRefresh, ctl00_PlaceHolderMain_ctl03_cbRunNow, ctl00_PlaceHolderMain_ctl03_lblRunNow, ctl00_PlaceHolderMain_ctl05_peEmailUserName, ctl00_PlaceHolderMain_ctl06_rbUseUnattendedAccount, ctl00_PlaceHolderMain_ctl06_rbUseCustomAccount, ctl00_PlaceHolderMain_ctl06_tblUserCredentials, ctl00_PlaceHolderMain_ctl06_txtUserName, ctl00_PlaceHolderMain_ctl06_txtPassword, ctl00_PlaceHolderMain_ctl06_txtConfirmPassword, ctl00_PlaceHolderMain_ctl06_rbUsePredefinedApplication, ctl00_PlaceHolderMain_ctl06_tblPredefinedApplication, ctl00_PlaceHolderMain_ctl06_txtSecureStoreApplicationID, ctl00_PlaceHolderMain_DataSourceSection_cbAllDataSources, ctl00_PlaceHolderMain_ctl03_DefaultSchedule, ctl00_PlaceHolderMain_ctl04_DefaultStartTimeSelector);
    /script

    DB:2.28:Programmatically Create A Powerpivot Data Refresh Job In Sharepoint xx

    Hello, I have had some success using this project: http://forcepowerpivotrefre.codeplex.com/.

    Once I implemented the code in the project (with modifications to fit my needs) I had to set the refresh on the document to daily and 12:00 am as the earliest refresh time. Then, whenever I execute the code the refresh occurs on demand. That's
    the only catch, then. It appears that when the .exe runs, SharePoint sets precedence on the schedule first. If the schedule is valid when compared against the .exe run time, SharePoint will refresh the model.

    Note one last thing: I experienced at LEAST a 30 second delay between the program execution and the refresh occurring.

  • RELEVANCY SCORE 2.28

    DB:2.28:Create An Manage Photo Album x7


    I've removed unwanted photo albums from my gallery but I want to create photo albums of my little boys so my photos aren't such a mess. Any ideas anyone?

    DB:2.28:Create An Manage Photo Album x7


    You could try this

    use a File Manager or on your computer create a folder on your SD card call it anything you want then on your Xperia

    Album albums SD card you should be able to see the folder

    Don't forget to give Kudos





    "I'd rather be hated for who I am, than loved for who I am not." Kurt Cobain (1967-1994)

  • RELEVANCY SCORE 2.28

    DB:2.28:Powerpivot For Sharepoint - After Updates, Can No Longer Refresh Data - Powerpivot Configuration Tool Fails 8j


    Hi there,
    I have a SharePoint 2010 Server with SQL 2012 PowerPivot for SharePoint installed. All was working fine until a round of Windows updates which included SQL 2012 SP1. After that SharePoint Health Analyzer was reporting the following:

    The SharePoint Health Analyzer detected an error. PowerPivot: PowerPivot: The deployed farm solution is not up-to-date.
    PowerPivot: The deployed farm solution is not up-to-date.
    PowerPivot: Make sure that farm solution is up-to-date. For more information about this rule, see http://go.microsoft.com/fwlink/?LinkID=208180
    I then ran the PowerPivot Configuration Tool which said that Newer versions of the Powerpivot solution files have been detected. Please select the upgrade option to upgrade your farm. I clicked ok and ran the Upgrade Features. I clicked
    Validate and then Run. The tasks fail at Update PowerPivot Assembly Information with the following error:
    Upgrade Solution File and Assembly Information Update PowerPivot Assembly Information Failure while running action: Update PowePivot ASsembly Information Set-PowerPivotSystemService : Microsoft SharePoint is not supported with version 4.0.30319.296
    of the Microsoft .Net Runtime.
    I found and followed this article:
    http://blogs.technet.com/b/mspfe/archive/2012/09/06/sharepoint-2010-management-shell-net-4-0-runtime-version-error.aspx
    I looked up this error and found that my PowerShell was indeed running 3 0 -1 -1.

    I'm not sure how to get these powershell scripts to run correctly using the configurator.
    Currently none of our PowerPivot workbooks are able to refresh data.
    Thank you,
    Shawn

    Shawn Fletcher

    DB:2.28:Powerpivot For Sharepoint - After Updates, Can No Longer Refresh Data - Powerpivot Configuration Tool Fails 8j

    Hi Jarrod,
    I never did find an answer unfortunately. It was a development site and we decided to scrap it and start a new one with SharePoint 2013.
    Good luck!
    ShawnShawn Fletcher

  • RELEVANCY SCORE 2.28

    DB:2.28:Sharepoint Powerpivot Manage Data Refresh: Unspecified Error pk


    Hi All,
    I uploaded the powerpivot to sharepoint gallery and tried to do refresh. I have given windows credentials for the refresh.
    I configured/installed everything as per the blog
    http://powerpivotgeek.com/2010/08/18/working-with-the-2010-office-ace-provider/
    still it is showing below errors..
    06/22/2012 14:49:34.69 w3wp.exe (0x13B8) 0x2608SSAS Mid-Tier Service
    Data Refresh 99High EXCEPTION: Microsoft.AnalysisServices.OperationException: OLE DB or ODBC error: Unspecified
    error. A connection could not be made to the data source with the DataSourceID of 'a8aca1f4-f683-40ce-ae63-f971c9b8d098', Name of 'Excel NodeAdjustmentValue'. An error occurred while processing the 'Adjustments' table. The operation has been cancelled.
    at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError) at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject
    obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact, XmlaWarningCollection warnings) at Microsoft.AnalysisServices.Se...

    DB:2.28:Sharepoint Powerpivot Manage Data Refresh: Unspecified Error pk

    I have a source excel file in sharepoint libray. the conenction between powerpivot workbook and source excel is using UNC(webdav).
    Though I have all permissions I am getting below error.

    OLE DB or ODBC error: The Microsoft Access database engine cannot open or write to the file '\\sharepoint servname\DavWWWRoot\SPowerpivotgallery\excel.xlsx. It is already opened exclusively by another user, or you need permission to view and write its data.;
    3051. A connection could not be made to the data source with the DataSourceID of 'a8aca1f4-f683-40ce-ae63-f971c9b8d098', Name of 'Excel. An error occurred while processing the 'Adjustments' table. The operation has been cancelled.

  • RELEVANCY SCORE 2.28

    DB:2.28:Hide Workbook From Power Bi Gallery s3


    How can I enable a workbook for Power BI refresh but prevent it from being displayed in the Power BI gallery? Alternatively, how can I prevent certain users from viewing the Power BI gallery entirely (even if they have permissions on a specific workbook)?
    Here is some background on why I need to do this:
    I have the requirement to implement data-level security for a sales team. Since Power BI does not yet have this, I managed to achieve what I needed by creating a web part page to expose the workbook sheet with the dashboard. I then set a hidden slicer by
    using the Current User Filter Web Part which filter's the data set to only that sale person's data. This is a decent workaround EXCEPT the user can still click on the Power BI link and get to the report that way which no longer takes into account
    the sales rep filter. I need to either a) prevent them from getting to the Power BI gallery at all or b) hide certain workbooks from appearing in the gallery.
    Please tell me this is possible!

    DB:2.28:Hide Workbook From Power Bi Gallery s3

    For Power BI Gallery, you mean the Power BI site on O365, right?
    In that case, sign in, and you'll see the feedback option.
    Thanks!Ed Price, Azure & Power BI Customer Program Manager (Blog,
    Small Basic,
    Wiki Ninjas,
    Wiki)

    Answer an interesting question?
    Create a wiki article about it!

  • RELEVANCY SCORE 2.28

    DB:2.28:How To Remove Fb Photos From Gallery ? 3m



    I was wondering is there a way to remove FB photos from my gallery ? I dont like the there and they slow my phone down when i enter gallery ? I have tried to Clear Data from Facebook App, and to stop synching FB with my phone but neither helps ? Anyway to remove them ?







    Solved!
    Go to Solution.

    DB:2.28:How To Remove Fb Photos From Gallery ? 3m


    Anytime

    Don't forget to mark the Correct Answers Helpful Answers





    "I'd rather be hated for who I am, than loved for who I am not." Kurt Cobain (1967-1994)

  • RELEVANCY SCORE 2.28

    DB:2.28:Power Pivot Data Refresh In Sharepoint 2010 Fails fk


    Hi ,
    I have a excel workbook with power pivot tables which reads data from SQL database. SQL authentication is used and while creating a data connection in the power pivot window Save my password option was selected. When this excel was uploaded to sharepoint
    power pivot gallery and data refresh was scheduled everything works fine. I was able to get the recent data upon data refresh.
    But my client does not want to save password while creating a data connection in the power pivot window. In this case, while scheduling the data refresh, I usedthe specify user account option under data source section.

    But data refresh failed with below error.
    OLE DB or ODBC error: Login failed for user 'sql login id'.; 42000. A connection could not be made to the data source with the DataSourceID of 'fd359467-7ea5-4c25-8572-f82098c01af0', Name of 'SqlServerSQL server nameTestPowerPivot'. An error
    occurred while processing the 'tablename' table. The operation has been cancelled
    This sql login id has access to the SQL database and is able to insert rows in to the table.
    Is it required that the password is always saved while creating a data connection in the excel? Please let me know if I m doing it in a wrong way.
    Thanks in Advance,
    Sweshsweshd

    DB:2.28:Power Pivot Data Refresh In Sharepoint 2010 Fails fk

    1. You should also Check that if your web-client services is installed on the server where
    SQL Analysis Services is enabled.
    2.
    The SQL Server Analysis Services (PowerPivot) service account information that is managed by the SQL Server Configuration Manager
    should be same and configured in Central Admin as the service account for power pivot data refresh.
    Let me know if that helps.
    Thanks

  • RELEVANCY SCORE 2.28

    DB:2.28:Data Refresh Feature Of Excel Services And Powerpivot Data Refresh Issues 3c


    I am having issue getting the data refresh feature work from the excel workbook in the PowerPivot Gallery. I have configured the unattended Data refresh account and I set the authetication type to none in the excel workbook. The excel services application
    pool account has contribute to the sharepoint site and the unattended refresh acount is the farm account which has read permission to the SSAS external data source. initially if I upload to the powerpivot gallery I am able to refresh but after a while , I
    get this error
    Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator
    But the schedule PowerPivot Data Refresh is working fine. The credential property is set to use the data refresh account set by the administrator and the data source property is set to use use the credential contained in the workbook.
    I nedd help on how to get the data refresh work from the excel workbook in the powerpivot gallery.

    Thanks
    BI Developer

    DB:2.28:Data Refresh Feature Of Excel Services And Powerpivot Data Refresh Issues 3c

    Hi Abioye,
    Excel Services cannot connect to or load the PowerPivot data. Conditions that cause this error to occur include the following:
    Scenario 1: Service is not started
    The SQL Server Analysis Services (PowerPivot) instance is not started. An expired password will cause the service to stop running. For more information about changing the password, seeConfigure
    PowerPivot Service AccountsandStart or Stop a PowerPivot for SharePoint Server.
    Scenario 2a: Opening an earlier version workbook n the server
    The workbook you are attempting to open might have been created in the SQL Server 2008 R2 version of PowerPivot for Excel. Most likely, the Analysis Services data provider that is specified in the data connection string is not present
    on the computer that is handling the request.
    If this is the case, you will find this message in the ULS log: “Refresh failed for ‘PowerPivot Data’ in the workbook ‘URL to workbook’”, followed by “Unable to get a connection”.
    To determine the version of the workbook, open it in Excel and check which data provider is specified in the connection string. A SQL Server 2008 R2 workbook uses MSOLAP.4 as its data provider.
    To work around this issue, you can upgrade the workbook. Alternatively, you can install client libraries from the SQL Server 2008 R2 version of Analysis Services on the physical computers running PowerPivot for SharePoint or Excel
    Services:
    Upgrade PowerPivot for Excel and PowerPivot Data
    Install the Analysis Services OLE DB Provider on SharePoint Servers
    Scenario 2b: Excel Services is running on an application server that has the wrong version of the client libraries
    By default, SharePoint Server 2010 installs the SQL Server 2008 version of the Analysis Services OLE DB provider on application servers that run Excel Services. In a farm that supports PowerPivot data access, all physical servers
    running applications that request PowerPivot data, such as Excel Services and PowerPivot for SharePoint, must use a later version of the data provider.
    Servers that run PowerPivot for SharePoint get the updated OLE DB data provider automatically. Other servers, such as those running a standalone instance Excel Services without PowerPivot for SharePoint on the same computer, must
    be patched to use the newer client libraries. For more information, seeInstall the Analysis Services OLE DB Provider on SharePoint
    Servers.
    Scenario 3: Domain controller is unavailable
    The cause might be that a domain controller is not available to validate the user identity. A domain controller is required by the Claims to Windows Token Service to authenticate the SharePoint user on each connection. The Claims
    to Windows Token Service does not use cached credentials. It validates the user identity for each connection.
    You can confirm the cause of this error by viewing the SharePoint log file. If the SharePoint logs include the message Failed to get WindowsIdentity from IClaimsIdentity, the user identity could not be authenticated.
    To work around this problem, join the computer to the same domain as the PowerPivot server, or install a domain controller on your local computer. The second solution, installing the domain controller, will require you to create
    local domain accounts for all services and users. You will need to configure service accounts and SharePoint permissions for the accounts you define.
    Installing a domain controller on your computer is useful if your objective is to use PowerPivot for SharePoint in an offline state. For detailed instructions on how to use PowerPivot offline, see the blog entry for Taking your
    PowerPivot server off the network onhttp://www.powerpivotgeek.com.
    Scenario 4: Unstable server
    One or more services might be in an inconsistent state. In some cases, running IISRESET will resolve the problem.
    For more information, please refer to the following links(please read them carefully):
    http://msdn.microsoft.com/en-us/library/ff487856.aspx
    http://sqlserverpedia.com/blog/sql-server-bloggers/sharepoint-and-powerpivot-connections-fail-to-refresh-in-sql-server-2008-denali-ctp3/
    http://powerpivotgeek.com/2010/02/08/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated/
    http://weblogs.asp.net/coltk/archive/2009/08/17/data-refresh-failed-in-excel-services.aspx

    Thanks,
    Lhan Han

  • RELEVANCY SCORE 2.27

    DB:2.27:Power Pivot : Data Model Not Getting Refreshed When New Rows Added In The Excel Sheet kc


    Hello,
    I have created the Power Pivot Chart from the data in the Excel Sheet of the same Excel file.
    When I am adding new Rows to the Excel sheet data, it is not getting updated in the Data Model.
    I tried Update, Update All on Data tab.
    Also I tried Refresh, Refresh all on Manage Data Model window. When I do refresh all, it shows the all the pivot tables in the data model are getting refreshed but the same no of rows. Not adding up the new ones.

    How can I refresh my datamodel in this case now ?
    Please suggest.
    Thank you,
    Mittal.

    DB:2.27:Power Pivot : Data Model Not Getting Refreshed When New Rows Added In The Excel Sheet kc

    I think you should follow steps:
    1- check if rows are added to link table. Example:

    Table 1.

    COUNTRY

    CROATIA

    CZECH REPUBLIC

    HUNGARY

    POLAND

    ROMANIA

    SLOVAKIA (SLOVAK REPUBLIC)

    USA
    row not added to linked table

    GERMANY
    row not added to linked table

    Table.2

    COUNTRY

    CROATIA

    CZECH REPUBLIC

    HUNGARY

    POLAND

    ROMANIA

    SLOVAKIA (SLOVAK REPUBLIC)

    USA
    row added to link table

    GERMANY
    row added to link table

    2- if rows are added refresh data in model. Click refresh from PP menu. If not, drag bottom right corner of the data table to expand selection on new rows

    3. Refresh pivot table as a data for your chart
    Gordonik

  • RELEVANCY SCORE 2.27

    DB:2.27:Power Pivot 2013 Using Sharepoint 2013 List As Source Data j3


    Background: On a SharePoint 2013 site, there are lists that have the exact same columns but due to their size I had to create a different list for each year.
    These are essentially my data lists or tables that end users enter data into. These lists have look up columns in them, referencing columns from look up lists or tables located on the same site.

    Goals:
    1) Create a Power Pivot Gallery on SharePoint 2013 that is able to leverage the manage data refresh feature using the SharePoint 2013 List data that is on the same SharePoint 2013 site.
    2) Combine all the data lists/tables into one table once in Power Pivot 2013. The Look Up lists/tables will remain separate.

    Challenge: Being able to merge or do a union query to the data lists and still maintain the ability to leverage the manage data refresh feature.
    This is a tactical, quick fix solution, and I
    cannot use SQL Server and am operating under the assumption that I do not have Access Services 2013 as an option.

    Failed Attempt #1: What I already tried was linking the lists to an Access 2013 database and did a Union query from Power Pivot which merged the data from the different data tables
    as I wanted it to. Then I uploaded that Access Database to a document library on that same site, thinking that I could maintain the ability to leverage the manage data refresh feature but I was wrong.

    Any thoughts or suggestions?
    Thanks in advance for any help!

    Cheers, Johnny

    Johnny

    DB:2.27:Power Pivot 2013 Using Sharepoint 2013 List As Source Data j3

    Hi Johnny,
    Does the link above solve your issue? If the issue persists, please post the detail information about your issue, so that we can make further analysis.
    Regards,
    Katherine XiongKatherine Xiong
    TechNet Community Support

  • RELEVANCY SCORE 2.27

    DB:2.27:Form Hangs In Vb.Net fk


    Hi,

    This is my Image of the project
    http://img822.imageshack.us/i/82050238.png/
    It is a USB data acquisition project ,which gets temperature value from the board.
    It works fine on starting but after some time, i can't scroll the trackbar in realtime means that it is taking long time to scroll and the temperature value from the board is not updated to gauges.
    To avoid that i tried using refresh like below ,but no use
    TextBox1.Update()
    TextBox2.Update()
    TextBox3.Update()
    TextBox4.Update()
    TextBox5.Update()
    TextBox6.Update()

    TextBox7.Update()
    TextBox8.Update()
    TextBox9.Update()
    TextBox10.Update()
    TextBox11.Update()
    TextBox12.Update()

    TextBox14.Update()
    TextBox15.Update()
    LbAnalogMeter1.Refresh()
    LbAnalogMeter2.Refresh()
    LbDigitalMeter1.Refresh()
    LbAnalogMeter2.Refresh()
    GroupBox1.Refresh()
    GroupBox2.Refresh()
    GroupBox3.Refresh()
    GroupBox22.Refresh()
    GroupBox5.Refresh()
    GroupBox6.Refresh()
    GroupBox7.Refresh()
    GroupBox8.Refresh()
    GroupBox4.Refresh()
    GroupBox10.Refresh()

    TextBox1.Refresh()
    TextBox2.Refresh()
    TextBox3.Refresh()
    TextBox4.Refresh()
    TextBox5.Refresh()
    TextBox6.Refresh()

    TextBox7.Refresh()
    TextBox8.Refresh()
    TextBox9.Refresh()
    TextBox10.Refresh()
    TextBox11.Refresh()
    TextBox12.Refresh()

    TextBox14.Refresh()
    TextBox15.Refresh()

    TrackBar1.Refresh()
    TrackBar2.Refresh()
    TrackBar3.Refresh()
    TrackBar4.Refresh()
    TrackBar5.Refresh()
    TrackBar6.Refresh()

    TrackBar7.Refresh()
    TrackBar8.Refresh()
    TrackBar9.Refresh()
    TrackBar10.Refresh()
    TrackBar11.Refresh()
    TrackBar12.Refresh()

    TrackBar14.Refresh()
    TrackBar15.Refresh()

    Refresh()
    Please help me to solve the problem

    Thankyou

    DB:2.27:Form Hangs In Vb.Net fk

    Hi Cor, Thanks for the great tip.I found the problem is due to the large code executing on Timer1.I have made the code more efficient and made it very small.Now my form works great. Thank youThankyou