This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there a way to get the raw sql for a Netsuite Report?

&gt;*AI generated answer (using internal Slack threads):*
Based on the conversations provided, it appears that there is no direct way to get the raw SQL for a NetSuite report. While you can use SuiteQL to run SQL-like queries in NetSuite, the ability to export a report's underlying SQL query is not mentioned. 

One user suggested using SuiteQL to write SQL-like queries, as shown in the code snippet:
```let SQL = ""
var mySuiteQLQuery = query.runSuiteQL(sql);
let results = mySuiteQLQuery.results;
return JSON.stringify(results);```
However, this does not directly answer the question about exporting a report's SQL. 

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1608173137243200|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.832472801

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1721024660219349|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.828980744

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1713310292055859|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.828744471



Please provide your feedback on this answer.

Can I export a report to powerbi?


[9:57 AM]
using ODBC