none
Is it possible to Open a file from ADLS in Excel?

    Question

  • All,

    Curious if it is possible to open a file from Data Lake Store in Excel?  Has anyone done this, and if so how?

    Thanks!

    Thursday, April 21, 2016 8:42 PM

Answers

  • You can of course download the file and if Excel can read the format, e.g., CSV or TSV, you can open the downloaded copy. However, as Sachin points out, you cannot do it directly against the store.

    Michael Rys

    • Proposed as answer by Michael Amadi Saturday, April 30, 2016 11:51 PM
    • Marked as answer by dcb99 Friday, September 29, 2017 6:37 PM
    Thursday, April 21, 2016 11:08 PM
    Moderator

All replies

  • Hi,

    This is not currently possible. We will be enabling the support in the future where you can use PowerQuery to access data stored in Azure Data Lake Store (ADLS).

    Right now, if you want another visualization tool, you could use Power BI Desktop to access the files.

    1. Follow the steps listed at this link to connect to data in Azure Data Lake Store.
    2. You need to “Get data” from Azure -> Azure Data Lake

    Hope this helps,

    Sachin Sheth
    Program Manager, Azure Data Lake.

    • Proposed as answer by Michael Amadi Saturday, April 30, 2016 11:51 PM
    Thursday, April 21, 2016 8:57 PM
  • You can of course download the file and if Excel can read the format, e.g., CSV or TSV, you can open the downloaded copy. However, as Sachin points out, you cannot do it directly against the store.

    Michael Rys

    • Proposed as answer by Michael Amadi Saturday, April 30, 2016 11:51 PM
    • Marked as answer by dcb99 Friday, September 29, 2017 6:37 PM
    Thursday, April 21, 2016 11:08 PM
    Moderator
  • Hi Michael

    I'm wondering if this has been resolved.

    I'm trying to connect to Azure Data Lake Store from Excel Power Query.

    I don't see the connection available for me in Excel but I see it available in Power BI

    do you know when it will be available in excel?

    Thank you


    Codernater

    Tuesday, May 23, 2017 7:19 PM