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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Connecting PowerBI Des...
Small and medium business | Business Central, N...
Answered

Connecting PowerBI Desktop to Business Central On Prem Demo

(0) ShareShare
ReportReport
Posted on by Peter Jones - BIDA 151

Hi All,

we are newbies to the task of connecting PowerBI local (desktop) to a demo BC210 instance on the same machine.

We are just experimenting with getting PowerBI to connect to BC. We are not users of BC and we don't have "tech support" for BC.

We have followed what we think are all the correct instructions.

(I won't bore you with the list of things we have done. We think we followed the instructions closely but we are not experts in doing this.)

So we are wondering if there is a log file somewhere than when powerBI says the connection failed the log might give a clue as to why it failed.

We don't want to waste anyone elses time on this because we are such newbies.

We think we should learn how to do this by our trial and error.

We have gone through posts like this one and many other posts a well.
(+) Unable to connect Power BI to Business Central on-prem using basic auth - Dynamics 365 Business Central Forum Community Forum

So if you know where we should look for clues as to what we have set up incorrectly?

We would really appreciate any tips.

Thanks in advance for any assistance you are willing to offer.

Best Regards

Peter

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,382 on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    hi

    look this

    community.dynamics.com/.../how-to-configure-a-connection-between-power-bi-and-business-central-on-premises

    Daniele

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,382 on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    hi

    look this

    community.dynamics.com/.../power-bi-integration-with-on-premise-business-central

    DAniele

  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    Hi Daniel,

    thanks. I will go through it tomorrow.

    Much appreciated.

    Peter

  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    Hi DAniele,

    I have had a chance to get back to this problem now. 

    I have been able to get into the BC Admin command line and show the settings for ODATA.

    Inside our test BC instance I have got the ODATA Page and you can see the addresses.

    I have gone into windows firewall and allowed any application to connect to the ODATA port for input.

    But when I click on, say the chart of accounts link, I get can't reach the page.

    So it seems we have still not even gotten to the point of being able to see the ODATA web page.

    This is the step I am trying to do and it seems we can't get this right yet.

    "Enable OData web services and the ODataV4 endpoint.

    1. OData web service must be enabled on the Business Central Server, and OData port opened in firewall. For more information, see Configuring Business Central Server - OData Web Services.

      The local server must be accessible from the Internet."

    Is there any video or any tips anywhere in more detail that show what to do?

    Thank you in advance for any assistance you are willing to be.

    Best Regards

    Peter

    pic02.jpgpic01.jpgpic03.jpg

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,045 Moderator on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    Have you tried to go through this documentation?

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

  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    Hi Inge,

    yes. we are on step 2 of that page. (see below).

    At that step we can not even seen the OData urls on the demo machine we have.

    We have put the BC demo instance on an Azure VM in West Europe and we have the fixed IP address available to us.

    I believe the OData web services are enabled because it shows the URLs in BC.

    I have created a new rule in the windows firewall to allow an input port 7048 using TCP to accept all input.

    We are trying to use Nav User Password connections because this is just a test demo machine and we have not installed https.

    I have been trying AAD today and it seems we must have https for the URI.

    So I have just given up on that.

    So yes, I am used to following instructions as I have been in IT 40 years.

    But on this one I am stuck it seems.

    "Enable OData web services and the ODataV4 endpoint.

    OData web service must be enabled on the Business Central Server, and OData port opened in firewall. For more information, see Configuring Business Central Server - OData Web Services.

    The local server must be accessible from the Internet."

    Best Regards

    Peter

  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    Hi Inge,

    Oh, I see OdataServicesEnabled is set to false.

    So I will try and set that to yes.

    I will see how I go.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,045 Moderator on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    Good. Lets hope that fix the issue.

  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    Hi Inge,

    Ok, I have had some success. I entered

    Set-NAVServerConfiguration -ServerInstance BC210  -KeyName ODataServicesEnabled -KeyValue "True"

    Restart-NAVServerInstance -ServerInstance BC210

    And then when I clickedon the odata link it allowed me to use the administrators userid/passward for the machine and actually get some data back.

    So I don't know why that service was turned off. I saw it was defaulted to enabled and I saw true "close" to the setting and misread it as enabled = true.

    So one step forward.

    Its an ok way to spend a snowy sunday afternoon. LOL!

    I will keep at it.

    Best Regards

    Peter

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,045 Moderator on at
    RE: Connecting PowerBI Desktop to Business Central On Prem Demo

    Keep up the good work!

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,828

#2
Sumit Singh Profile Picture

Sumit Singh 2,617

#3
YUN ZHU Profile Picture

YUN ZHU 1,861 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans