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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
qmest
Frequent Visitor

Scheduled refresh with onedrive files

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.

1 ACCEPTED SOLUTION
AnkitKukreja
Super User
Super User

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

 

 

 

 

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

1 REPLY 1
AnkitKukreja
Super User
Super User

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

 

 

 

 

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors