Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

OData multi-tanant NAV instance

Hi,

I'm trying to use OData webservice to get the data from NAV (mutli-tenant NAV instance) to Power BI Desktop.

I have the connection string like this:

https://<servername>:<porNo>/<NavInstance>/OData/Company('MyCompanyName')/TopCustomerOverview?tenant=MyTenant


this connection string works, when I try to connect using Excel or web browser

 

It does not work when I try to connect using Power BI Desktop (I'm using Basic authentication).

I'm getting following error:

 

 

I know that there is a possible workaround for this:

https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-NAV-using-ODAta/m-p/146937

but I can't use Alternate ID in this case.

 

Do you know if it is possible to use Odata for multi-tenant NAV instalnce without using Alternate ID?

 

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for your reply.

       

      I don't have any experience with Fiddler and I'm not sure what I should look for there.

       

      Could you please advise?

       

      Among others, I'm getting this error message: