Cached data within Dataflow

jackcoxer · ‎06-13-2023

Good afternoon,

We have encoutered a strange issue and i'm not too sure where I go from here.

There was a line in our data which was in effect redundant and needed to be removed. This was taken out of the database. The dataflow has refreshed, however the line that was affected is still appearing in the data flow as well as in the Power BI Report that is pulling from that data flow.

Has anyone encountered this issue before? I've tried removing the table from PBI Desktop and repointing to the Dataflow, refreshing the dataflow itself but the line is still appearing in the report but not in the database. I feel like i'm going insane.

Thanks,

Jack

cassidy · ‎06-13-2023

1. Is incremental refresh on? If so, you may need to reset it to dump the old data

2. I've been able to solve Dataflows anomalies like that my simply renaming the table in the Dataflow, forcing Desktop to recognize it's new name, and that seems to trigger things to resolve that seemed "stuck" before.