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
sriniwas_msbi
New Member

Lakehouse tables not accessing using sql endpoint through pyspark

Hi Team,

i am connecting the tbales and views in lakehouse using sql endpoint connection string from pyspark note book. but i am not able to access the views and gettingbelow error.

"[TABLE_OR_VIEW_NOT_FOUND] The table or view".

 

can't we access lakehouse  views from pyspark note book? please suggest.

4 REPLIES 4
Anonymous
Not applicable

HI @sriniwas_msbi,

Any update on this? Can you please share some more detailed information about this issue?

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

HI @sriniwas_msbi,

Have you setting the default Lakehouse on the left side? AFAIK, these operations will check on the default Lakehouse contents at first. So if you haven't configured it, then it will return the error of table view not found.

Explore the lakehouse data with a notebook - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng

Hi Xiaoxin ,

Thanks. I set default lake house already. i have only one lake house in my workspace and i am using JDBC connetion string so not able to access the views using pyspark notebook. can you help on this how to access the views from notebook using pyspark.

Anonymous
Not applicable

Hi @sriniwas_msbi,

So you mean you are using notebook to read data from external with jdbc connection string? If that is the case, have you tried to query data from tables based on this connection?
Any security or permissions settings applied to the data source or credentials that limit the operations?
Regards,

Xiaoxin Sheng

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

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