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 connection is working fine), but after adding the Odata URL to the Microsoft Dynamics NAV App it first says "Please hold on while we check for your credentials" and then just a few seconds "... importing your data" before this error appears:

 

We couldn't import data from Microsoft Dynamics NAV
 
There is no available gateway.
Please try again later or contact support. If you contact support, please provide these details.
 
Clicking on "Show technical details" give this information:
 
Urlhttp://my-server.my-domain.com:7048/NAV_instance_2016/OData/Company('MyCompany')
ConnectionType{FieldValue}
Correlation IDe0155a52-8c79-2bd3-cfd3-ab31761f2382
Activity IDd03b3510-e974-4de9-9687-059e7226a764
Request ID7de55c41-ad32-b5e2-0f8f-7410f9ccc675
Status code400
TimeThu Jul 20 2017 10:49:01 GMT+0200 (W. Europe Summer Time)
Version13.0.1930.145
Cluster URIhttps://wabi-europe-north-b-redirect.analysis.windows.net
 
Anyone that has an idea?
 
-Noralf

4 Replies

    • 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