This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
I am following this tutorial
https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/tutorial-use-pandas-spark-pool
I've setup as per the instructions however when i run the code below i am met with a 401 error
#Read data file from URI of default Azure Data Lake Storage Gen2
import pandas
df = pandas.read_json('https://adlsaccountname.dfs.core.windows.net/synapse/response.json')
print(df)
Error:
HTTPError: HTTP Error 401: Server failed to authenticate the request. Please refer to the information in the www-authenticate header.
The managed identity has Blob Contributor role as do I (i am also owner of the sub).
Can some assist?
I've made progress by parameterising the adls path however i am now being met with a file not found error.
import pandas
import json
account_name="*************alds01"
container_name="synapse"
relative_path="json/response.json"
adls_path='abfss://%s@%s.dfs.core.windows.net/%s' % (container_name, account_name, relative_path)
print(adls_path)
#read csv file
df = pandas.read_json(adls_path)
print(df)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 27%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
401 unauthorized response should be used for
missing authenticatin
*
The error was due to the adls path not being formatted correctly. I have resolved this however I am now being met wiht a file not found error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Given that the file not found is a different problem, can you ask it in a new question thread?