Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Using PowerBI with Dyn...
Microsoft Dynamics NAV (Archived)

Using PowerBI with Dynamics NAV

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello, 

I am trying to create dashboards using Power BI and dynamics NAV. 

Is there a way to use real time data of dynamics NAV in Power BI ?

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Using PowerBI with Dynamics NAV

    Solved by cleaning the Cache

    Now I can get NAV Pages Using OData in PowerBI

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Using PowerBI with Dynamics NAV

    T tried using pages but most of the times I get this error in Power BI Desktp

    "power bi (415) Unsupported Media Type odata"

  • Rabin Profile Picture
    Rabin 2,976 on at
    RE: Using PowerBI with Dynamics NAV

    Hi Gert,

    Thanks for Correcting me. I meant to write the Webservice as in general.

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Using PowerBI with Dynamics NAV

    no,

    only Pages and Queries in OData.

    nice links here

    msdn.microsoft.com/.../hh165375(v=nav.90).aspx

    msdn.microsoft.com/.../hh166950(v=nav.90).aspx

  • gert@lynge.org Profile Picture
    gert@lynge.org on at
    RE: Using PowerBI with Dynamics NAV

    Hi Rabindra Sah

    I don't think that is correct.

    ODATA webservice in NAV supports PAGE and QUERY - not CODEUNITs.

    SOAP webservices in NAV supports PAGE and CODEUNITs.

    I don't belive that has changed since NAV 2013 - but ODATA changed from being read only to also support writes at some point. I cannot remember if it was in 2013R2 or 2015...

  • Rabin Profile Picture
    Rabin 2,976 on at
    RE: Using PowerBI with Dynamics NAV

    @Xavim, regarding OData

    ODATA web-service only supports PAGE , QUERY as of 2016 Version). I don't see any problem using Page to Access Table. All Basically leads to the Table and its data.

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Using PowerBI with Dynamics NAV

    Hi Xavim,

    Its as simple as configuring NAV Service.

    We just need to configure the setting and connect the NAV to POWERBI. The walkthrough is presented in this link. The Developers of PowerBI have done a wonderful work. 
    I still have faced some problem connecting MADEIRA with POWERBI though. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Using PowerBI with Dynamics NAV

    Can I create OData from Tables not from queries in Dynmics NAV 2016 ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Using PowerBI with Dynamics NAV

    this tutorial helped me a lot thx (https://blogs.msdn.microsoft.com/nav/2015/03/27/powerbi-com-and-microsoft-dynamics-nav-2015/)

    but I still find it difficult to get the data I want

    PS : I am using Power BI Desktop

  • Suggested answer
    Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at
    RE: Using PowerBI with Dynamics NAV

    check out this link msdynamicsnavashwinitripathi.wordpress.com/.../microsoft-power-bi-part-v

    You can refer other links on post to start from begining.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans