ODATA Filter and Multi tenant

tmadsen
tmadsen Member Posts: 6
in NAV Three Tier
I am running NAV 2017 trying to connect Power BI Desktop to a multitenant NAV server. In general it connects fine, but if I try to apply a Filter as part of the connection string I get a connection / authentication error. The filter seems to work fine in a single tenant environment. Has anyone tried to get this to work in a multi tenant setup? I have tried play round with the syntax before and after the ?tenant=xxx parameter, but nothing seems to work.

Best Answer

  • tmadsen
    tmadsen Member Posts: 6
    Answer ✓
    Just figured a way around it. Don't use the tenant= parameter in your connection string. Just make sure the host name points to the tenant. That way you don't need the tenant parameter included in the string.

Answers

  • tmadsen
    tmadsen Member Posts: 6
    Answer ✓
    Just figured a way around it. Don't use the tenant= parameter in your connection string. Just make sure the host name points to the tenant. That way you don't need the tenant parameter included in the string.

Categories