Run Native Query (stored procedures)in Polling Expression Failed

[tw537]

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_DataSourceAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","parameters":{},"details":[],"exceptionCulprit":1}}}

It seems related to a setting in Power BI Desktop but the semantic model was developed through XMLA endpoind and can't be opened in Power BI Desktop.

[v-csrikanth]

Hi @tw537 
I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

[v-csrikanth]

Hi @tw537 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @tw537 

Thank you for being part of the Microsoft Fabric Community.

As highlighted by @Deku @lbendlin , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[Deku]

Think the problem is the stored procedure rather than the native query. Try calling the stored procudure via a view

[tw537]

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.

[Deku · Accepted solution]

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

[lbendlin]

I am configuring incremental refresh in Tabular Editor 3

Any particular reason?  Non-temporal partition boundaries?

[tw537]

For source contraol purpose.