Archive for SharePoint

Pin Excel to Power BI Dashboard is Disappointing

In a recent release of Power BI, I was really excited to see that the team had created the ability to pin an Excel workbook to a Power BI Dashboard.  I have been waiting for this and it was high on my list of things I missed most versus SharePoint Enterprise.  However when I tested it out this week, I was actually pretty disappointed.

First, how to use this feature

To use this new feature you must have OneDrive for Business – this wont work with OneDrive Personal (not yet anyway).

Go to the cloud version of Power BI in a browser and log into your account.  Then click Get Data as shown below.

image Read More

Using SharePoint Enterprise with Power Pivot

As regular readers of my blog would know, I attended the PASS Business Analyst Conference in Santa Clara California this year (April 2015).  Here is the link for next year if you are interested.  While I was there, I had the pleasure of presenting on one of my favourite topics – how to use SharePoint to share Power Pivot workbooks.

SharePoint Enterprise is very powerful, but there are some things that I think you need to do to make it a positive user experience.  My presentation covers what I have learnt over the last few years on this topic.  My objective is always to get away from the generic look and feel (shown on the left below) and instead deliver a optimised web browsing experience (shown on the right below).


I have now made a video of my presentation available online to anyone that would like to watch it. Read More