Cannot retrieve metadata Netsuite connector

[Anonymous]

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

[ankitsharma585]

If anybody need NetSuite ERP services visit Ledger Labs

[gdrausin]

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

[Christobalski]

I had the same problem, but found a solution: see ODBC Error: [netsuite][odbc 64bit driver]error par... - Microsoft Fabric Community

[karaoan]

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)

[Anonymous]

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? 

[gauravjain]

Hello All, 

If anyone has issues with NetSuite Accounting, they can visit Ledger Labs. They are providing NetSuite ERP Services from NetSuite Integration to Bookkeeping. 

Thanks & Regards

[Anonymous]

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

[aguice]

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.