Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

connect power BI on-premise account

Posted on by Microsoft Employee


Hello good afternoon.

I would like to know how to connect power BI with Dynamics NAV 2016 into account on-premise. I hope I can count on your help .

Thank you.

*This post is locked for comments

  • TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: connect power BI on-premise account

    Were you able to resolve the issue? If so please do share how you manage it or verify the answers which help you to do so.

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: connect power BI on-premise account

    Did you check the OData services are running properly in Dynamics NAV? If not I think you should first check the OData URLs.

    To do that go to Dynamics NAV Web Services List page and copy the OData URL for "powerbifinance" and paste it on the web browser and check WSDL is working. If it is working you can proceed to the next step of connecting to PowerBI.

    If the URL is not working and didn't gave the expected WSDL, follow the steps alexendra proposed.

    If the URL is working I suggest you to try the PowerBI Gateway. It will create a bridge between your computer and PowerBI service. It solve most of the authentication issues.

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: connect power BI on-premise account

    Hi Rogelio,

    In that case Like Alexander has advice, try checking the connection of ODATA, Also try accessing the Link with Browser...

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: connect power BI on-premise account

    If you performed the steps and did not get your connection, please check if you have ODATA web services enabled. Open Dynamics NAV Server setup and check if ODATA web services are enabled:

    ODATA.png

  • Suggested answer
    Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at
    RE: connect power BI on-premise account

    Please chek this msdynamicsnavashwinitripathi.wordpress.com/.../microsoft-power-bi-part-viii

    you will get more posts links. You can search for Power BI topic and will find more posts related to topic.

    here is the search result page link: msdynamicsnavashwinitripathi.wordpress.com

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: connect power BI on-premise account

    hello, i was already performing the steps in the following link powerbi.microsoft.com/.../powerbi-content-pack-microsoft-dynamics-nav and will not let me connect, I am using credentials that I connect to the application of NAV, I tried windows authentication and not let me connect

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: connect power BI on-premise account

    Hi Rogelio,

    Thorough Steps are in this link:

    powerbi.microsoft.com/.../powerbi-content-pack-microsoft-dynamics-nav

    ---------------

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans