Scheduled refresh of Excel files with OData stopped

[DirkdeBoer]

The Scheduled refresh of Excel files containing OData stopped since last week.

I find the update of Excel files in, for example, Sharepoint via Power BI a very powerful solution that really helps to provide users with up to date Excel reports. The manual update of the Odata in my Excel files works fine and also the Odata reports within Power BI itself are running smoothly.

Does anyone know how the restore the scheduled refresh of Excel via Power BI?

[DirkdeBoer]

The OData comes from Project Online, Excel files are stored in a document folder within the same Project online environment.

Login is via a company account / ADFS.

[v-yuezhe-msft]

@DirkdeBoer,

Do you connect to on-premises OData service in your Excel file? If so, this is a known issue, and engineers are working on a fix, please keep an eye on the update time in Power BI support.



Regards,
Lydia