web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Unable to retrieve a web service from Business Central to Powerbi

(0) ShareShare
ReportReport
Posted on by 85

Hi All,

   Tried to create a web service for an object. 

Page_5F00_filteritems.PNG

Changed it into a queryquery_5F00_filteritems.PNG

Nothing worked. I still am not able to see it in the list of webservices in PowerbI. Any help would be appreciated. 

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    11,397 on at

    hi

    look this

    learn.microsoft.com/.../admin-powerbi-setup

    DAniele

  • EGMX Profile Picture
    41 on at

    Hi there, pal!

    If you don't mind me asking, how are you trying to retrieve this information? Are you trying to import data directly from Business Central, or are you getting it as an odata feed?

  • Leo99 Profile Picture
    85 on at

    Thanks for the reply. It's just those tables that I am not able to retrieve

  • Leo99 Profile Picture
    85 on at

    Thanks for the reply. Getting it as an odata feed

  • Marco Mels Profile Picture
    on at

    Hello,

    You need to use the Dynamics 365 Business Central OnPrem connector, accessible via Online Services. OnPrem connector can only connect via Basic Authentication and a web service key.

  • Leo99 Profile Picture
    85 on at

    Hi Marco,

      Thanks for the reply. I am using BC cloud. I do not have on premises. It's just those tables that are not getting called. Is it because of the recent web service key migration.

  • Leo99 Profile Picture
    85 on at

    Finally this is what worked. Deleted the app registration for BC in Azure portal. Recreated it. Added permissions. Created a client secret. Tested the API in Postman. After a few tries, it magically appeared. Doesn't make sense but it worked

  • Marco Mels Profile Picture
    on at

    Thanks for the final outcome. Apologies, I should have asked if this was OnPrem or not.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans