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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Changing data source to sharepoint

Hello, 

 

I have currently built a power BI model wherein data is uploaded through files and folders (every month I will upload a new file and when refreshed data will be amended on power BI desktop and service) that are stored in my personal one drive. 

I would like to move those data sources to sharepoint. The same files have been uploaded to sharepoint. 

These files on sharepoint have restricted access. 

 

While trying to change the data source (I'm using a URL), i receive various errors: 

1. Need to use anonymous credentials 

2. Issues related to privacy

My aim is to remove the dependency of my personal one drive and give access to other people to edit the dataset. if this is possible through another mechanism (workspaces), I'm happy to explore that too. 

1 REPLY 1
SolomonovAnton
Super User
Super User

hello ! 

firs of all you shoukd switch data source to Sharepoint. Description sharepoint connector 

use "Microsoft Account" as Authentication Types 

 

if I answered at your question please mark topic as resolved 🙂

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.