Forum Discussion

jose_henrique's avatar
jose_henrique
Frequent Visitor
2 years ago

Load data from ADLS to Lakehouse using Notebook

So, here's my situation: In Dynamics 365 F&O, i have an active Export to Data Lake action, where it saves in folders in my storage the data itself in a headerless CSV file and a JSON with the metada...
data engineering
Data Integration
data science
DennesTorres's avatar
DennesTorres
Power Participant
2 years ago

Hi,

Did you tried to create a shortcut to the ADLS in the Files area of the lakehouse and then read the data as if it's local to the lakehouse, converting from the Files to tables? 

Kind Regards,

 

Dennes

jose_henrique's avatar
jose_henrique
Frequent Visitor
2 years ago

so, what i did was connect the files and then transforming using dataflow gen 2 (because the headerless csv and the header file), but now i'm facing another issue: i cant combine 2 csv files (because they're headerless):

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

    Hi jose_henrique 

     

    Apologies for the delay in response.

    Thanks for using Microsoft Fabric platform and posting your question here.

    Just wanted to check whether your issue got resolved, please do let us know in case of any further queries.

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

      Hi jose_henrique 

       

      Following up to see whether your issue got resolved, please do let us know in case of any further queries.