web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... excel odata o365 authe...

Small and medium business | Business Central, N...

Suggested Answer

excel odata o365 authentication On-Prem

(0) Share

Report

Report

Posted on by mundubira

40

Hi, we can't connect to BC On-Prem (v. 20.1) via Odata from excel/power BI, using O365 authentication. We can connect using basic authentication but it's not a nice way to connect for users.

This is the error we receive:

We have a case open with Microsoft but they don't give us any solution. I want to know if anybody has a similar environment (On-Prem and hosted in Azure), and is using O365 authentication, because I can't believe that it cannot work in this scenario

thanks

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

look this

community.dynamics.com/.../odata-access-using-aad-oauth-tokens-on-bc14-onprem

DANIELE

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 3,143

#2

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

#3

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans