Forum Discussion
Solved
Error in Dataflow Gen 2 loading from Excel file on SharePoint Online
Hi, I am working on a process to take Microsoft Forms data and put it into a database. To do this, I am doing the following steps: 1: Power Automate flow that runs when a response is submit...
Hi tayloramy ,
is your SPO instance direclty accessible by Dataflows (e.g. not on-premises)? If so, you don't need to use a gateway and you would simplify the setup of the dataflows and get better performance. If your issue persists, can you please share the RequestId through DM?
Thanks,
Alessandro
Hi,
I have not, my org enforces MFA when signing into SPO so I can't have something run automatically. This is why I was using dataflow gen 2, that connection will cache the token and ask for MFA on initial set up, but then works fine automatically from then on.
These tokens expire. Be prepared to reauthenticate periodically.