Forum Discussion
Excel Power Query
Hi taluku,
Thank you for your query about using Power Query to pull and expand data from Salesforce in Excel. I’d also like to acknowledge lbendlin for pointing out the important limitation of the Salesforce Report connector, which has a hard 2000-row limit.
You can proceed with the steps to connect to Salesforce and expand your desired columns as outlined earlier. However, please be mindful of the 2000-row limit when using the From Salesforce Reports connector. If your report exceeds this limit, I recommend either switching to the From Salesforce Objects connector, which doesn’t have this restriction, or breaking your report into smaller chunks (each under 2000 rows) and combining them in Power Query.
For more details on working with Salesforce data in Power Query, you can refer to this Microsoft documentation: Power Query Salesforce Reports connector. - Power Query | Microsoft Learn
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hi taluku,
Thank you for your query about using Power Query to pull and expand data from Salesforce in Excel. I’d also like to acknowledge lbendlin for pointing out the important limitation of the Salesforce Report connector, which has a hard 2000-row limit.
You can proceed with the steps to connect to Salesforce and expand your desired columns as outlined earlier. However, please be mindful of the 2000-row limit when using the From Salesforce Reports connector. If your report exceeds this limit, I recommend either switching to the From Salesforce Objects connector, which doesn’t have this restriction, or breaking your report into smaller chunks (each under 2000 rows) and combining them in Power Query.
For more details on working with Salesforce data in Power Query, you can refer to this Microsoft documentation: Power Query Salesforce Reports connector. - Power Query | Microsoft Learn
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.