Forum Discussion
Direct Query for Excel Data
Yep, those are the only possibilities. I'd use refresh now to check out if it's working. Then you should set up some refresh times to refresh the report periodically everyday. I think there is no way to have automatic updates that refresh the report as soon as you change your file.
I'm not sure I am following you when you say "After that go to the report section and click update above the report. This second part is important for it to update."
Can you expand upon this? Is it PowerBI desktop? The Excel file on Sharepoint?
Thanks for the continual insights.
Sorry for not being very clear. I'm talking about Power BI Service, where the report is after published. I guess that's where you want your report to update.
When I talk about "After that go to the report section and click update above the report. This second part is important for it to update." I mean that you should click on the report name in the left-side tab which shows you the content of your Workspace (Reports, Dashboard, Datasources etc). That should open your report. When the report is open there's a settings bar above it, just like that: (for some reason I can't attach a picture here so I'll try my best to represent it haha)
File v View v Edit Report | Refresh ... and it goes on like that.
You should click on the Refresh button. If you had refreshed the data source, that should update the visualization with the new data.
I see the 'scheduled refresh' and the 'refresh now' menu items for the Dataset in the web version of Power BI. It seems that these are the only two valid options for Power BI reports that link to Excel data.
Thanks for your assistance!
Yep, those are the only possibilities. I'd use refresh now to check out if it's working. Then you should set up some refresh times to refresh the report periodically everyday. I think there is no way to have automatic updates that refresh the report as soon as you change your file.
Agreed.
- Very interesting thread, i got lost here, i have : file✓ export✓ share chat in teams get insights...... And eventually a refresh circle arrow symbol whose alt text reads "refresh visuals......refreshing will update visuals with latest data"... But clicking it is not refreshing the data. To clarify the desktop app gets updated when i edit the sharepoint excel database but the report via link does not! Thanks for your time.