List of "My Sites" with SharePoint 2013

I have constructed a query which returns all site collections and webs. This query is then transformed  into a tree and used to display a list of all sites a user have access to.

The query was not returning all items from the index. If I searched for the sites manually the sites was returned.

When setting "TrimDuplicates" to false all items are returned, but one can also set "TrimDuplicatesOnProperty" to "Path" instead. It have the same effect as setting TrimDuplicates to false.

Configuration of PowerPivot

Installing and configuration of PowerPivot on a SP2013 with SQL Server 2012 SP1. I got the following error-message when running the PowerPivot configuration tool:

"The user is not a farm administrator. please address the validation failures and try again"

I´m a farm administrator with my account that is used to configure PowerPivot. The solution to this was to add my account as a secondary owner to the CA site collection.