Suggest Alternative Solution to Use Microsoft UI Pages (e.g., Customer Card) in Power BI

(4) Share

Report

Posted on by Amrit

179

Hello Community,

Following the recent Business Central v26 update, OData web services for Microsoft UI pages (such as the Customer Card) can no longer be exposed or accessed through Power BI.

As a result, reports that previously relied on these page-based web services are now failing, and attempts to republish the web service return an error indicating that the Tenant Web Service OData does not exist.

Please suggest any recommended alternatives for consuming UI page data (such as the Customer Card) in Power BI.

Below screenshot is from the Microsoft business central V26 update information,

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

Tech-Lucky 1,267 Super User 2025 Season 2 on at

Like (3)

Report

Suggested solution: For the UI pages you've used in Business Central, create corresponding Page APIs for similar datasets and utilize them in your Power BI reports.

Was this reply helpful? Yes No
Amrit 179 on at

Like (3)

Report

Thank you.

Do i have to customize the APIs?

Was this reply helpful? Yes No
Suggested answer

Tech-Lucky 1,267 Super User 2025 Season 2 on at

Like (3)

Report

Yes you will have to develop it using AL

You can see the link for how to create a Page API in BC: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api

Was this reply helpful? Yes No
Verified answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (2)

Report

Utilize Built-in APIs (v2.0) Business Central provides a set of built-in APIs designed for integration purposes. For instance, the customer API offers access to customer data. These APIs are optimized for performance and stability, making them suitable for Power BI reports.Microsoft Learn+2

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Verified answer

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

Like (2)

Report

Hi, This is a decision made by Microsoft, and partners have no choice but to comply, although I think it would be better to update at least once an alternative solution is available.

Microsoft has also mentioned elsewhere that it is not recommended to publish standard pages to Web Services.

For example,

Web Service Performance (OData, API, and SOAP) - Business Central | Microsoft Learn

There are only two ways from now on.
1. Copy the standard page to create a new page, and then publish it to the Web Service
2. Reset the API page
The second method is recommended because it has the best performance.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Amrit 179 on at

Like (2)

Report

Thank you ZHU,

Please guide me how to setup the API pages to expose to power BI.

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

Like (2)

Report

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

Extending standard APIs (1) – Kauffmann @ Dynamics 365 Business Central

How To Use Standard APIs In Business Central - Business Central Geek

Best Regards
Gerardo

Was this reply helpful? Yes No