Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

ODBC NetSuite Connection to Power BI: How to learn NetSuite Schema

Hello,   I am new to Power BI and NetSuite. I am able to connect Power BI to NetSuite via an odbc connection, but I have come to relize that there needs to be an understaning of NetSuite's schema t...
Need Help
Tutorial Requests
Rerangel63's avatar
Rerangel63
New Member
2 years ago

Hi, I followed the Netsuite documentation. Company pays the analitycs suite,  download the Netsuite odbc, install it and  put the URL, port, Account ID, Role ID, Netsuite2.com User and Password. 
I connect with Sql server Managment systems and work, but with Power Bi i get this error:
Detail:: "ODBC: ERROR [S1000] [NetSuite][ODBC 64bit driver][OpenAccess SDK SQL Engine]Check your login credentials (username and password) and connection attributes (account ID and role ID), and then try again.. Error ticket# lnooquryftvsiqmrv7ra[224]
ERROR [S1000] [NetSuite][ODBC 64bit driver][OpenAccess SDK SQL Engine]Check your login credentials (username and password) and connection attributes (account ID and role ID), and then try again.. Error ticket# lnooquryftvsiqmrv7ra[224]"

 

But in the SSMS works fine. Any Help?