Unable to Connect Power BI Desktop to NAV 2016 (Odata URL)

[James9]

Hi Guys,

 I've been having issues importing data to Power BI Desktop & Power BI online. I'm looking to connect via Microsoft Dynamics NAV 2016 (Role Tailored Client). Power BI Online just continually loads (for hours) so i'd like to find a solution to the desktop version if possible. It accepts the OData URL no problem, however it will not authenticate my credentials.

I have entered my NAV credentials and I'm certain they are correct, the server settings are also correct, any ideas?

Any help would be gladly appreciated,

Thanks,

James Campbell

[edejes2]

Hello @James9,

You need to sign in on the power bi desktop with your power bi account , use the not the  hope this help with your issue.

ED

[James9]

Hi @edejes2,

Thank you for the reply. Unfortunately I have also tried this method, it will bring me to the following screen and once again will not authenticate my credentials.. 

I have tried my Nav & my Power BI credentials, niether of them work!

James

[v-chuncz-msft]

@James9,

You might need to check the permission. Clear permissions in data source settings and try again.