Power BI Incremental Refresh - Using Custom Queries to detect data changes(Polling Expression)

[Anonymous]

We are trying override detect data changes behavior by replacing default pollingExpression with name of custom polling query. Incremental refresh is failing once we replace pollingExpression with name of custom polling query or M expression referencing another table.

Have you come across this issue or successfully implemented custom polling query of detect data changes feature?

Error Message:

Data source error: {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"The datasource reference credential cannot be found."}}]}}}

MS Documentation link - https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#custom-queries-for-d... 

Tools Used:

Power BI desktop - Model development

Tabular Editor - To override detect data changes using XMLA

[Anonymous]

Hi @v-luwang-msft 

Out of the box Power BI incremental refresh and detect data changes is working as expected. Issue I am having is when I try to override the default detect data changes pollingExpression with name of custom polling query or an expression referencing a column in another table(in same model). Following MS documentation describes the functionality https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#custom-queries-for-d... 

Regards

Aravinth

[Anonymous]

Hi @Anonymous , Did you manage to find a solution for this issue? If you did, it would be helpful if you could post it in this thread.

[v-luwang-msft]

Hi @Anonymous ，

You could following tips:

Be sure to check out videos, blogs, and more provided by Power BI's community of BI experts.

• Search for "Power BI Incremental refresh detect data changes" on Bing.

here are documents for you refer to:

https://community.powerbi.com/t5/Community-Blog/Important-Considerations-for-Setting-up-Incremental-Refresh-on/ba-p/554151

https://www.nabler.com/articles/Power-BI-data-refresh-and-scheduling-3.asp

Best Regards,

Lucien