Forum Discussion
excel data refresh not updating in powerBI desktop
avigilan,
Do you click Refresh button in Report view or Query Editor of Power BI Desktop? If you disable "Include in Report Refresh" option for your table in Query Editor and click Refresh in Report view of Power BI Desktop, data will not be changed in Power BI report.
Regards,
Lydia
I'd check:
- Is your Power BI report connected to the same excel file as you expect? You can check this from "Data Source Settings" in the drop arrow under "Edit Queries". Make sure the file you are connecting to is the same filename and path. It would be an easy mistake to be connecting to a local file on your computer without realising it.
- Do you have any filters set up that are excluding the new data? For example if you have set a date range, Power BI wouldn't automatically extend that date range unless you were using relative date filtering.
Hi Ross,
I checked all of those things you mentioned- everything appears it should work correctly. When I load the data, there are no error messages, however when I try to view the data nothing displays-odd
avigilan,
Do you click Refresh button in Report view or Query Editor of Power BI Desktop? If you disable "Include in Report Refresh" option for your table in Query Editor and click Refresh in Report view of Power BI Desktop, data will not be changed in Power BI report.
Regards,
LydiaThis was exactly what solved my problem. I have 60 data fields and could not explain why some were not refreshing after pressing "Refresh". Thank you!
Hi,
I have tried this method, but still having issues.
Power BI is refreshing data till week 33, but I do not know why it cannot load week 34 data. everything in the format is the same.
Please help
