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

Not able to get data from the Business Central KPI Finance Report web service (197)

(4) Share

Report

Posted on by Jöse

Hi All

I hope somebody has an answer to this or at least a workaround..

When creating a new datasource in PowerBI desktop or Dataflow, and using the Business Central connector i PowerBI:

Then Select the Environment in BC and then Selecting:

Then selecting the table from the KPI Finance Report web service:

and load.

then the table keeps loading until it times out, this is also the case when doing the same via Dataflows in the PowerBI Service.

I've had this issue since the 16. feb 2025.. any idea if any recent BC updates might have affected this?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Do you have Telemetry enabled?

If yes you can check error there.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

https://bit.ly/sauravlinkedin

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (2)

Report

Did you setup the KPI's?

Set Up and Publish KPI Web Services Based on Financial Reports - Business Central | Microsoft Learn

Build Financial Reports Using Financial Data and Account Categories - Business Central | Microsoft Learn

Also, in Power BI I would not rely on ootb odata web services. Create and use your own Query APIs instead.

Was this reply helpful? Yes No
Jöse 14 on at

Like (0)

Report

Hi @Steven Renders

Thanks for the response to my post.

i've set up the KPI's and everything worked perfectly until the 16.th of feb 2025 before that i only had some hick-ups with failed Scheduled Refreshed of my Dataflows in PowerBI, because of the KPI web service table not loading propperly, but that was fixed by just loading it manually and then refreshing dataflow.

I've tried both via Odata feed and using the Business Central connector in PowerBI and nothing works.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,603 Super User 2025 Season 2 on at

Like (1)

Report

Could you check setup once. https://learn.microsoft.com/en-us/dynamics365/business-central/bi-how-to-set-up-and-publish-kpi-web-services-based-on-account-schedules

Was this reply helpful? Yes No
Jöse 14 on at

Like (0)

Report

@Khushbu Rajvi.

I've already checked and done the necessary setup for the KPI finance reporting and as I mentioned earlier the web service does work, but not the connector nor fetching data from it via PowerBI since somewhere around the 16.th feb 2025.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, I did a simple test and didn't encounter your problem.
It should be a problem with the amount of data. I suggest adding some filtering conditions.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (1)

Report

I can confirm that it works for me as well...

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No