Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
asankab
Helper I
Helper I

Error when reading a ADLSGen2 csv from a synapse notebook while the private endpoint is enabled

Hi,

  • With a SASS token i was able to read the data from the notebook (when the network access of the storage account is public) interactive mode.
  • Also, i was able to read the data via a pipeline copy activity (when the synapse managed private enpoint is enabled (note at this time the storage account public access is disabled, plus a link service) 

But when i tried to read the .csv data which is available inside the same ADLSGen2 container from a synapse spark notebook it fails wuth the below error?

 

AnalysisException: [PATH_NOT_FOUND] Path does not exist: abfss://<<root-folder>>@<<containername>>.dfs.core.windows.net/data/sales.csv

 

any support to identofy the cause of the issue is and how to get it resolved would be very much appreciated!

 

Thanks

1 ACCEPTED SOLUTION

Thanks for the hint v-gchenna-msft!

 

Was able to find and fix the issue, the problem was with the path. Now its working! 😊

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @asankab ,

Thanks for using Fabric Community.
Can you please share the screenshot of the issue along with the code?
Do you have proper access to it? and did you cross checked the abfs path?

If you can provide these details, I would be able to guide you better.

Here is the code, I am using to read the .csv

 

file_path = "abfss://data@adlsgen2x.dfs.core.windows.net/data/sales.csv"
df = spark.read.csv(file_path, header=True, inferSchema=True)
df.show(5)

Thanks for the hint v-gchenna-msft!

 

Was able to find and fix the issue, the problem was with the path. Now its working! 😊

Anonymous
Not applicable

Hi @asankab ,

Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.