SOLVED
Home

Reading .csv stored in Azure Blob Storage from Excel

Highlighted
Federico Fontana
Visitor

I've been able to create a storage account, then a container, than a blob storing a .csv file. I've successfully been able to download the .csv file from Azure itself and using Python as well via the azure-storage package. This is to confirm that external sources (i.e. Python) are able to import/export blobs. The .csv stores a numeric table with header in the first row.

 

The second step is to import the same data in Excel 2016. The steps that I'm following from Excel are:

New Query --> From Azure --> From Microsoft Azure Blob Storage --> provide <Account_name> and <Key> --> Navigator. From here, I can see that dataset.csv file in the container.image.png

 However, clicking the button "load" in the Navigator only allows to download the table in the previous picture in excel, and not the data stored in those files.

 

image.png

 

 I've explored the add ons "Design" and "Query" to look for a button to download the data stored in those blobs but unsuccessfully.

 

Question: how to import the numberic data stored in one of the .csv in Azure Blobs listed in the Wizard?

1 Reply
Solution

Hi,  don't load the connection, edit the connection

 

edit.jpg

then in the Power Query screen, filter the 'Name' column to get the files you want, then click on the column 'Content' to actual get the data.

 

content.jpg

 

Sorry my example sheets have only one column, but you can use the Power Query features to transform the files.