Unable to refresh data in semantic model Dynamics 365 Business Central (on-premises)

[ShanMey]

Hi Everyone,

I have no issues refreshing the data in Power BI Desktop; however, I encounter an issue when refreshing it in the service.

Error Message in Below:

Data source error: DataSource.Error: Dynamics 365 Business Central (on-premises): Request failed: The operation has timed out. Microsoft.Data.Mashup.ErrorCode = 10122. DataSourceKind = Dynamics 365 Business Central (on-premises). DataSourcePath = domain/CompanyName/ODatav4-Company. ;Dynamics 365 Business Central (on-premises): Request failed: The operation has timed out. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: PostedSalesInvoiceHeader.

---------------

Anyone can help me ?

[Poojara_D12]

Hi @ShanMey 

• Gateway configuration: Ensure it's active and connected.
• Timeout settings: Increase the timeout in Power BI Service.
• Query optimization: Limit data or filter records.
• Performance check: Ensure Business Central is responsive.

Let me know if you need detailed steps for any of these actions!

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[ShanMey]

Hi Poojara,

Could you please share where can i increase the timeout in power bi service ? 

[Anonymous · Accepted solution]

Hi, @ShanMey 

Thanks for the reply from Poojara_D12 and 3CloudThomas. You can do this in Admin portal to latency refresh time.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

If it is on-premises, you might need to setup an on-premise data gateway

Connect to Power BI from Business Central on-premises - Business Central | Microsoft Learn

[ShanMey]

Hi, the setup is in place but the error persists.