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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Super User
Super User

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
Super User
Super User

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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