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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Katona_Erik
Regular Visitor

Anomaly after DB refresh

Hi All,

 

I have met a strange issue after refreshing.  Formerly, I made a report that contained valid data (colleagues from Finance checked it against the ERP's data) so it has brought correct data after each refreshing. The report is showing the values of our financial categories for 2020 & 2021. 

Unfortunately, after my last refreshing, I can not see a part of the 2020 data for one company (this is a consolidated report with three companies). Interesting that in 2021 the same data is fully correct.

 

I double-checked the data in ERP's database, the other manual tables in the model,  the query editor, but all information is correct so I am seeing the whole data for 2020. I also checked my filters several times but I could not find any unnecessary flags which could solve this problem. I have updated the last version of PBI but I get the same incorrect info from this report.

 

Do you have any ideas which can generate this problem?

 

Many thanks in advance!

 

Erik

 

 

2 REPLIES 2
lbendlin
Super User
Super User

@Katona_Erik Is your data source direct query or import? Regular or incremental refresh?

Hi @lbendlin 

 

The data source set is import with a regular refresh.

 

Thank you!

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors