Accessing Live Salesforce Objects data from Excel using Power Query
1. Open Excel and Power Query:
Go to Data - Get Data - From Online Services - From Salesforce Objects or From Salesforce Reports.
2. Select Data Source:
Choose between From Salesforce Objects or From Salesforce Reports.
3. Authenticate with Salesforce:
Enter your Salesforce credentials and API token if required.
4. Select Objects or Reports:
Browse and select the desired Salesforce objects or reports.
5. Load Data into Excel:
Click Load or Transform Data to import and optionally transform the data.
6. Refresh Data:
Set up automatic refreshes in the Query Properties dialog.
Additional Tips:
Data Transformation: Use Power Query Editor to clean and shape your data. This can include filtering rows, removing columns, merging tables, and more.
Scheduled Refreshes: If using Office 365 or Excel Online, you can also set up scheduled refreshes through the Power BI service, which provides more advanced scheduling options.
By following these steps, you can efficiently connect to Salesforce from Excel using Power Query, allowing you to analyze and manipulate your Salesforce data directly within Excel.