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
MJ16
Regular Visitor

How to tell if data is getting refreshed if it is not being used anywhere in the report?

In my report, I have a data table called 'CustomersThisMonth' that is not being used in any visuals. Since I have set up a scheduled refresh for the report, does the CustomersThisMonth table also get refreshed?

2 ACCEPTED SOLUTIONS
blopez11
Resident Rockstar
Resident Rockstar

It does, unless you specifically unselect the option "Include In Report Refresh" for the query.

View solution in original post

aj1973
Community Champion
Community Champion

Hi @MJ16 

Yes it's included in the refresh if it appears in the semantic model. For better performance Unused Tables and Columns should be removed from the semantic models.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

3 REPLIES 3
v-jiewu-msft
Community Support
Community Support

Hi @MJ16 ,

If I understand correctly, the issue is that you want to know whether the data is refreshed. Please try the following methods and check if they can solve your problem:

1.When you set up a scheduled refresh for the report, it ensures that the data in the semantic model is updated.

 

2.Check the semantic model refresh history in Power BI service to see when the refresh occurred and if there were related errors.

vjiewumsft_0-1707370682994.png

 

3.Check if any dashboard tiles reflect changes related to the Customers data.

 

4.If setting up an incremental refresh for the customers table, verify that it is configured correctly to update the data as the requirements.

 

Best Regards,

Wisdom Wu

aj1973
Community Champion
Community Champion

Hi @MJ16 

Yes it's included in the refresh if it appears in the semantic model. For better performance Unused Tables and Columns should be removed from the semantic models.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

blopez11
Resident Rockstar
Resident Rockstar

It does, unless you specifically unselect the option "Include In Report Refresh" for the query.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors