Power Query and MFA with SharePoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-1672336%22%20slang%3D%22en-US%22%3EPower%20Query%20and%20MFA%20with%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1672336%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20starting%20a%20new%20conversation%20as%20wasn't%20able%20to%20find%20any%20answer%20to%20the%20problem%20i%20have.%3C%2FP%3E%3CP%3EHere%20is%20the%20use%20case%3A%3C%2FP%3E%3CP%3EI%20have%20multiple%20excel%20files%20spread%20accross%20different%20SharePoint%20sites.%20I%20have%20a%20file%20that%20consolidate%20all%20of%20them%20through%20Power%20Query.%20I%20have%20of%20course%20access%20to%20all%20of%20the%20site.%3C%2FP%3E%3CP%3EI%20am%20sign%20in%20excel%20correctly%20with%20my%20O365%20account.%3C%2FP%3E%3CP%3ESince%20we%20started%20to%20activate%20MFA%20every%20few%20days%26nbsp%3B%20when%20I%20open%20the%20file%20and%20hit%20refresh%20I%20got%20the%20attached%20menu%20saying%20%22The%20current%20user%20isn't%20sign%20in%22%20and%20right%20Below%20%22You're%20already%20sign%20in%22.%3C%2FP%3E%3CP%3ETo%20be%20able%20to%20refresh%20i%20have%20to%20click%20on%20%22sign%20as%20different%20user%22%20but%20it%20ask%20me%20that%20for%20query%20to%20each%20SharePoint%20site%20i%20am%20connected%20to.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20process%20then%20become%20really%20cumber%20stone%20as%20it%20takes%20for%20each%20query%20to%20authenticate%20few%20minutes%20to%20get%20my%20token%20accepted%20and%20move%20to%20the%20next%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20why%20it%20make%20the%20MFA%20pop%20up%20for%20query%20even%20after%20sign%20in%20correctly%20with%20one%20%3F%3C%2FP%3E%3CP%3EAny%20way%20I%20could%20authenticate%20once%20and%20for%20all%20and%20stop%20the%20MFA%20bothered%20me%20each%20time%20while%20it%20doesn't%20ask%20for%20it%20with%20other%20App%20like%20One%20Drive%2C%20Teams%2C%20Outlook%3F%20(besides%20moving%20all%20the%20file%20into%20one%20SharePoint%20Site%20or%20sync%20the%20site%20with%20my%20computer%20or%20using%20a%20system%20account%20that%20doesn't%20have%20MFA)%3C%2FP%3E%3CP%3EWhy%20MFA%20doesn't%20detect%20correctly%20that%20I%20am%20authenticate%20while%20I%20am%20sign%20in%20in%20Excel%2C%20in%20Window%20Shared%20Experience%20and%20my%20device%20is%20also%20record%20in%20my%20O365%20account%20%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20Well%20if%20i%20move%20my%20Power%20Query%20Script%20into%20Data%20Flow%20to%20generate%20a%20csv%20that%20consolidate%20all%20the%20file%20will%20DataFlow%20have%20Issue%20with%20MFA%20%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1672336%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAuthentication%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

 

I am starting a new conversation as wasn't able to find any answer to the problem i have.

Here is the use case:

I have multiple excel files spread accross different SharePoint sites. I have a file that consolidate all of them through Power Query. I have of course access to all of the site.

I am sign in excel correctly with my O365 account.

Since we started to activate MFA every few days  when I open the file and hit refresh I got the attached menu saying "The current user isn't sign in" and right Below "You're already sign in".

To be able to refresh i have to click on "sign as different user" but it ask me that for query to each SharePoint site i am connected to.  

The process then become really cumber stone as it takes for each query to authenticate few minutes to get my token accepted and move to the next one.

 

Do you know why it make the MFA pop up for query even after sign in correctly with one ?

Any way I could authenticate once and for all and stop the MFA bothered me each time while it doesn't ask for it with other App like One Drive, Teams, Outlook? (besides moving all the file into one SharePoint Site or sync the site with my computer or using a system account that doesn't have MFA)

Why MFA doesn't detect correctly that I am authenticate while I am sign in in Excel, in Window Shared Experience and my device is also record in my O365 account ?  

 

As Well if i move my Power Query Script into Data Flow to generate a csv that consolidate all the file will DataFlow have Issue with MFA ?


Thanks for your help!

0 Replies