Forum Discussion
Custom queries to detect data changes on dataflow entity
tac any chance you found the answer to this? I have the exact same situation and have been unable to find any information on it.
Hi joelt,
We managed the limitations of the dataflow by..... removing dataflows....
The main concern was the one described in my original message, but we noticed as well a big limitation about enabling the incremental refresh on the dataset when consuming information located in a dataflow... As this was not possible, we took the decision to redesign our flows without using dataflows. We have now a direct link SQL Server => PBI Datasets and it works well with the incremental refresh, having setup a custom polling expression, meaning it does not query the fact table to identify if the partition should be refreshed or not. The key thing when updating the polling expression is to encapsulates everything into one M expression and not using shared expression references. I was getting some weird errors when trying to do so.
Hope it helps.
Good luck.