Forum Discussion
Salesforce Objects direct connect with PowerBI will reduce Salesforce performance ?
Hi! I have been using PowerBI to set up reports and dashboards connecting via the Salesforce Objects to overcome the limitation (2 000 rows max) of the API with Salesforce reports. In most cases it ...
I would recommend switching from Salesforce Objects to Salesforce Reports. Salesforce Reports connector is the most convenient way of extracting data into Power BI. It is most convenient because it has all the columns that you need in a single table. You can click "get data" and you will find it there.
The connector only allows you to extract up to 2000 rows though. However, you can work around this limitation using third-party tools. Here is the approach that I would recommend: https://vidi-corp.com/connect-salesforce-reports-to-power-bi/