Reply
Highlighted
Member
Posts: 105
Registered: ‎09-14-2017

Unable to Open .xls Files From Azure Data lake

Hello,

I am trying to open some .xls files that are located in Azure Data Lake. When I use Get Data -> More -> Azure -> Azure Data Lake, navigate to where the files are, and try to combine the files I get the following error:
Capture2.PNG

However, if download the .xls files to my local machine and use Get Data -> More -> Folder, point it to the local copies and combine the files, the process works as expected and I am able to see the contents of the files. Does anyone have any suggestions as to why this is the case or what can be done to resolve it?

 

Thanks

Community Support Team
Posts: 7,441
Registered: ‎08-14-2016

Re: Unable to Open .xls Files From Azure Data lake

Hi @vega,

 

You can refer to below steps to combine these xls files.

 

1. get data from azure data lake.

1.PNG

 

2. Navigate to files list.

2.PNG

 

3. Add custom column to analysis excel files.

#"Added Custom" = Table.AddColumn(Test, "Custom", each Table.PromoteHeaders(Excel.Workbook([Content])[Data]{0})),

5.png

 

4. Use Table.Combine function to merge these files.

4.PNG

 

Full query:

let
    Source = DataLake.Contents("xxxxxxxxxxxxxx"),
    Test = Source{[Name="Test"]}[Content],
    #"Added Custom" = Table.AddColumn(Test, "Custom", each Table.PromoteHeaders(Excel.Workbook([Content])[Data]{0})),
    Custom1 = Table.Combine(#"Added Custom"[Custom])
in
    Custom1

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |