Access XLS data residing in an azure blob

[zinyos]

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

[zinyos · Accepted solution]

@lbendlin The link you provided explains how to solve the issue with the Power BI Desktop which is (as far as I know) not available for Mac. Also Excel Mac does't provide the needed functionality, but on Win it does.

Meanwhile I was able to solve it and posted the solution as a reply to my Stackoverflow question: https://stackoverflow.com/questions/75584492/import-data-from-azure-blob-storage-in-excel-mac

[lbendlin]

You specified a text string as your source. Instead, specify an actual source 

Azure Blob Storage - Power Query | Microsoft Learn