Cannot query multiple files in Lakehouse

[jashfabric]

Hi
I am new to Fabric and experimenting with notebooks. How can I read multiple files present in a Lakehouse using a notebook?

I tried to read the csv files using this code, but receiving an error:

df = spark.read.format("csv").option("header","true").load("Files/**")

display(df)

Error: Path not found

Appreciate your help.

[Anonymous · Accepted solution]

Hi @jashfabric 
Thanks for using Fabric Community.
You can use the below code:
df = spark.read.format("csv").option("header","true").load("Files")
display(df)

I have created a repro for you. 

Hope this helps. Please let me know if you have any other questions.

[Anonymous · Accepted solution]

Hi @jashfabric 
Thanks for using Fabric Community.
You can use the below code:
df = spark.read.format("csv").option("header","true").load("Files")
display(df)

I have created a repro for you. 

Hope this helps. Please let me know if you have any other questions.

[jashfabric]

Thank you so much @Anonymous !
That helped me. Thanks for the detail explaination.

[Anonymous · Accepted solution]

Hi @jashfabric 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.