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.