Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
The Microsoft PowerBI connector for Salesforce provides two options to retrieve data:
The limitation with these two options is that you can only retrieve a maximum of 2,000 records with Reports or all records with Objects (which is a problem if you only need 5,000 out of the two million records).
Does anyone have a suggestion on how to filter data in an Object when using the standard connector or a third party connector to provide the filtering on Objects when retrieving the data?
Solved! Go to Solution.
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.
I would recommend to use Salesforce Reports connector instead of Salesforce object. It is a lot faster to load . It is really the most convenient way of extracting data into Power BI since all your needed columns are in one table there.
Salesforce Object connector also sometimes takes ages to load the data. I used to wait for hours for a preview of my tables to load in Power Query.
It only allows you to extract 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/
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/
You can use the Skyvia cloud platform to connect Salesforce with Power BI. It is freemium
Hi there is a third-party connector that connect powerbi to salesforce for but for a few specific connector which are :
you can check them out through this link: https://windsor.ai/connector/salesforce/.
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.
@Walks06 , please check if these can help
https://blog.pragmaticworks.com/tales-from-sales-hurdles-with-salesforce-connectors-in-power-bi
https://community.powerbi.com/t5/Desktop/Salesforce-Lead-Object-Issue/td-p/174693
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |