Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cannot access data from ADL Gen2

Hi All,

I tried accessing the data from a .txt file store in ADL Gen2 , when i connected successfully all it is showing me is the information of the file and not the actual data in the files. Please need help.

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks Everyone. Issue resolved. I clicked on the query and clicked on binary and was able to get the original data.

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous how are you connecting to the file on ADLS Gen2? Are you using direct link to the file or what? Can you share M script by clicking advanced editor.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Get Data> Chose ADL Gen2 > copy pasted the url > Authenticate using Account Key.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

     

    How is your delimited might be the source of your issue.

    As for csv  it is delimited by ",". But you  are using a text file.

     

    Please check.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      So what is the solution change it to .csv type?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      i canged the source file as .csv instead of .txt and it is still the same.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Everyone. Issue resolved. I clicked on the query and clicked on binary and was able to get the original data.