With Power BI, you can easily connect to your Salesforce.com account. Creating this connection retrieves your data and automatically provides a dashboard and related reports based on your data.
Select Get Data at the bottom of the left navigation pane.
In the Services box, select Get.
Click Salesforce and select Get.
Select Sign In to initiate the login flow.
When prompted, enter your Salesforce credentials. Click Allow so Power BI can access your basic Salesforce information and data.
Configure what you'd like to import into Power BI using the dropdown option:
Select a predefined dashboard based on a persona (such as Sales Manager). These dashboards bring in a specific set of standard data from Salesforce and will not include custom fields.
Select one or more custom reports from your Salesforce account. These reports will match your views in Salesforce and can include data from custom fields or objects.
If you don't see any reports, add or create them in your Salesforce account and try connecting again.
Click Connect to begin the import process. During the import you see a notification showing the import is in progress. When the import is complete, you see a dashboard, report, and dataset for your Salesforce data listed in the navigation pane on the left.
Try asking a question in the Q&A box at the top of the dashboard
Change the tiles in the dashboard
Select a tile to open the underlying report
While your dataset will be schedule to refreshed daily, you can change the refresh schedule or try refreshing it on demand using Refresh Now
Connected with a production Salesforce account that has API access enabled
Permission granted to the Power BI app during log-in
The account has sufficient API calls available to pull and refresh the data
A valid authentication token is required for refresh. Ensure you have 5 or less Salesforce data sets imported, as Salesforce has a limit of 5 authentication tokens per application
If you encounter any errors, please review the requirements above. Also note the ability to login into a custom or sandbox domain is not currently supported.