Hello,
I am attempting to connect Power BI to NAV using NAV web services. It appears as a selection in the Get Data menu and I have read multiple articles on line that attempt to explain how to connect but nothing I try seems to work. So far this is what I have done.
1. Under the Get Data menu I have selected Online Services>Dynamics NAV>Connect.
2. I am then prensented with a dialog box with a field for the Dynamics NAV OData URL.
3. I enter the Odata URL from a published Web Service Page from NAV.
4. I am then presented with a dialog box that appears to be prompting me for a basic authentication using a user id and password. This box also contains a "level which to apply these settings to."
This is where I get stuck. It does not seem to matter what user id or password combination I enter, or which level I select, I always receive and error that says "We couldn't authenticate with the credentials provided. Please try again.
5. We use Windows credentials on our users in NAV, so, I created a password for my user in NAV. That did not work.
6. I then read online that I needed to create a Web Service Access Key for my user in NAV and use that as the password in Power BI. That did not work.
7. I then tried every combination of user id, password, web service key, and level that is possible. None of this worked.
We run NAV 2017 on prem and I am attempting to connect using the Power BI Desktop.
I am out of ideas. Any help would be appreciated.
