Small and medium business | Business Central, N...

Power BI connection issue with BC since version 25.3

(2) Share

Report

Posted on by CU17101358-0

Hi all,

Last week I updated our BC environment to version 25.3 . Since then my PowerBI reports that have connection with a BC table fail to refresh. This is the error I am getting:

DataSource.Error: Dynamics365BusinessCentral: Request failed: The operation has timed out. Microsoft.Data.Mashup.ErrorCode = 10122. DataSourceKind = Dynamics365BusinessCentral. DataSourcePath = Dynamics365BusinessCentral. ;Dynamics365BusinessCentral: Request failed: The operation has timed out. The exception was raised by the IDbCommand interface. Table: powerbifinance.

Is this a known issue? Or does anyone know how to resolve this?

Thanks you very much!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suresh K 54 on at

Like (0)

Report
Copy link

Link copied!

Please check this post, see if that setting helps in your case

https://community.fabric.microsoft.com/t5/Service/Unable-to-refresh-data-in-semantic-model-Dynamics-365-Business/m-p/4332629#M259490

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Please check this post, see if that setting helps in your case

https://community.fabric.microsoft.com/t5/Service/Unable-to-refresh-data-in-semantic-model-Dynamics-365-Business/m-p/4332629#M259490

Was this reply helpful? Yes No
CU17101358-0 48 on at

Like (0)

Report
Copy link

Link copied!

@Suresh K Thank you for your response, I followed your instructions and set the timeout to 60 seconds. But still the problem remains unfortunately. Any other suggestions?

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Solved: Re: Datasource Error - Business Central Web Servic... - Microsoft Fabric Community

Web Services

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps: https://community.powerbi.com/t5/Desktop/Error-on-scheduled-refresh-quot-The-exception-was-raised-by-the/td-p/1085022

Was this reply helpful? Yes No
CU17101358-0 48 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your responses. I found that the error is specifically from loading the 'KPI-Webservice' Business Central table. When looking further in Business Central I found that the KPI-Webservice has status 'unpublished'. When clicking 'Publish webservice' button, nothing happens. This is probably why my connected PowerBI reports have refreshing errors as well.

Anyone that has an idea why this won't publish anymore?

(See attached video)

Bezig met opnemen...

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,208 Moderator on at

Like (0)

Report
Copy link

Link copied!

hope this offer some hint

https://community.fabric.microsoft.com/t5/Desktop/Problem-with-connector-Business-Central-Power-BI/m-p/3807429

Or create a MS ticket

Was this reply helpful? Yes No
BB-19021707-0 4 on at

Like (1)

Report
Copy link

Link copied!

Hi JR61, I have a client who is experiencing the same exact issue since updating to 25.3. Did you ever find a solution on how to get the Web Service published?

Was this reply helpful? Yes No