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
Fraizerrrrr
Frequent Visitor

data not

Why my data on excel not reflecting on my power bi/power query, the excel screenshot is what it is supposed to show that came from the data page. I just do an update, I don't know why it does not show some of my data, I don't have any filter in power query. 

Fraizerrrrr_0-1708475610969.png

Fraizerrrrr_1-1708475776547.png

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Fraizerrrrr 

There are a few potential reasons why your Excel data isn't updating in Power BI after refreshing, and several steps you can take to troubleshoot the issue:

Check the data source: Make sure that the data source (Excel file) is accessible and hasn't been moved, renamed, or deleted.

Ensure that the Excel file is not open by another user or process. Also, check that the worksheet and table names in Power BI match those in the Excel file.

Check the query settings: Verify that the "Enable Load" and "Include in Report Refresh" options are selected for each query.

Also, ensure that any filters or transformations in the query are not preventing the data from updating.

Check the refresh settings: Confirm that the data source is set to refresh automatically or that you are manually refreshing the data source when required.

Check the data model: Ensure that the Excel data is correctly imported into the data model and is visible in the Fields pane.

You can also try clearing the cache and refreshing the data model. Check for errors: Review the error messages displayed in the Query Editor or the Refresh Preview window to identify any issues that may be preventing the data from updating. I hope this information helps.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @Fraizerrrrr 

There are a few potential reasons why your Excel data isn't updating in Power BI after refreshing, and several steps you can take to troubleshoot the issue:

Check the data source: Make sure that the data source (Excel file) is accessible and hasn't been moved, renamed, or deleted.

Ensure that the Excel file is not open by another user or process. Also, check that the worksheet and table names in Power BI match those in the Excel file.

Check the query settings: Verify that the "Enable Load" and "Include in Report Refresh" options are selected for each query.

Also, ensure that any filters or transformations in the query are not preventing the data from updating.

Check the refresh settings: Confirm that the data source is set to refresh automatically or that you are manually refreshing the data source when required.

Check the data model: Ensure that the Excel data is correctly imported into the data model and is visible in the Fields pane.

You can also try clearing the cache and refreshing the data model. Check for errors: Review the error messages displayed in the Query Editor or the Refresh Preview window to identify any issues that may be preventing the data from updating. I hope this information helps.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

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!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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