The Salesforce connector by Vidi solves multiple problems.

1. Allows you to overcome 2000 rows limitation imposed by the native connector

2. You don’t have to use Salesforce Objects connector which can be slow and has 100+ tables.

3. Supports Direct Query connectivity

How to connect Salesforce to Power BI

You can extract data from the Salesforce Report API in chunks using any coding language.(We mainly use Python in Vidi)
Pasting the data into a database (we mainly use Azure SQL Server)
Scheduling your data refresh (we mainly use Azure Cloud Functions)

Here is a video demo of how this process works: https://www.youtube.com/watch?v=_c0Rrg690nw

Your Azure SQL database can then be connected to Power BI and become a data source for your reports.

We employed this approach while building a Salesforce dashboard in Power BI for the global head of marketing at a public company. They had their data in 7 different Salesforce reports which we extracted using the method described above.

CONTACT US TO GET THIS SOLUTION

Salesforce To Power BI Connector

by Vidi Corp LTD