I have a data set that joins direct query data set with 3 SPICE data sets. The SQL set should be refreshed automatically by underlying PEX job. However, the data is not refreshing.
Link to Dataset: Data Prep (amazon.com)
Hi @madwrig - How are you refreshing the final data set? Ideally you should refresh or schedule the SPICE data set first and then refresh the final data set.
Regards,
Sanjeeb
I am using the refresh now button. Underlying SPICE data is consistent, so no change expected. However, the CUSTOM SQL connection isn’t refreshing.
I have also completely recreated the dataset so that it is only driven by direct queries. Neither of the CUSTOM SQL in that dataset have refreshed either.
Hi @madwrig,
We are unable to access your private account as this is a public forum so we’ll be unable to help diagnose internally. I would suggest creating a support ticket for this instance so that the support team can provide more in depth assistance.
Hi @madwrig,
Following up here to see if you had any additional questions?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @madwrig,
Since we haven’t heard back, I’ll close out this topic.
However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!