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

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.  

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

        Hi tayloramy 

        Thanks for confirming. Since the issue is not yet resolved, could you please share the latest error message?