Hi, I'm trying to convert a saved search into an appropriate SuiteQL to import into Power BI via SuiteAnalytics ODBC. I've tried multiple times to do this but I'm constantly receiving syntax errors. I made sure the DSN is referencing the role where I created the search from so I should have access to the tables. Furthermore I'm suing NetSuite 2.0 and have the DSN set to reference Uppercase schema. I can't even pull in a simple test query on the transaction table. Any suggestions?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you're on the right track with using SuiteAnalytics Connect and ODBC to pull data from NetSuite into Power BI. Here are a few suggestions that might help: 1. Check your permissions: Make sure the role you're using to connect has the necessary permissions to access the data you're trying to pull. You might need to create a custom role that doesn't require 2FA and assign all the relevant permissions for the tables needed. 2. Check your SQL queries: Ensure that your SQL queries are correctly formatted and are pulling from the right tables. Remember that NetSuite is case-sensitive, so make sure your table and field names match exactly. 3. Check your ODBC connection: Make sure your ODBC connection is set up correctly. You might need to use a 64-bit ODBC connection, as some users have reported issues with 32-bit connections. 4. Check your data source in Power BI: When you're pulling data into Power BI, make sure you're selecting the correct data source. You should be using the 'Get Data > Other > ODBC > NetSuite' option. Remember, NetSuite is passive in this case. It's not exporting data, your other tool (Power BI) is importing it. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******