Forum Discussion
Power BI Report Data Refresh Questions
Anonymous your schedule refresh should pull the latest data and reports should get updated, not sure why it is not happening if refresh is executed without any error.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
This sounds strange to me too. I haven't had this problem with my connections from the Power BI Service to Excel spreadsheets saved in SharePoint.
- Anonymous4 years agoNot applicable
AlexisOlson parry2k Thanks for your response. I wonder how do you connect to the Excel file on SharePoint Online. Are you using the Web connection? Does the Refresh History show the the status of OneDrive refresh as "schedule"?
In my case, I use the Web connection as recommend by others. I use the web connection to import the 2 Excel tables in 2 Excel workbooks saved in SharePoint project online folder. But somehow the scheduled autorefresh is not refreshing the data. I have to open Power BI desktop to refresh the data.
It is very frustrating.
- AlexisOlson4 years agoSuper User
My connection looks like this:
let Source = Excel.Workbook(Web.Contents("https://companydomain.sharepoint.com/sites/SiteName/FileName.xlsx"), null, true), Sheet1 = Source{[Item="Sheet1",Kind="Sheet"]}[Data], [...]I'm only seeing OneDrive refreshes from when I manually refreshed the dataset (no scheduled OneDrive refreshes show in the history).
Potentially useful links for future readers:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
https://community.powerbi.com/t5/Service/OneDrive-Refresh/m-p/1145650
I wonder if your issue is related to this part from the second link above:
Power BI performs refresh based on an item ID in OneDrive, so be thoughtful when considering updates versus replacement. When you set a OneDrive file as the data source, Power BI references the item ID of the file when it performs the refresh. Consider the following scenario: you have a master file A and a production copy of that file B, and you configure OneDrive refresh for file B. If you then copy file A over file B, the copy operation deletes the old file B and creates a new file B with a different item ID, which breaks OneDrive refresh. To avoid that situation, you can instead upload and replace file B, which keeps its same item ID.
You can move the file to another location (using drag and drop, for example) and refresh will continue to work because Power BI still knows the file ID. However, if you copy that file to another location, a new instance of the file and a new fileID is created. Therefore, your Power BI file reference is no longer valid and refresh will fail.
- Anonymous4 years agoNot applicable
AlexisOlson My connection is similar to yours, also through web connection.
I wonder if you revise the Excel spreadsheet, can the Power BI report refresh (either auto or mannually) reflect the new changed data?
For me, either scheduled or mannual refresh won't show the latest data. I have to open the Power BI desktop app to refresh the data there.