Published and Installed Extension to Business Central but Cannot see More than 13 APIs in Power BI BC Online Connector

(0) Share

Report

Posted on by NPagany

We are installing to Sandbox environment and everything was going good until late last week. The current issue is that after we publish to the Sandbox successfully with changes to our APIs. We go to access the API in Power BI using the BC connector but we cannot see ALL the APIs that were published. There are about 4 APIs that are not able to be seen and we have done everything to troubleshoot the issue by renaming the file, change ID number, and other things without avail. Has anyone else encountered this issue? What is the cause of certain API not being seen while others are fine using the BC connector. All these queries were being seen in Power BI a few days ago along with changes, etc. So not sure what happened.

I even duplicated the queries and only the queries that are already being seen in Power BI were duplicated (with different names, etc). Any help would be appreciated.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

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

Like (0)

Report

Hi, did you create an API page (PageType = API) or a normal list page (PageType = List)? If it is an list page, is it not published to the Web Service?

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No