Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AndyKingss
New Member

Unable to Connect to Microsoft NAV

Hi Guys,

 

I am unable to connect to Microsoft NAV directly and also via OData Feed. I have read through most of the threads with similar challenges with no solution yet 😥.

I am not sure what the issue is exacty.

 

More Details..

First, I get the OData URL (this is required while connecting either through Microsft NAV (Beta) or OData Feed Data Source). I noticed, this only attepts to connect with https and not http.

Secondly, an authentication window pops requesting for username and password 

PS - this is the only option if connecting via NAV but there are more authentication options connecting via OData.

However, there has been no success with the connections. I followed the steps as detailed https://docs.microsoft.com/en-us/dynamics-nav-app/across-powerbi

 

 

 
 

BI.PNGNavConect.jpg

 

1 ACCEPTED SOLUTION
Adamtall
Resolver III
Resolver III

Hello

Looks like you got the wrong server name.

URL from the fuente of ODataThe OData URL so that Power BI can access your company's data, such as https://mybusiness.com:7048/MS/OData/Company('CRONUS%20US').

Navision web services will display the name of the local company, perhaps not the public.

Is the port open?

Does The Navision Administration allow Odata?

What you can try before connecting to PowerBI,

try opening chrome with the odata address and will prompt you for username and password if the link is correct. And when that works, then you know you have the right address and you can go back to the PowerBI connection.

I hope this can help you.

/Adam

View solution in original post

1 REPLY 1
Adamtall
Resolver III
Resolver III

Hello

Looks like you got the wrong server name.

URL from the fuente of ODataThe OData URL so that Power BI can access your company's data, such as https://mybusiness.com:7048/MS/OData/Company('CRONUS%20US').

Navision web services will display the name of the local company, perhaps not the public.

Is the port open?

Does The Navision Administration allow Odata?

What you can try before connecting to PowerBI,

try opening chrome with the odata address and will prompt you for username and password if the link is correct. And when that works, then you know you have the right address and you can go back to the PowerBI connection.

I hope this can help you.

/Adam

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.