Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
We have a user in the company that is responsible for multiple data sets. When user password is reset they need to OAuth2 reauthenticate all the Sharepoint sites where documents are used. Why is it so? Any way to make the authentication permanent from the dataset settings itself?
Solved! Go to Solution.
Yes that service account has to have access to all SharePoint sites to read the file
Member role should be sufficient as it only require to read data.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
You should be using service account and set the password never expire.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
Yes, I was thinking about that.. however, this means that this service account will need access to all sharepoint sites, and all folders basically. Any way to do that , or will we have to make them a system administrator?
Yes that service account has to have access to all SharePoint sites to read the file
Member role should be sufficient as it only require to read data.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!