Netsuite ODBC filter not folding

Hi Jerr,

Unfortunately no good news here.

The behaviour of the ODBC handler in PowerBI is relied upon by lots of users, so there was no appetite to change the quirks in the behaviour just to accomodate NetSuite's ODBC driver.

Netsuite picked up the support ticket, and eventually we got an engineer who understood our explanation of the issue. Unfortunately they finally said that they didn't have the resources to fix, and couldn't prioritize as this was an edge case.

So it's "Will Not Fix".

We worked around it by building out a regular (postgres) database and replicating all our data to it. Makes reporting a lot easier than loading data directly, and allows us to add value by simplifying the unweildly suite analytics connect schemas, and improve data access control, so would recommend it.

As part of understanding the problem, I did create an ODBC driver wrapper that fixed the  handling of the incorrect metadata. But it needs to be deployed on the server, so that would be difficult to use on the PowerBI service.

Anyway, hope you manage to wrangle your data!

Andy