Forum Discussion
Cannot retrieve metadata Netsuite connector
Hi,
I just got Suite Analytics connector, and the OBDC is correctly connected to Power BI. The issue i am facing now is that when i select the table i want i get this message:
I tried to get infromation_schema tables to see what's there still nothing.
Did anybody already experienced this error ?
Would be very helpful !
Thank you in advance !
Cheers
Ilham
7 Replies
I have had issue with NetSuite scheduled refreshes since the start of the week. Intially I thought it was just my password needed a reset, but I did this and it still did not work. I found something about the ODBC version no longer being supported so I upgraded the ODBC and I am in the process of also changing the setting in my ODBC connection and DNS file to resolve. This could also be what you are experiencing?
Hi ozbroomy,
Thank you for your answer, it seems that there is two data sources. I choosed the wrong one
If i want to use data source NetSuite2.com, than i have to use normal 'user roles'.
Admin and full access accounts are not allowed. that's why i was not able to extract or see the data.
Best regards
Ilhame
I am using Netsuite2.com with a user role and I still get the error message. Is there something else I am doing wrong for the connection? When I test the connection in the ODBC it connects fine.
- karaoan
Kudo Kingpin
You can also try Acterys: Planning, Consolidation For Power BI & Excel Acterys automatically creates editable, Azure/MS SQL tables, optimized for analysis with the required Netsuite tables. It also adds comprehensive planning and write-back optios with 8 Power BI custom visuals: Acterys Planning & Analytics For Power BI & Excel (microsoft.com)
Bonjour comment avez vous fait pour utiliser l'odbc quand j'essai d eme connecter j'ai l'erreur suivante :
Détails : « ODBC: ERROR [HY000] [NetSuite][ODBC 64bit driver]Error parsing connect string at offset 62.
ERROR [HY000] [NetSuite][ODBC 64bit driver]Error parsing connect string at offset 62. »Merci
I had the same problem, but found a solution: see ODBC Error: [netsuite][odbc 64bit driver]error par... - Microsoft Fabric Community
If anybody need NetSuite ERP services visit Ledger Labs
