Error Message Loading Data from Netsuite

Power BI
1

Hello,

I’m currently working on loading data from NetSuite using SuiteAnalytics and ODBC, both of which have been successfully configured. However, I’m encountering the following error when attempting to load certain tables:

“Preview.Error: The type of the current preview value is too complex to display. Details:”

Despite this error, I’m able to bring in data when using direct SQL statements — for example:

SELECT * FROM Transaction WHERE Type = ‘SalesOrd’

It seems the issue arises only when using the Power BI Navigator to browse or load some of the tables directly.

Could someone assist me in resolving this? Any insights on what might be causing the error or how to proceed would be greatly appreciated.

Thank you in advance for your support.

Best Regards,
Hazra

2

Hi @hadeeh ,

Thank you for reaching out to the community.

While we wait for other members to share their insights, we’ve taken the liberty of using “Explain Simply ,” one of the tools available within Data Mentor (you can explore it here: https://mentor.enterprisedna.co/explain-simply . It generated the following results:
https://mentor.enterprisedna.co/explain-simply

image
image1161×951 124 KB

image
image1166×246 40.6 KB

Feel free to checkout more of our Data Mentor features as you work on your report. These tools are designed to help with tasks like the one you’re working on.

Cheers,

Enterprise DNA Support Team

3

Hi @hadeeh ,

Depends of what is behind * in SELECT statement.

Try to simplify the query to use exact fields as Data mentor propose and see if works.

For example sometimes CLOB type attributes can cause problem. Check if you have some of that kind of type and try to exclude form your query.

Good luck.

4

Thank you so much for the information provided. However, I resolved the issue. This is what I did. I am recording it here in case someone else get this error now or in future.

The error I was getting was after I loaded the tables.

“Preview.Error: The type of the current preview value is too complex to display.
Details:”

To resolve this, go to the Advance Editor in Query Editor, replace the [HierarchicalNavigation=true] which is in the first line with HierarchicalNavigation=true, CreateNavigationProperties=false]

The tables loads correctly without errors. Best wishes.

1 Like
5

Hi @hadeeh - Thanks for sharing the resolution. Marking this as Solved.