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

[nilst]

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?

[v-yuta-msft]

Hi nilst,

Have you clicked button "OK"?

 

Regards,

Jimmy Tao

[nilst · Accepted solution]

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