Forum Discussion
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...
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.
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
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
Perhaps that Workaround to connect to Power BI dataflows from Power Query in Excel – (thebiccountant.com) could help
- Hi Sergei,
Unfortunately that appears way too difficult for my abilities, I don't think it will help me
Thanks
DesSorry, I personally have no practical experience with that.
- Thanks Sergei,
I have managed to download what I need as a JSON file and then use an online converter to change to a csv file which I can work with !!
So I'm happy enough, pity the Query would not work for me.
Thanks for your input
Des