netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • [Client-side Workaround] SharePoint 2010 Excel Services cannot Automatically Refresh Data when using SharePoint Lists as a Data Source

    Apr 6, 2012 · 4 min read  ·
    Share on:

    So far as I can tell, Excel Services is not capable of automatic data refreshes when using SharePoint Lists as a data source. If you're looking for this functionality, you have two choices: PowerPivot (best) or scheduled client-side data refreshing (ghetto). In order for Excel Services to communicate with other data …


    Read More
  • SharePoint 2010: Creating Dashboards and Charts for SharePoint Lists using PerformancePoint and Excel Services from Start to Finish

    Mar 14, 2012 · 6 min read  ·
    Share on:

    I really thought making SharePoint Lists into pretty graphs and charts in SharePoint would be far more straightforward than it's turned out to be. Recently, I was given a project where I had to do just that and while I read through about 30 SharePoint BI books, none really gave a straight answer on which of the various …


    Read More
  • [Solved] Annoying Scrollbars in Excel Web Access Web Parts and PerformancePoint w/ Excel Services

    Mar 13, 2012 · 1 min read  ·
    Share on:

    Recently, while using Excel Services to access PivotCharts and PivotTables within Excel Web Viewer Web Parts and PerformancePart Dashboards, I encountered vertical and horizontal scrollbars that would not go away, no matter how much I tried resizing. god don't like ugly To accomplish the above, you have to do two …


    Read More
  • [SOLVED] PowerPivot for SharePoint 2010: An error occurred connecting to this data source.

    Mar 7, 2012 · 4 min read  ·
    Share on:

    I'm currently working on a project where I need to quickly make pretty graphs and charts for data in small but important SharePoint lists. After looking through a number of books and consulting with my SharePoint buddies, PowerPivot for SharePoint 2010 seems to be the best tool for the job. Getting it to work hasn't …


    Read More

Chrissy LeMaire

SQL & PowerShell MVP. GitHub Star. Creator of dbatools. Need to oil my knees.

dbatools book

Now available in bookstores and amazon 🥳 Buy it at manning.com for 50% off with code bldbatools50

dbatools

dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command, plus a whole lot more.

available from dbatools.io and github

dbachecks

dbachecks validates SQL Server environments using crowdsourced DBA checklists and outputs to Power BI and is available on github.com 📊

Find me

Find me on Mastodon

recent posts

  • New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider
  • What's new and different in dbatools 2.0
  • Don't waste your time with ($PSEdition -eq 'Core') in your PowerShell module manifest/psd1
  • Exploring faster PowerShell import times.. again
  • You just joined Mastodon, now what?
  • Using GitHub Pages to Setup an Alias on Mastodon
  • Aliases on Mastodon: Add me! I'm also [email protected]
  • Moving to Mastodon: I actually like it better (Updated!)

categories

sql-server 119 powershell 113 general 63 security 59 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple24 asp-net2 bi4 db24 exchange7 general63 github7 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell113 security59 sharepoint41 sql-server119 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved