cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Heidi Regular Visitor
Regular Visitor

Dated credentials on SharePoint content

Hi everyone! 

 

I've ran into this issue a few times now and decided to ask for your input. We have a lot of Power BI reports that draw data from content in our SharePoint - environment. The credentials used to connect to that data use OAuth2 - protocol on organizational level. Sometimes when our ICT-admin makes some organization wide changes to our authentication processess, these data connections get severed because the credential are after that dated. 

 

At the moment it's just an inconvenience. The updates are interrupted and all the credentials need to be manually updated in our Power BI work spaces. But there might be a time in the future when there is no in-house Power BI experience in use and these situations might pose a bigger vulnerability. Naturally we have documented how to fix these issues, but the ideal solution would be to eliminate these issues altogether. 

 

Does anyone have knowledge on how a connection could be set to SharePoint or OneDrive content in a way the the credentials won't be severed when organizational changes to authorization processes are made? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Heidi Regular Visitor
Regular Visitor

Re: Dated credentials on SharePoint content

Dear @v-jayw-msft , 

 

thank you for your reply! In our organization the problem was the MFA method which was taken into wider use. Our IT-admin decided at this time to solve this by having one admin account for Power BI, Flow, PowerApps connections that is left outside of the MFA process. Not an ideal solution, but will do for the time being. 

 

I found this article service principal, which would seem to solve the issue: https://docs.microsoft.com/en-us/power-bi/developer/embed-service-principal.  I'll ask our IT-admin at some point, if this would be a good solution for us too. 

 

Thanks for the help, you all! 

 

 

View solution in original post

2 REPLIES 2
v-jayw-msft Senior Member
Senior Member

Re: Dated credentials on SharePoint content

Hi @Heidi ,

 

Please refer to the last two troubleshootings of the below document and see if it solved your problem:

https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios#data-refresh-fai...

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

Highlighted
Heidi Regular Visitor
Regular Visitor

Re: Dated credentials on SharePoint content

Dear @v-jayw-msft , 

 

thank you for your reply! In our organization the problem was the MFA method which was taken into wider use. Our IT-admin decided at this time to solve this by having one admin account for Power BI, Flow, PowerApps connections that is left outside of the MFA process. Not an ideal solution, but will do for the time being. 

 

I found this article service principal, which would seem to solve the issue: https://docs.microsoft.com/en-us/power-bi/developer/embed-service-principal.  I'll ask our IT-admin at some point, if this would be a good solution for us too. 

 

Thanks for the help, you all! 

 

 

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)