Forum Discussion

nilst's avatar
nilst
Frequent Visitor
8 years ago
Solved

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?

 

 

 

  • nilst's avatar
    nilst
    8 years ago

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

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi nilst,

     

    Have you clicked button "OK"?

     

     

    Regards,

    Jimmy Tao

    • nilst's avatar
      nilst
      Frequent Visitor

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