PowerPivot beginner journey 2

I was exploring the data, and found lots of interesting info from my data set. But I could not find how to join some tables in PowerPivot, and after looking at the source data – it turned out my source data used GUID columns, stored as binary, for row IDs – and PowerPivot silently hid it. I would expect it at least…

0

Undocumented PowerPivot installation requirement

Trying to use PowerPivot, just found undocumented PowerPivot installation requirement: Excel .NET Programmability Support. If PowerPivot silently fails to load, and in Event Viewer you’ve got an event like below, run Office Setup / Add or Remove Features, then check .NET Programmability Support under Microsoft Excel. Here is the event you might find in event…

0