Power BI Service Refresh Schedule - One Drive as datasource

[Johann_32]

Hello,

we have a report that uses only excel files, stored on OneDrive as sources.

In Desktop tool, of course the connection is working without any problem.

As soon as we upload the report to a shared workspace, and try to set up the refresh schedule, it is not possible because it says in section "Datasource credentials" --> "Failed to test the connection to your data source. Please retry your credentials."

If we try to enter the credentials now, only Authentication method "Windows without impersonation" can be chosen.

It doesnt matter which Privacy level we choose, in all cases it is loading forever.. nothing happens.

Anybody has same issues? What could be the cause?

Thank you

Johann

[v-xinruzhu-msft · Accepted solution]

Hi @Johann_32 

You can refer to the following links:

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive#how-do-i-make-su...

Solved: Auto refresh from excel file on Onedrive - Microsoft Power BI Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.