Logic App, Excel connector(Business) - adding row data takes 17-23 seconds each

Question

Logic App, Excel connector(Business) - adding row data takes 17-23 seconds each

Asis, Reiner 20

I have a consumption-based Logic App that utilizes the Excel Online Business connector. It reads data from one file and inserts it into another file. However, I've observed that each insert operation is taking between 17 and 23 seconds. I would appreciate any help or suggestions to improve the execution speed. loop2

loop1

Asis, Reiner 20 Reputation points

2023-06-25T17:16:56.31+00:00

Just to provide more context, I'm currently working with a relatively small dataset of only 50 rows. This is well below the threshold of the Excel connector's throttle limit, which allows up to 100 API calls per 60 seconds. Despite working with this limited number of rows, each insert operation is still taking between 17 and 23 seconds.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-06-26T03:56:48.0633333+00:00

@Asis, Reiner Thanks for reaching out. Can you please confirm if you are reusing the same connection for different logic apps? In case if you are using the same connection for multiple logic app then I will suggest you to use a new connection and see if you still observe the same issue. I also want to confirm if this is intermittent behavior as it is a consumption logic app, and the resources are shared and this could be another reason why you are observing the more time for the action to get execution. Alternative is there are multiple retry for the action to get executed then you could observe this behavior.
Asis, Reiner 20 Reputation points

2023-06-26T08:06:04.2233333+00:00

Hi @MayankBargali-MSFT I'm using the connection for only one logic app, and the issue I'm facing is consistent. When you mention shared resources, does it mean that there are multiple apps within the same resource group? Yes, there are multiple apps within the resource group. Also, I changed the retry policy to 'none
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-06-27T07:48:37.95+00:00

@Asis, Reiner No it doesn't mean multiple apps within the same resource group. Logic apps across Azure Active Directory tenants share the same processing (compute), storage, network, and so on so your logic app will be using the same resources. For more details you can refer to this.

In an ideal case it should not take 23 seconds for every call, until a retry happens and this would further need to be looked at from the backend logs. This could happen when there is a high load at your logic app or connector end. Did you observe the same behavior for other regions as well?

I will suggest you to open a support ticket with us to review this further. In case if you don't have the support plan then please let me know.
Asis, Reiner 20 Reputation points

2023-06-27T13:28:33.52+00:00

Thank you @MayankBargali-MSFT where can i file a ticket?
Asis, Reiner 20 Reputation points

2023-06-27T14:14:05.4033333+00:00

When I tested the functionality of adding a single row, it took approximately 28 seconds to complete.
Asis, Reiner 20 Reputation points

2023-06-27T17:37:32.3833333+00:00

I also observed that the slower insertion speed in one table is influenced by two other tabs/tables that have VLOOKUP formulas referencing the slower table. This additional factor contributes to the overall slowness. To address this issue, I plan to remove those VLOOKUP formulas and monitor the performance again.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-06-28T04:00:12.25+00:00

@Asis, Reiner Thanks for the update. Let me know the outcome of the monitoring. In case if you need to create the support ticket you can refer here.
Asis, Reiner 20 Reputation points

2023-06-28T04:12:57.46+00:00

thanks @MayankBargali-MSFT

Accepted answer

0 additional answers

Your answer

Asis, Reiner 20 Reputation points

2023-06-25T17:16:56.31+00:00

Just to provide more context, I'm currently working with a relatively small dataset of only 50 rows. This is well below the threshold of the Excel connector's throttle limit, which allows up to 100 API calls per 60 seconds. Despite working with this limited number of rows, each insert operation is still taking between 17 and 23 seconds.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-06-26T03:56:48.0633333+00:00

@Asis, Reiner Thanks for reaching out. Can you please confirm if you are reusing the same connection for different logic apps? In case if you are using the same connection for multiple logic app then I will suggest you to use a new connection and see if you still observe the same issue. I also want to confirm if this is intermittent behavior as it is a consumption logic app, and the resources are shared and this could be another reason why you are observing the more time for the action to get execution. Alternative is there are multiple retry for the action to get executed then you could observe this behavior.
Asis, Reiner 20 Reputation points

2023-06-26T08:06:04.2233333+00:00

Hi @MayankBargali-MSFT I'm using the connection for only one logic app, and the issue I'm facing is consistent. When you mention shared resources, does it mean that there are multiple apps within the same resource group? Yes, there are multiple apps within the resource group. Also, I changed the retry policy to 'none
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-06-27T07:48:37.95+00:00

@Asis, Reiner No it doesn't mean multiple apps within the same resource group. Logic apps across Azure Active Directory tenants share the same processing (compute), storage, network, and so on so your logic app will be using the same resources. For more details you can refer to this.

In an ideal case it should not take 23 seconds for every call, until a retry happens and this would further need to be looked at from the backend logs. This could happen when there is a high load at your logic app or connector end. Did you observe the same behavior for other regions as well?

I will suggest you to open a support ticket with us to review this further. In case if you don't have the support plan then please let me know.
Asis, Reiner 20 Reputation points

2023-06-27T13:28:33.52+00:00

Thank you @MayankBargali-MSFT where can i file a ticket?
Asis, Reiner 20 Reputation points

2023-06-27T14:14:05.4033333+00:00

When I tested the functionality of adding a single row, it took approximately 28 seconds to complete.
Asis, Reiner 20 Reputation points

2023-06-27T17:37:32.3833333+00:00

I also observed that the slower insertion speed in one table is influenced by two other tabs/tables that have VLOOKUP formulas referencing the slower table. This additional factor contributes to the overall slowness. To address this issue, I plan to remove those VLOOKUP formulas and monitor the performance again.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-06-28T04:00:12.25+00:00

@Asis, Reiner Thanks for the update. Let me know the outcome of the monitoring. In case if you need to create the support ticket you can refer here.
Asis, Reiner 20 Reputation points

2023-06-28T04:12:57.46+00:00

thanks @MayankBargali-MSFT

Answer 1

Hi @Asis, Reiner

I am posting the discussion and your finding as resolution so it can help other community members.

Since the Microsoft Q&A community has a policy that the question author cannot accept their own answer, they can only accept answers by others, I'll repost your solution in case you'd like to Accept the answer.

Issue: You observed that adding row using the excel connector takes 17-23 seconds for every request.

Resolve: You found that slower insertion speed in one of the table is influenced by two other tabs/tables that have VLOOKUP formulas referencing the slower table. This additional factor contributes to the overall slowness. To address this issue, you plan to remove those VLOOKUP formulas and monitor the performance again.

Share via

Logic App, Excel connector(Business) - adding row data takes 17-23 seconds each

0 additional answers

Your answer