Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jackcoxer
Frequent Visitor

Cached data within Dataflow

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

1 REPLY 1
cassidy
Power Participant
Power Participant

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.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors