Connection issue between CSV and XLSX

%3CLINGO-SUB%20id%3D%22lingo-sub-2627881%22%20slang%3D%22en-US%22%3EConnection%20issue%20between%20CSV%20and%20XLSX%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2627881%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20you%20are%20all%20doing%20good.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20Online%20Library%20that%20contains%20several%20CSV%20files%20and%201%20xlsx.%26nbsp%3B%3C%2FP%3E%3CP%3E(for%20the%20little%20story%20and%20to%20be%20as%20accurate%20as%20possible%2C%20those%20CSV%20file%20are%20generated%20by%20Power%20Automate%20out%20of%20multiple%20SharePoint%20lists)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20CSV%20files%20are%20comma%20delimited.%20Since%20I%20need%201%20single%20file%20that%20consolidates%20all%20my%20CSVs%2C%20I%20use%20Power%20Query%20to%20create%20connections%20into%20my%20xlsx%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20i%20created%20the%20document%2C%20everything%20was%20smooth.%20I%20closed%20the%20document%2C%20came%20back%20to%20it%20the%20next%20day%20and....i%20got%20this%26nbsp%3B%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22fig1.png%22%20style%3D%22width%3A%20539px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301787i7ADF9A5E0630A7B4%2Fimage-dimensions%2F539x239%3Fv%3Dv2%22%20width%3D%22539%22%20height%3D%22239%22%20role%3D%22button%22%20title%3D%22fig1.png%22%20alt%3D%22fig1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20i%20click%26nbsp%3B%20%22connect%22%20%2C%20the%20message%20in%20yellow%20changes%20and%20says%20%22%20the%20current%20user%20isn't%20signed%20in%20%22%20...while....%20it's%20written%20down%20there%20!!%20i'm%20signed%20in%20!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20click%20%22Sign%20in%20as%20a%20different%20user%22%20%2C%20I%20get%20the%20box%20with%20my%20mail%20address%20(my%20company%20uses%20single%20sign%20on)%26nbsp%3B%20and%20i%20select%20my%20email%20address%20and%20it%20works.%20the%20problem%20is...it%20works%20for%20the%20day...and%20next%20day%20when%20i%20come%20back%2C%20it's%20not%20working%20again%2C%20i%20have%20to%20sign%20in...and%20this%20sign%20in%20box%20comes%20for%20each%20CSV%20file%20that%20is%20connected%20(there%20are%2015).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20someone%20have%20any%20idea%20what%20is%20happening%20and%20how%20i%20could%20solve%20this%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20a%20lot%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2627881%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2628269%22%20slang%3D%22en-US%22%3ERe%3A%20Connection%20issue%20between%20CSV%20and%20XLSX%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2628269%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1124082%22%20target%3D%22_blank%22%3E%40Kaddrik%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhich%20connector%20do%20you%20use%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

hope you are all doing good.

 

I have a SharePoint Online Library that contains several CSV files and 1 xlsx. 

(for the little story and to be as accurate as possible, those CSV file are generated by Power Automate out of multiple SharePoint lists)

 

The CSV files are comma delimited. Since I need 1 single file that consolidates all my CSVs, I use Power Query to create connections into my xlsx file.

 

When i created the document, everything was smooth. I closed the document, came back to it the next day and....i got this  ...

 

fig1.png

 

if i click  "connect" , the message in yellow changes and says " the current user isn't signed in " ...while.... it's written down there !! i'm signed in !!!

 

If i click "Sign in as a different user" , I get the box with my mail address (my company uses single sign on)  and i select my email address and it works. the problem is...it works for the day...and next day when i come back, it's not working again, i have to sign in...and this sign in box comes for each CSV file that is connected (there are 15).

 

Would someone have any idea what is happening and how i could solve this ? 

 

thanks a lot !

 

2 Replies

@Kaddrik 

Which connector do you use?

Hello Sergei,

I guess you mean in Power Automate ...right ? in Power Automate I use the SharePoint connector to create the CSV. it's a simple flow. I click the button on my powerapps form, it uses the SP Connector to generate the CSV into my SP library then sends back the result to the form so it can open the file automatically once all the CSVs are generated.