Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape 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.
I create tables through spark but the tables don't show up in the semantic model or sql analytics endpoint.
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?
Solved! Go to Solution.
Hi @sra_ifm ,
With my testing, it works fine.
My steps are as follows:
(1) Create a lakehouse.
(2)Open a new notebook.
(3) Run the following code in order, and you can see that we have created a new people table in Lakehouse.
(4) Go back to the lakehouse you just created and click "New Semantic Model".
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.
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
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
Hi @sra_ifm ,
With my testing, it works fine.
My steps are as follows:
(1) Create a lakehouse.
(2)Open a new notebook.
(3) Run the following code in order, and you can see that we have created a new people table in Lakehouse.
(4) Go back to the lakehouse you just created and click "New Semantic Model".
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.
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.
(2)Open a new notebook.
(3) Run the following code in order, and you can see that we have created a new people table in Lakehouse.
(4) Go back to the lakehouse you just created and click "New Semantic Model".
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.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
34 | |
31 | |
21 | |
11 | |
8 |
User | Count |
---|---|
52 | |
40 | |
29 | |
13 | |
12 |