Hi, does anyone have experience with connecting Ex...
# general
l
Hi, does anyone have experience with connecting Excel/Power BI to NetSuite using ODBC? I was able to connect successfully but when querying the tables available, I only see the static tables and not my company's data. I've tried connecting using the administrator role, Data Warehouse integrator role and some custom roles. Thank you!
a
@Leah A We're having the same issue - we found a YT video that directed us to check the box to allow "suiteanalytics connector" in enable features. However it would seem this is a paid for bundle and just waiting on info from our AM. Would love to hear if you find a different way as we're keen to get it connected as well. We are getting a connection but it's just not pulling any data out 😞 Admin won't connect as it wants 2FA for us but we have tried another role and it still isn't pulling data. The links we found but: https://www.netsuite.com/portal/press/releases/nlpr06-21-07c.shtml#:~:text=NetSuite%20starts%20at%20%24499%2Fmonth,fee%20of%20%24399%20per%20month.

https://www.youtube.com/watch?v=psN-sqCsrMk

chrome-extension://efaidnbmnnnibpcajpcglclefindmkaj/https://www.netsuite.com/portal/assets/pdf/ds-ns-suiteanalytics.pdf
l
We were able to pull the data by creating a custom role that does not need 2FA and assigning all the relevant permissions for the tables needed.
👍 1
a
Awesome news @Leah A - no need for the SAConnector tick box then? Would be great if we don't need another add on!