ODATA Filter and Multi tenant

tmadsen

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.

tmadsen

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.

tmadsen

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.