web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / O.data feed not showin...
Small and medium business | Business Central, N...
Answered

O.data feed not showing new webservices in excel made in Dynamics

(0) ShareShare
ReportReport
Posted on by Gjanus

Hello,

I have a question.

In dynamics i make a new Web service.

This webservice i can open in Power bi dekstop - Get data - (tried direct Odata link, Dynamics onine, Dynamics Business Central) - all are showing the new webservice - no problems

In excel i do the same (only there is no Dynamics Businiss Central option). But Odata (v4) link not working or showing.

This is only with new webservices. Al excisting links works in excel.

What am i doing wrong? 

Sceens:

Dynamics - New webservice (projectelementen2)

pastedimage1623075078098v1.png

BI (Power Query)

pastedimage1623075217245v2.png

Excel (power Query)

pastedimage1623075274747v3.png

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: O.data feed not showing new webservices in excel made in Dynamics

    Hello,

    Great work, thank you for sharing you got around the issue.

    Thanks.

  • Verified answer
    Gjanus Profile Picture
    Gjanus on at
    RE: O.data feed not showing new webservices in excel made in Dynamics

    Thanks for reply Marco,

    I still don't see them in excel (Dub and others) with a direct link.

    Found this morning a working method:

    But when i connect through: Dynamics 365 (online) and use de link ending with Odatav4 is see them now.

    This wasn't the case before (atleast i thought i already tested this) but problem is solved.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: O.data feed not showing new webservices in excel made in Dynamics

    Hello,

    Are there any duplicates in the webservices, meaning duplicate names for different web services, etc. You may also see errors in the application event log file if connection is from OnPrem BC.

    This does not explain though why PowerBI does not have this issue.

    Thanks.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,869 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,484

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,242

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans