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
