Can't undo incremental refresh data flows

[FionaE]

I turned on incremental refresh for one of the tables in my dataflow - however because my license is only Pro (not Premium) it came up with a message saying that incremental refresh is not available. I then deleted the options (Date column, date ranges etc) and toggled it off, but now the dataset and reports are totally screwed up.  

[FionaE]

Thanks,

The problem arose beacuse I turned on incremental refresh  with a Power BI Pro only licence. This DID affect the data set and reports so  I toggled incremental refresh off but nothing happened, the reports were still screwed up. However, I then refreshed the dataflow (and then dataset) and now all is fine with the reports. Phew, scary moment there.

[v-binbinyu-msft · Accepted solution]

Hi @FionaE ,

To my knowledge, Dataflow incremental refresh is only available with a Power BI Premium subscription (which is either a Premium capacity or PPU license), because you are Pro license, the incremental refresh will not work, you could turn off incremental refresh on/off toggle, it should not have influence on dataset and report.

Please check whether it is caused by setting incremental refresh?

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.