Feeds:
Posts
Comments

Posts Tagged ‘FAQ’

Can I access PowerPivot via a data access API?

Posted in PowerPivot, tagged , , , on October 27, 2010 | 2 Comments »

I recently got asked the question: Does PowerPivot have any data access APIs? Is there any way to to programmatically access the data store?   I figured that a lot of people will eventually ask this question (heck, that’s what I had asked when I had first heard about PowerPivot).  The answer as of 2010 [...]

Read Full Post »

PowerPivot, you are so insensitive! (case that is)

Posted in PowerPivot, tagged , , , on June 18, 2010 | 11 Comments »

Working with my compatriots Ayad Shammout (@aashammout) and Peter Myers, we had found out that PowerPivot at times can be really insensitive…in terms of case that is.  That is by default, the collation for PowerPivot is case-insensitive. For example, if you import the table below: Within the PowerPivot window, you’ll notice that the lower case [...]

Read Full Post »

Delegation, Claims, Active Directory….Again?! Frak!

Posted in PowerPivot, tagged , , , on May 23, 2010 | 1 Comment »

As you may have noted in my original posting Delegation, Claims, Active Directory…Oh My!…Aw Crap!, it quickly described how to solve issues surrounding the delegation of the claims token within an Active Directory environment.  In it I referenced Lee Graber’s excellent posting: The data connection uses Windows Authentication and user credentials could not be delegated. [...]

Read Full Post »

Delegation, Claims, Active Directory…Oh My!…Aw Crap!

Posted in PowerPivot, SharePoint, tagged , , , , , , on April 8, 2010 | 8 Comments »

Heads up, this posting’s title was “User credentials could not be delegated and Active Directory” but I realized I needed a title that evoked my emotional state  Do not fret or worry, this is not “yet another user credentials delegation” blog. After all, there are already the postings including Troubleshooting #PowerPivot Excel Services connectivity (written [...]

Read Full Post »

Ramblings about missing time … and #PowerPivot sneak peek!

Posted in PowerPivot, tagged , , , , , , , , on April 5, 2010 | 4 Comments »

Wow, I just checked and its been more than a month since I did my last blog post!  So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But [...]

Read Full Post »

PowerPivot for SharePoint Quick tip: Don’t forget to install Desktop Experience

Posted in PowerPivot, SharePoint, tagged on February 17, 2010 | 1 Comment »

For those of you who are using Windows 7 client, you should be good-to-go already because you already have Desktop Experience installed.  But if you are using a Windows Server  OS (e.g. Windows Server 2008, Windows Server 2008 R2), you will need to install it as part of an additional feature via the Server Manager. [...]

Read Full Post »

How do I get the menu options for individual reports within the #PowerPivot Gallery?

Posted in PowerPivot, tagged , on January 15, 2010 | 1 Comment »

When you start playing with the PowerPivot Gallery, some of you will be enamored by the various views of the Silverlight control included as part of the PowerPivot Gallery – I know I was! But if I want to modify or view the properties of the individual report – how do I do this?  Well, [...]

Read Full Post »

The Great #PowerPivot FAQ is now accepting applications

Posted in PowerPivot, tagged on January 9, 2010 | Leave a Comment »

Just in case you didn’t already know from the tweets, I figured I’d also give a shout out (again) to the “Great PowerPivot FAQ” and note the fact that it is now accepting applications for moderators.  To become a moderator – is it a trial by fire?  Does one need to know how to unlock [...]

Read Full Post »

Follow

Get every new post delivered to your Inbox.

Join 1,049 other followers