Here is a short video on how to connect to Salesforce.com from Power BI:

You can now easily get data from Salesforce.com into your Excel / Power BI solution. Enjoy!