Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Andshepch
Advocate II
Advocate II

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 = 25 Reports, Lost Deals = 25 Reports, and Pipeline Deals = 25 Reports) The reports that need to be grouped all have exactly the same format and fields. I have imported them all as Queries, and then used UNION to combine them into three tables (Sold, Lost and Pipeline).

 

However, the model is almost unusable due to the terribly slow performance.

 

I am newish to Power BI, and have read about performance, and how to maximise it, but I need all the fields in my tables, and I don't know what else to try.

 

Can anyone please advise me and point me in th eright direction? I have a fantastic and extremely valuable report, but the end users will never use it unless I can get it to work faster.

 

Thank you.

 

Andrew

2 REPLIES 2
ReportMaster
Post Patron
Post Patron

Hi @Andshepch were you able to find a solution? as a workaround, maybe you can try to test your connection with a 3rd party connector that uses the Salesforce objects connector, so you shouldn't face this issue with rows limit. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

 

SALESFORCE-1.png

 

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

 

SALESFORCE-2.png

 

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

SELECT_DESTINATION_NEW.png

v-shex-msft
Community Support
Community Support

Hi @Andshepch,

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors