Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Issue with refresh from Corporate One Drive excel

Hi,

 We are having a problem with an Excel file stored on corporate One Drive that does not get refreshed in the Report even if Data Source looks to be refreshing. The same user is used for One Drive and Power BI. Below you can check the screenshot showing the data set being refreshed.

DatasetRefreshHistory.png

But when checking on report side we can see that the Dataset does not see to be refreshed.

ReportNotRefreshed.png

It is a little confusing why the data is not being refreshed in the report. Can you please advise?

 

Many thanks,

Alexandru

 

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @AlexandruBogdan,

 

Based on my test, if we import from Excel stored in OneDrive, once the dataset is scheduled refresh or refresh manually completely, we need to refresh the report page to see updated data if we live the report open before the dataset is refresh. You can click the Refresh or press F5.

 

q3.PNG

 

 

Best Regards,
Qiuyun Yu

AlexandruBogdan
Regular Visitor

Hi Qiuyun Yu,

Thanks for your answer. I have followed the steps from here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-connect-to-files-on-your-groups-on... and the refresh functions properly. Probably it was a mistake in my original setup.

Thanks,

Alex