Forum Discussion

ramonsuarez's avatar
ramonsuarez
Advocate II
2 years ago
Solved

Programmatically upload files to Fabric?

Hi, 

 

We want to be able to periodically upload a set of files to fabric, always to the same folder and overwritting the previous versions of those files. 

 

We have a PowerShell script in a server that we can run to extract the data (xml). Then it saves the files to SharePoint, but we would like to save them directly into our LakeHouse without intermediary steps. 

 

I've checked the API documentation and found how to do many operations, but not how to upload files directly to a folder in the Lakehouse. 

 

I've also found that service principals are not supported when using the Microsoft Fabric REST APIs. 

 

Can you help? Thanks!

data engineering
  • govindarajan_d's avatar
    govindarajan_d
    2 years ago

    Hi ramonsuarez ,

    You can also try installing 'OneLake' program in the server and you can use it just like how you use 'OneDrive'. This approach will require just adding a copy statement in your existing powershell script 

     

8 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi ramonsuarez 

     

    Thanks for the ask and using the Microsoft Fabric Community.


    At this time, we are reaching out to the internal team to get some help on this .
    We will update you once we hear back from them.

    Appreciate your patience.

     

    Thanks

     

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi ramonsuarez 

       

      Could you please confirm whether you are using Notebook or Pipeline?

      What is the source of your data, will it be accessible from Notebook?

       

      Thanks

      • ramonsuarez's avatar
        ramonsuarez
        Advocate II
        2 years ago

        Neither. The script runs on a server and extracts the tables from the source system as xml files.