Unable to refresh PowerPivot data in SharePoint 2010/SQL Server 2012


here goes: upload excel spreadsheet powerpivot table sharepoint 2010.  spreadsheet displays fine until try set filter.  have read every thread find on issue , far none of them seem work.  stunningly difficult problem wouldn't surprised if has wasted million or more man-hours point.  @ least microsoft should publish decent checklist.  anyway based upon have read have identified following trouble spots far.  feel free add them.  have standalone windows 2008r2/sharepoint 2010/sql server 2012/office 2013 system.
starters excel powerpivot app works fine on server outside of sharepoint.

created account (call fred)
    1. domain account
        1a. read permission on active directory
    2. local admin on server
    2a. user rights assigned
        2a1. act part of operating system
        2a2. adjust memory quotas process
        2a3. impersonate client after authentication
        2a4. log on service
    3. sysadmin on sql server (one assume has rights databases)
        for masochists among there seem half-dozen of 20-something databases require @ least read-access if want list them.

    4. farm admin on sharepoint farm - fred
    5. admin rights ssas - fred
        5a. powerpivot instance - fred
    6. account used web application - fred
    7. account used unattended powerpivot account - fred
    8. secure store service key - check
        8a. add fred ss administrators - check
    9. sss impersonation account (group type) - call ssfred
        9a. credentials - fred
        9b. permissions admin - fred , everybody
    10. olap service running
    11. olap database exists
    12. claims windows token service - both fred , local system account, neither works
    13. powerpivot unattended data refresh account - ssfred
    14. excel services application id: ssfred
        14a. file access method - both impersonation , process account
        14b. trusted file locations (site)
            14b1. children trusted
            14b2. trusted data connection libraries , embedded
            14b3. user defined function allowed
    15. connection excel spreadsheet
        15a. impersonation - ssfred , windows - neither works
    16. trusted data providers
        16a. molap driver trusted - check
    17. disableloopbackup added registry (set 1)
    18. administrator powerpivot service application - fred


based upon either-or configuration, figure there 32 billion permutations account for.  making matters worse recommendation restart service/computer in order see changes work in number of instances.  far have invested few days problem no success see pretty daunting challenge variables mentioned above.

does know of consolidated spreadsheet troubleshooting because simple mind take.

just followup, @ least got excel services run, after finding out ssas database being deleted arbitrarily out there.  gee, guess have never thought of that.

    19. ssas database may disappear @ random - need check

still no powerpivot though.

kevin mccarty

hi kevin,

i think briefly mentioned tokens , want make sure understand... running claims based authentication or of webapps, if powerpivot, tabular, , multidimensional not work, if don't app store not work. when using excel 2013 powerpivot need make sure not using msolap5 , in fact not supported. lot has changed in bi space between 2010 release , 2013 release. tabular , powerpivot architecture different. please me favor perform same exercise excel 2010 client , please let know if works you...

client , server upgrade path data models

-ivan

ivan sanders my linkedin , my blog, @iasanders, bi in sp2013, sp2013 content packs.



SQL Server  >  SQL Server PowerPivot for SharePoint



Comments

Post a Comment

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Image
hi, i have situation want color label on vertical axis of graph depending on condition. when values positive color black , when negative color red. i tried following condition but not working.   =iif(fields!myfield.value < 0 , "red", "black") i know there few threads mentioning feature not supported in ssrs 2008 wanted know if adddressed in ssrs 2012 or later? thanks , regards, oliver d'mello hi oliver, according description, want use expression specify different color axis labels based on values in chart. as tested in our environment, when apply condition in expression give dynamic color axis labels, color setting applies labels based on condition. issue happens in both sql server 2012 , 2014. please refer screenshots below: in scenario, recommend submit issue microsoft connect @ link https://connect.microsoft.com/sqlserver/feedback . connect site serve connecting point between , microsoft, , large community , microsoft intera
Read more

Register with Power BI failed

hi all, i've running local report server , want configure power bi integration. sign in azure active directory , registering power bi clientapp validated, fails following error: microsoft.reportingservices.wmiprovider.wmiproviderexception: unknown error has occurred in wmi provider. error code 80131500  ---> system.exception: exception of type 'system.exception' thrown.    --- end of inner exception stack trace ---    at microsoft.reportingservices.wmiprovider.rswmiadmin.throwonerror(managementbaseobject mo)    at microsoft.reportingservices.wmiprovider.rswmiadmin.savepowerbiinformation(string clientid, string clientsecret, string appobjectid, string tenantname, string tenantid, string resourceurl, string authurl, string tokenurl, string redirecturls)    at reportservicesconfigui.wmiprovider.rsreportserveradmin.savepowerbiinformation(powerbiappconfiguration appconfig) i tried sql server agent solution  ( https://social.msdn.microsoft.com/forums/en-us/58
Read more

SQL server replication error Cannot find the dbo or user defined function........

hi there, i ran problem while deploying sql 2008 transactional replication between 2 servers lets assume server , b. actually created  both distributor , publisher on server , after created subscriber pointed server b, launch replication monitor , found big red cross. when click on tab "distributor subscriber history" error says "cannot find either column "dbo" or user defined-function or aggregate "dbo.ufnleadingzeros", or name ambiguous". can body regarding issue. regards, ishuv hi, you need compare data , others reseved, index size, unused should not compared. differs. here server - data - 87896 kb server b - data - 78152 kb server data size includes publication tables, can't compare directly. need check article article know exact data size. SQL Server  > 
Read more