...
| Widget Connector | ||
|---|---|---|
|
This was announced at Dreamforce '14 http://blogs.msdn.com/b/powerbi/archive/2014/10/13/announcing-power-query-support-for-salesforce-com.aspx
But wait, that's not all...
| Panel |
|---|
Power BI for Office 365 and Excel integrations with Salesforce. With these new integrations, customers will be able to bi-directionally load data to Salesforce and Excel to build reports, visualize information and discover new insights. Salesforce integration with Power Query for Excel is in preview now, with general availability anticipated for the first half of 2015. Power BI integration with Salesforce is anticipated for the first half of 2015. A Salesforce app for Excel is anticipated for the second half of 2015. |
From http://www.salesforce.com/company/microsoft-faq.jsp
Wait, where is this bi-directionality. Do we know anything about Salesforce for excel?
What I love about Power Query
...
- On the Power Query ribbon click From Other Sources
- From Salesforce Reports
- Sign into Salesforce
- The list of reports will be there. Load the list
- Open the report you want to look at.
You can also do this for Objects
- Reports have a limit of 2000 rows. Objects don't
- You can't do SOQL queries
Issues
Of course you can only use this if you have the APIs enabled (from Professional Edition, if you pay, up to Enterprise, Developer and Ultimate).
Beware of security. DO NOT LOG INTO EXCEL AS AN ADMINISTRATOR! All of your data is then visible in Excel by anyone who opens up your PC. Use an Integration account that specifically only has read only access to the data you need it to have access to.
The user remains logged in when you close excel, so it is logged in next time you open excel.
Related Articles
| Filter by label (Content by label) | ||||||
|---|---|---|---|---|---|---|
|
...