gbrueckl / PowerBI-VSCode

A VSCode extension to manage your PowerBI tenant using the Power BI REST API
MIT License
58 stars 12 forks source link

Incremental Refresh Policy not applied despite "Full" refresh #33

Open Lvanlaar26 opened 4 months ago

Lvanlaar26 commented 4 months ago

My understanding is that a "Full" refresh would give the same results as an On Demand refresh of the semantic model via the service. But I'm getting different results when it comes to Incremental Refresh.

When triggering the full refresh via VS Code, partitions are not created or dropped as expected.

This is following a VS Code Full refresh on 6/26, for a model that has an IR policy enabled for Monthly partitions:

image

I was surprised to not see a new partition created for 2024Q206.

Two days later (with no other changes) I triggered an On Demand refresh via the service and got the expected result:

image

I'm on v2.1.1 of the extension and I've experienced this with a few different models. Let me know if I have a misunderstanding of the expected functionality.

Thanks!

gbrueckl commented 4 months ago

there was another issue https://github.com/gbrueckl/PowerBI-VSCode/issues/27 where we explicitly set the applyRefreshPolicyto false guess I have to rework this and make it more granular e.g. if you select a partition -> applyRefreshPolicy = false if you select a table/whole dataset -> applyRefreshPolicy = true

will implement it in the next release

gbrueckl commented 4 months ago

ok, was a quick fix I think - just released v2.1.2 where this should be fixed now (as described above)

could you please check @Lvanlaar26 and report back here if the issue still exists

Lvanlaar26 commented 4 months ago

Worked great - Thanks!