Forum Discussion
Solved
SalesForce connectors
The Microsoft PowerBI connector for Salesforce provides two options to retrieve data: Reports Object The limitation with these two options is that you can only retrieve a maximum of 2,000 record...
Hi, Walks06
As far as I’m concerned, Power query is the best tool in Power BI to provide the filtering on Objects when retrieving the data. You can work with parameters in the Power query to achieve your requirement. You can follow this document:
Quickstart: Using Power Query in Power BI Desktop
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can use the Skyvia cloud platform to connect Salesforce with Power BI. It is freemium