Forum Discussion

tayloramy's avatar
tayloramy
Super User
11 months ago
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...
Dataflow
  • Alven's avatar
    Alven
    10 months ago

    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

tayloramy's avatar
tayloramy
Super User
11 months ago

Hi BhaveshPatel, 

 

I would prefer to use a notebook, however that makes auth with SPO challenging as I'm not allowed to have a service principal for this site - I need to use OAUTH. 

 

Do you know of a nice way to handle accesing SPO from a notebook while using a user's credentials? Note that my org also has MFA enforced for access outside of our network. 

 

Thanks,

Taylor

v-aatheeque's avatar
v-aatheeque
Community Support
11 months ago

Hi tayloramy 

I just wanted to check in have you been able to make any progress with accessing SPO from a notebook using OAuth and MFA?

  • tayloramy's avatar
    tayloramy
    Super User
    11 months ago

    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. 

    • lbendlin's avatar
      lbendlin
      Super User
      11 months ago

      These tokens expire. Be prepared to reauthenticate periodically.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      11 months ago

      Hi tayloramy 

      Glad to hear your issue has been resolved. If any of the responses here helped address the problem, we’d appreciate it if you could mark it as a solution. This will also help other community members who might face a similar issue.

      Thanks for being part of fabric community forum.





      • tayloramy's avatar
        tayloramy
        Super User
        11 months ago

        Hi v-aatheeque, The issue has not been resolved.