Forum Discussion
Incremental Refresh not working in Service
- 1 year ago
I removed incremental refresh (right clicked on the table in the pbix and turned it off) and then saved a new pbix and published to my workspace. It took about 20 minutes and refreshed. So, the issue is with the incremental refresh from a Fabric Lakehouse table.
I noticed that when turning on incremental refresh in desktop, there is warning that it is unable to confirm if the query can be folded. (The query was a select * but it was a native query). I removed that and simply connected to the table then filtered to the paramaters as before. If you right click on the applied step (not the source step but any steps after), it should say 'view native query'. If it doesn't allow you to click that, then it probably is not "foldable". Again, I am not sure why the error was credential related. That threw me off.