Refresh Completing But Data Missing

Hi Anonymous ,

Please see the bottom of this page: https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

"Schedule refresh - If your Excel workbook file connects to external data sources, or you imported from a local drive, you can setup scheduled refresh to make sure your dataset or report is always up-to-date. "

And subsequently: https://docs.microsoft.com/en-us/power-bi/refresh-data

"If you created your datasets and reports based on a Power BI Desktop file, Excel workbook, or comma separated value (.csv) file on OneDrive or SharePoint Online, Power BI performs another type of refresh, known as OneDrive refresh."

Using the Get Data functionality and then the "Upload your Excel file to Power BI" option, it is possible to create a spreadsheet that will update itself once it is connected to the Power BI Service.

Regardless of the above, in my inital post, I commented that I had seen this functionality working prior to my issue and subsequently it has been working. My concern was that there was a period where a Scheduled Refresh and a OneDrive Refresh both said that they had "Completed" with no errors, when the data had not been updated.

Tom