cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nilst Frequent Visitor
Frequent Visitor

Data from SQL database appears in preview but doesn't load - How to debug?

I'm experiencing a strange issue. I'm loading a table from a SQL database. I'm able to locate the data in the preview however it doesn't load to the actual dataset. See example below - product id 10051. I haven't applied any steps, it's just the source. Any ideas of how to debug this issue?

 

data-preview.PNGno-data-loaded.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
nilst Frequent Visitor
Frequent Visitor

Re: Data from SQL database appears in preview but doesn't load - How to debug?

The problem is solved. There was an issue with the sql statement used to access the tables in the database.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Data from SQL database appears in preview but doesn't load - How to debug?

Hi nilst,

 

Have you clicked button "OK"?

捕获.PNG 

 

Regards,

Jimmy Tao

Highlighted
nilst Frequent Visitor
Frequent Visitor

Re: Data from SQL database appears in preview but doesn't load - How to debug?

The problem is solved. There was an issue with the sql statement used to access the tables in the database.