Forum Discussion
Append or Union (or another way) Performance problem
Due to the API limit of 2000 rows in Salesforce, I have had to create 75 seperate Salesforce reports to inport into my Data model. I then need to group them together into three tables (Sold Deals = 2...
Hi Anonymous,
In fact, I also not has effective solutions to solve performance issue which cased with api result limit.
In my opinion, I'd like to suggest you to pull/export all result as local files and use power bi to get data from them, it should increase load data performance.
In addition, you can also try to write a custom function to analytics and re-invoke api to get all records at same time.
How to perform loop in M Query and collate result of the same
Notice: current custom functions not works on service side.
Regards,
Xiaoxin Sheng