Forum Discussion

KatrienVds's avatar
KatrienVds
Frequent Visitor
1 year ago
Solved

Connection to BusinessCentral cloud: request failed, Error 10122

Hi everyone,    I'm coming across a rather frustrating issue. My report refreshes keep getting timed out on one table, the sales quotes. There hasn't been a giant increase on quotes that could caus...
Need Help
  • v-veshwara-msft's avatar
    v-veshwara-msft
    1 year ago

    Hi KatrienVds ,

    Just wanted to check in to see if your query has been resolved and whether the steps suggested by Akash_Varuna  were helpful. If they were, kindly consider marking the helpful reply as 'Accepted Solution' to assist others with similar queries.

    If you've raised a support ticket and received assistance, please feel free to share your experience here to help the community.

    Otherwise, don't hesitate to reach out if you need further assistance.

    Thank you.

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi KatrienVds The timeout issue likely stems from large data loads or delays in the Business Central cloud API.

Could you try these please

Use OData filters like $top, $filter to limit data pulled.

Split queries into raw data + transformation steps.

Set UseReadOnlyReplica = true in your connection string.
If possible try enabling incrimental refresh

Disable background data previews in Power BI Desktop.

If nothing works then raise a Microsoft support ticket