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

Announcements

No record found.

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

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels Microsoft Employee on at

    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.

  • Verified answer
    Gjanus Profile Picture
    Gjanus on at

    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 Microsoft Employee on at

    Hello,

    Great work, thank you for sharing you got around the 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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans