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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
sra_ifm
New Member

Lakehosue Tables don't show up in semantic model

I create tables through spark but the tables don't show up in the semantic model or sql analytics endpoint. 

sra_ifm_0-1728570428308.png

sra_ifm_1-1728570489267.png

 


I already:
... created a totally new lakehause and readded the tables from the notebook (removing the previous lakehouse first) - same result.
... I added shortcuts for the tables as suggested here - same result

 

Why can't I see the tables?

2 ACCEPTED SOLUTIONS
v-tangjie-msft
Community Support
Community Support

Hi @sra_ifm ,

 

With my testing, it works fine.
My steps are as follows:

(1) Create a lakehouse.

vtangjiemsft_1-1728614203845.png

 

(2)Open a new notebook.

 

vtangjiemsft_2-1728614234833.png

(3) Run the following code in order, and you can see that we have created a new people table in Lakehouse.

vtangjiemsft_3-1728614748385.png

(4) Go back to the lakehouse you just created and click "New Semantic Model".

vtangjiemsft_4-1728615113667.png

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

View solution in original post

sra_ifm
New Member

This way it worked - meaning: adding a notebook to a lakehouse. The other way around not - adding a lakehouse to a exiting notebook. 
This is confusing....

 

Edit:

This worked for the first table added only. And I think I found the reason - this is a known bug:
https://learn.microsoft.com/en-us/fabric/get-started/known-issues/known-issue-643-tables-not-availab...

This is a blocker for us, because we are not able to build semantic models for reporting... But this bug is open since 5 month

At the time: writing there is no solution to that issue

View solution in original post

3 REPLIES 3
sra_ifm
New Member

This way it worked - meaning: adding a notebook to a lakehouse. The other way around not - adding a lakehouse to a exiting notebook. 
This is confusing....

 

Edit:

This worked for the first table added only. And I think I found the reason - this is a known bug:
https://learn.microsoft.com/en-us/fabric/get-started/known-issues/known-issue-643-tables-not-availab...

This is a blocker for us, because we are not able to build semantic models for reporting... But this bug is open since 5 month

At the time: writing there is no solution to that issue

v-tangjie-msft
Community Support
Community Support

Hi @sra_ifm ,

 

With my testing, it works fine.
My steps are as follows:

(1) Create a lakehouse.

vtangjiemsft_1-1728614203845.png

 

(2)Open a new notebook.

 

vtangjiemsft_2-1728614234833.png

(3) Run the following code in order, and you can see that we have created a new people table in Lakehouse.

vtangjiemsft_3-1728614748385.png

(4) Go back to the lakehouse you just created and click "New Semantic Model".

vtangjiemsft_4-1728615113667.png

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

v-tangjie-msft
Community Support
Community Support

Hi @sra_ifm ,

 

With my testing, it works fine. There is a delay after creating the table, can you wait for a while and then click New Semantic Model again?
My steps are as follows:

(1) Create a lakehouse.

vtangjiemsft_1-1728614203845.png

 

(2)Open a new notebook.

 

vtangjiemsft_2-1728614234833.png

(3) Run the following code in order, and you can see that we have created a new people table in Lakehouse.

vtangjiemsft_3-1728614748385.png

(4) Go back to the lakehouse you just created and click "New Semantic Model".

vtangjiemsft_4-1728615113667.png

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.