Scheduled refresh with onedrive files

[qmest]

Hi,

I have a set of files that are used as sources for my dashboard for which i'm trying to set up a scheduled refresh. But i can't set up the credentials for the one drive account in the credentials settings. The data that i need is publicly available and in excel format so if there is no other way i can set these up as anonymous. Or should i keep these files in a github and read them from there?

Thanks.

[AnkitKukreja · Accepted solution]

Hi @qmest 

What is the connector that you've used? Anonymous authentication is supported for web connectors, try using OAuth2 ad it should work. Please, edit the credentials once you have published the file to the service.

Please see the older post and a document to guide you better.

https://community.fabric.microsoft.com/t5/Service/Schedule-Refresh-PowerBi-service-and-oneDrive/m-p/...

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive