Forum

Salesforce reports ...
 
Notifications
Clear all

Salesforce reports import into Excel Power Query

3 Posts
2 Users
0 Reactions
71 Views
(@bartkowiak)
Posts: 12
Eminent Member
Topic starter
 

HI,

I have seen, that Power Query is able to import data directly into Excel from Salesforce Objects or from Salesforce Reports. I was able to import data on Salesforce reports, but it seems it´s not preparing the full amount of data. It ends always on row 2000. Is there a chance/way to import more than 2000 rows?

Thx

Christoph

 
Posted : 12/07/2019 8:47 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Christoph,

This is a limitation from Salesforce, not Power Query. i.e. Salesforce will only return 2000 records.

Mynda

 
Posted : 13/07/2019 1:20 am
(@bartkowiak)
Posts: 12
Eminent Member
Topic starter
 

Sorry to hear that.

I tried to use Salesforce Objects, but this is quit difficult and complex. 🙁

Christoph

 
Posted : 13/07/2019 8:46 am
Share: