Has anyone successfully connected PowerBI to NetSuite using ODBC and been able to pull transaction data? Custom records seem to work fine, when when pulling in the transaction table, I am getting this error.

I don't have advice for Power BI specifically, but just to confirm on your connection string that you're using netsuite2.com and not netsuite.com? netsuite.com just became officially deprecated, though it still works for existing customers who had it before deprecation. I don't think it allows any new connections though. Could be the issue there. I think custom records can technically be made "public" or something, so maybe that's why those are working. Probably not that, but worth the 3 minutes to check.

I have it setup - is your gateway a physical computer or a virtual machine?

Hi @Bryan Miller, I'm using both and getting the same error in both places

Are you using powerbi cloud or desktop?

Desktop

what role is the connection tied to?

I am using a custom role. Here is how it is configured.