Forum Discussion

nsaleron's avatar
nsaleron
New Member
10 years ago

Dynamics NAV 2016 - Failed to authenticate

 
Hello,
 
I am trying to connect Dynamics NAV 2016 with the plugin provided with PowerBI without any success.
 
My NST can be reached publicly with this URL (company name and server name have been changed) : https://navserver.domain.fr:9048/DynamicsNAV90/OData/Company('My%20Cronus')
 
The NST is setup to allow NavUserPassword authentication and the service certificate is valid (and not self-signed).
I am able to connect to the URL https://navserver.domain.fr:9048/DynamicsNAV90/OData/Company('My%20Cronus')/powerbifinance successfuly when I am using the webbrowser.
 
My problem appears when I try to connect PowerBI. After entering the URI and the basic credentials, I am redirected to the Dynamics NAV dashboard. After a few seconds, I receive the following error message :
 
Type de source de données

Traitement de l'erreur   The operation is canceled by user.
ID de corrélation   8c0ea3a3-8dfa-d9fe-a1f4-aa562f69f08f
ID d'activité   158bfa93-641a-43b3-8134-34dfdab281df
ID de demande  158449d7-0b86-4c5f-dd6b-0077ffffecfa
Heure  Mon Jul 04 2016 11:43:19 GMT+0200 (Paris, Madrid (heure d’été))
Version  13.0.1500.347
URI du cluste  rhttps://wabi-north-europe-redirect.analysis.windows.net
On NAV server side, the following error message is logged in the application event log:
Server instance: DynamicsNAV90
Tenant ID: 
Web service call failed because user could not be authenticated or authorized.
My user has the permission set "SUPER".
 
Have you any idea how I can solve this problem?
Does it come from my setup? Is it a bug in Power BI?
 
Thank you in advance for your support
 
 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi nsaleron,

    Based on the above error message, there are some issues with the web service authentication, could you please firstly use Power BI Desktop to connect to Dynamics NAV and check if it is successful? The OData entry in Power BI Desktop should allow you to connect  NAV when you provide the same URL as you do in Power BI Service.


    Thanks,
    Lydia Zhang

    • nsaleron's avatar
      nsaleron
      New Member
      10 years ago

      Hi Anonymous,

       

      Thank you for your answer. I have followed the following steps with PowerBI Desktop:

       

      1. I have clicked on the "Get Data" button in the ribbon and then "OData Feed".

      2. I have entered the same URL as before (https://navserver.domain.fr:9048/DynamicsNAV90/OData/Company('My%20Cronus') and also tried with the previous URL followed by /powerbifinance)

      3. I have entered my basic credentials (username + password)

       

      After a few seconds, PowerBI retrieved all my published services as "Tables" and I am able to browse my data (see screenshot below).

       

      For your information, the server navserver.domain.fr is a computer in a cloud service, so in this test I was not on same local network as the server but connected to it throw the public Internet.

       

      I hope you will be able to help me with that :)

      • mcangeli's avatar
        mcangeli
        New Member
        9 years ago

        I get the same thing. I can connect via my PowerBi Desktop, but it I try to use the built in one on https://app.powerbi.com it fails. I'd really like this fixed as it has the reports already built as a starting point.

         

        Any ideas??

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    We faced a similar issue when connecting to NAV 2016 from PBI Desktop. Worked well from browser but not from Desktop.

     

    When trying to connect to an actual table in the OData feed it gives the same error. But we were able to connect to "company level" of OData feed and then navigate to the resources from there.

    So https://navserver.domain.fr:9048/DynamicsNAV90/OData/Company('My%20Cronus')/powerbifinance didn't work.

    Instead authenticating to https://navserver.domain.fr:9048/DynamicsNAV90/OData/Company('My%20Cronus') with NAV credentials does work and from there you can navigate to all the tables.