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
    9 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

Alven's avatar
Alven
Microsoft Employee
9 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
    9 months ago

    Hi Alven, 

     

    We are using SharePoint Online, nothing is on prem. 

     

    I'll reach out to you, thanks!