Forum Discussion
Incremental refresh with Import Mode
Dear All, We have couple of reports which are based on SQL queries using the 'Import' Data Connectivity Mode. I have configured incremental refresh but I dont know if Incremental refreshes works...
If you have premium capacity on your workspace, you can use SSMS and XMLA endpoint to connect to your semantic model, and check if the incremental partitions are created. Refer this blog.
https://medium.com/@yukithejapanese/introduction-to-the-xmla-endpoint-in-power-bi-76448a6c9216
But, if the native query is greyed out, there is a high chance that the query cannot be folded and incremental will not work. You can try forcing it. Refer to this video. https://www.youtube.com/watch?v=8hjdOCni_ZY