Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am new to PowerBI. My company is using SalesforceIQ, not Salesforce Cloud, as CRM tool. Every month, I export data from SalesforceIQ to Excel, manipulate/edit the data, and then analyse and make report in Excel. The report revolved around business development activity, like how active is our communication with our contacts, how many new contacts we have over the last month, what products are they interested in etc. Now, I am thinking to using PowerBI to link directly to SalesforceIQ. Has anyone done so? Does PowerBI allows to connect to SalesforceIQ (not Salesforce Cloud)? Many Thanks.
Best regards,
Jeffrey
@jw95,
Based on my research, SalesforceIQ provides REST API to get data. You can directly connect to SaleforceIQ in the web connector or define the connection strings in a blank query. For mode details, please check the examples in the following blog and similar thread.
http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/
https://community.powerbi.com/t5/Desktop/Connect-Power-BI-Desktop-to-insightly/td-p/209079
Regards,
Lydia
Hi Lydia,
Thank you so much for the response. I have zero knowledge in API and I tried to go throught the blog you sent. I do not understand most of it, so could not work out how to connect them. However, that does not mean your suggestion does not work. The problem lies on me as I need to research and learn more on API.
Cheers,
Jeffrey
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.