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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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