OneDrive file updated, but not doing the same to Power BI dataset

[calsavara]

Hello,

The file is updated on OneDrive, as I can see when the last update happened. However, Power BI is not reflecting the same. I need to go to OneDrive and update the file on the web environment so Power BI can recognize the latest update. Does anyone know why this is happening?

Thanks.

Rafael

[Greg_Deckler]

What type of file? Did you import it or live connection?

[calsavara]

It is an Excel file that I usually update from my local drive and gets synced to OneDrive (using OneDrive for desktop). It worked fine until last week, when I noticed that although the file is still getting synced with new information to OneDrive, from there it does not update Power BI. I have to edit from OneDrive online and then BI recognizes it. Workbooks are updating just fine the reagular way (from my local drive).

[v-yulgu-msft]

Hi @calsavara,

In my test, I was unable to reproduce this problem. In your scenario, please check whether the "OneDrive refresh" is trun on. Besides, there will existing some delay to update the PowerBI dataset after updating the data stored in OneDrive.

Besides, please test whether the dataset in Power BI service will automatically refresh if you manually update the excel file in OneDrive.

Here is a similar thread for your reference: Auto refresh with Excel workbook on OneDrive

Best regards,
Yuliana Gu

[calsavara]

Hello Yuliana,

Yes, both files are set to Auto Refresh. Strangely, I have one more dataset that is an Excel file with tables just like these others I had mentioned, and this one is refreshing the reports in Power BI just fine. I don't need to go to OneDrive online to refresh it like I have to do to others.

Rafael

[v-yulgu-msft]

Hi @calsavara,

Does this excel file contains any external data source? If the Excel contains data which are retrieved from other on-promise database like SQL Server, to enable schedule refresh, we need to configure personal gateway for this dataset. Please refer to: Auto refresh from excel file on Onedrive

Regards,

Yuliana Gu