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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors