Forum Discussion
Solved
Run Native Query (stored procedures)in Polling Expression Failed
I am configuring incremental refresh in Tabular Editor 3 and plan to run stored procedures to get the last change date. But I am keeping getting errors {"error":{"code":"DM_GWPipeline_Gateway_DataS...
For a polling expression you should output a single scalar value to compare against a bookmark, you can return a table but then use steps to convert to scalar
Think the problem is the stored procedure rather than the native query. Try calling the stored procudure via a view
The stored procedure is used to determine the last change date and returns change in every call. The view/table can only store a fix table and I don't think it will work.
For a polling expression you should output a single scalar value to compare against a bookmark, you can return a table but then use steps to convert to scalar