Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
@NoralfG Have you followed this walkthrough?
Thank you for your suggestion @Seth_C_Bauer,
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
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
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 @Seth_C_Bauer 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