Forum Discussion

Federico Fontana's avatar
Federico Fontana
Copper Contributor
Sep 05, 2017
Solved

Reading .csv stored in Azure Blob Storage from Excel

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...
BI & Data Analytics
Get & Transform Data
  • Tanya Denton's avatar
    Tanya Denton
    Sep 05, 2017

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

     

    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.

     

     

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

Tanya Denton's avatar
Tanya Denton
Iron Contributor
Sep 05, 2017

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

 

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.

 

 

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

DesOwens's avatar
DesOwens
Copper Contributor
Mar 20, 2021
Hi,
I've had the same issue with excel 365. The only difference is that when i attempt to do as above, and use the power query feature it comes up with an error as follows

Unable to connect

We encountered an error while trying to connect.
Details: "We found extra characters at the end of the JSON input."

Can you help me with this ?
Des

Resources