Forum Discussion
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
- v-chuncz-msftCommunity Support
Anonymous
Try getting a network trace using a tool like fiddler. You could also create a support ticket for assistance.
- AnonymousNot 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: