Open Forum

Expand all | Collapse all

PowerBi Server on-prem with Dynamcis NAV2018 on-prem

  • 1.  PowerBi Server on-prem with Dynamcis NAV2018 on-prem

    Posted May 15, 2019 07:34 AM
    ​Hi,

    is there any way to integrate PowerBI Reports (from on-prem PowerBi-Server) in Dynamics NAV2018 on-prem?

    I couldn´t find a solution except the Solutions where you have to connect to PowerBi in Azure Cloud.

    Would be great, if anyone could help me.

    ------------------------------
    Matthias Schauder

    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: PowerBi Server on-prem with Dynamcis NAV2018 on-prem

    TOP CONTRIBUTOR
    Posted May 15, 2019 08:48 AM
    ​Have you tried this guide? https://docs.microsoft.com/en-us/power-bi/service-connect-to-microsoft-dynamics-nav
    It seems to be able to connect directly to the NAV webservice.
    The IP/name used can be a local name or IP for your on-prem NAV Server.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: PowerBi Server on-prem with Dynamcis NAV2018 on-prem

    Posted May 15, 2019 09:40 AM
    ​That doesn´t solve my Problem. It describe how you connect PowerBi to Dynamics NAV, but not how you Can integrate a PowerBi on-prem Report in e.g. a RoleCenter.

    ------------------------------
    Matthias Schauder
    Schwarz Business IT Gmbh & Co. KG
    Neckarsulm
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: PowerBi Server on-prem with Dynamcis NAV2018 on-prem

    TOP CONTRIBUTOR
    Posted May 15, 2019 10:28 AM
    ​Ah, sorry, I misunderstood your problem.
    There are video guides which I am sure you already saw. But I haven't found any working with on-prem Power BI.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: PowerBi Server on-prem with Dynamcis NAV2018 on-prem

    Posted May 16, 2019 09:46 AM
    Edited by Brian Meier May 16, 2019 09:46 AM
    To display Power BI reports on the NAV 2018 role center, select the Get Started link that is displayed within the Power BI part on the role center.  This will launch a wizard that will take you through the steps to register your NAV application in Azure.  You must be an admin in Azure in order to register your NAV application.

    Brian

    ------------------------------
    Brian Meier
    Principal Program Manager Lead
    Microsoft
    Fargo ND
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: PowerBi Server on-prem with Dynamcis NAV2018 on-prem

    TOP CONTRIBUTOR
    Posted Jul 11, 2019 05:42 PM
    Please provide a screenshot of this "Power BI part" to "Role Center"; and the "Get Start" Link for NAV 2018 and Power BI?

    Please and thank you.

    ------------------------------
    Ronald McVicar, IT Software Mgr
    NSP (Quality Meats)
    nspproteins.com
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: PowerBi Server on-prem with Dynamcis NAV2018 on-prem

    Posted Jul 12, 2019 09:43 AM
    Edited by Matt McDowell Jul 12, 2019 09:43 AM
    I already have NAV connected so my screen doesn't show the "Get started" or "Connect" action anymore. But this is where it would be on your role center.



    ------------------------------
    Matt McDowell
    Supply Chain Analyst
    Valley Blades Limited
    Cambridge ON
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role