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 :
Small and medium business | Business Central, N...
Answered

Dynamics 365 Business Central (on-premises): Request failed: Unable to connect to the remote

(0) ShareShare
ReportReport
Posted on by 55

I am getting this in PowerBi when I am trying to set up refresh of data set.

Any thoughts on what I am missing.?

pastedimage1593696544094v1.png

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    Did this work before or did it stopped working after maybe an upgrade?

    Thanks.

  • Jackie Larsen Profile Picture
    55 on at

    Hi Marco,

    No it is a demo set-up. I am new on this, so investigating the set-up for future projects.

    Best regards,

    Jackie.

  • Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    What is the url you are using and is the OData url exposed over the Internet. It does also require a trusted cert.

    Thanks.

  • Jackie Larsen Profile Picture
    55 on at

    Hi Marco,

    The url I am using is; tftest.officeconnect.dk:49004/BC160/

    It is set-up to https and cert is installed at server.

    I am not sure about the OData url. How do I check that?

    Best,

    Jackie.

  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    In the CustomSettings.config file, you see the following values (path = %programfiles%\microsoft dynamcis 365 business central\160\Service\CustomSettings.config file or %programfiles%\microsoft dynamcis 365 business central\160\Service\Instances\<<name of newly created NST instance>>\CustomSettings.config file

    NOTE: Dynamics 365 Business Central comes with three supported flavors: 140, 150 and 160 so if you have the Spring release, then in the below path 160 should be replaced by 140, etc.

      <add key="ODataServicesPort" value="xxxx" />
      <add key="ODataServicesEnabled" value="true" />
      <add key="ODataServicesV3EndpointEnabled" value="true" />
      <add key="ODataServicesV4EndpointEnabled" value="true" />
      <add key="ODataServicesSSLEnabled" value="true"
      <add key="PublicWebBaseUrl" value="xxx.domain.dk:443/<name of NST instance>/" />
      <add key="PublicODataBaseUrl" value="xxx.domain.dk:xxxx/<name of NST instance>/ODataV4/" />

    A correct OData Url needed for PowerBi could be ">nav.mydomain.onmicrosoft.com:16048/.../" />

    and 

      <add key="ODataServicesPort" value="16048" />

    For PowerBI, the url nav.mydomain.onmicrosoft.com:16048/.../ should be accessible for me (over the Internet). 

    Thanks.

  • Jackie Larsen Profile Picture
    55 on at

    Hi Marco,

    I had the public url missing at the server instance.

    Is it only the part until ...odataV4/ I need to include. The full url I can access from a browser has a lot of special signs etc.

    Best regards,

    Jackie.

  • Jackie Larsen Profile Picture
    55 on at

    Hi again,

    I just discovered that I have not enabled SSL. Is that a problem?

  • Verified answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    Yes, this is a requirement.

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,772 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,056 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 662 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans