Forum Discussion

NoralfG's avatar
NoralfG
Regular Visitor
9 years ago

Error when connecting to on-premise Navision 2016

I've tried to use Get Data and select the Microsoft Dynamics NAV App to connect to our on-premise Navision 2016 instance.   The on-premise gateway is installed and source set up successfully (test ...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

NoralfG Have you followed this walkthrough?

NoralfG's avatar
NoralfG
Regular Visitor
9 years ago

Thank you for your suggestion Anonymous,

 

Yes, but actually I was not asked for username/password at all (thought the gateway source were used). But after deleting everything and try to add the content pack again I was asked for username/password and of cause Windows (which we use in Navision) is not supported. :-|

 

I guess we have to try to adjust Navision to accept Basic authentication... But will that disable our current single sign on with AD account?

 

-Noralf

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi NoralfG,

     

    The content pack can only connect to Online data sources which you would have to have Dynamics NAV Online to be able to use the NAV content pack. In your scenario, please use OData Feed data source in Power BI desktop to re-create reports. Then publish the report to Power BI service, configure the dataset to use the on-premise data gateway.

     

    Best Regards,
    Qiuyun Yu

    • NoralfG's avatar
      NoralfG
      Regular Visitor
      9 years ago

      Hi v-qiuyu-msft,

       

      It's probably so that's the only supported variant. But first of all: In Norway Microsoft does not offer NAV as an online service, secondly I'm aware of many customers using the content pack for on-premise installations. ;-)

       

      I think Anonymous pointed me to the source of the problem: We need to use basic authentication.

       

      I'll let you know when I've tested that... ;-)

       

      -Noralf