Forum Discussion

zinyos's avatar
zinyos
New Member
3 years ago
Solved

Access XLS data residing in an azure blob

I need to import data from an XLSX sheet, stored in an azure blob. It'a a simple file with one table only.

 

I've seen Excel screenshots showing direct import from Azure blob. But this feature is obviously not implemented within Excel(Mac)

 

So I tried to use PowerQuery for this the first time (please excuse if I'm asking a too basic question):

I copied the SAS URL for the File from the Azure Storage Explorer to clipboard (set to public access).

I created a new blank query in Excel(Mac)

let
  Quelle = ""
in
  Quelle

Pasted the URL into the quotation marks, btw Quelle means Source 

Saved and returned to Excel, hoping to see my data there what didn't happen. I'm seeing a cell with the source URL, instead the table content.

 

What am I missing here? Do I need to create a 2nd query for the Excel Sheet? How do I need to do this?

 

Thanks

Zin

2 Replies