Forum Discussion

msksenthil's avatar
msksenthil
Icon for Helper III rankHelper III
4 years ago

Dataflow not supported dynamic sources

Hello,

I am trying to combine the list of Excel sheets stored in the drive using functions. It is working fine with the desktop. However, Dataflow/Datamart does not support the same.

 

I know that we can use the relative path option if our data source is API/Web. But, how can we fix files in the Folder?

Many thanks in advance!

 

 

dataflow
Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    4 years ago

    Hey msksenthil ,

     

    instead of using the Excel.Workbook command use the Folder.Files() connection. If your files are located on an on-premises network drive you have to be aware that you need an on-premises gateway.

    I recommend to move the files into a SharePoint folder (assuming that that SharePoint online is used in your organization)

    Hopefully, this helps to tackle your challenge.

     

    Regards,

    Tom 

    • msksenthil's avatar
      msksenthil
      Icon for Helper III rankHelper III
      4 years ago

      Thanks, TomMartens 

       

      However, when we use that approach, it will combine the tables and return only the sample file columns and missing the other columns.