Unable to create a new semantic model nor update the default model from our lakehouse

[gswartwood]

Following this documentation, I am trying to update the default semantic model. I am unable to see the reporting tab in order to accomplish this task. I created the lakehouse. The shortcuts to KQL tables in an eventhouse and the eventhouse itself was created by me.

Here is the lakehouse view:

and here is the SQL Analytics Endpoint view:

Ultimately I am trying to get the default semantic model to show the tables I added to the lakehouse. I have enabled syncing of default semantic model but it doesn't help.

This behavior seems to invalidate the claims in this banner:

What is going on?

[Anonymous]

Hi @gswartwood ,

1.If you can't find the Reporting option in the UI several times, in this case, you can try another UI, because some UIs may not support it.

2.For your third requirement, you may also need to consider the difference between the licenses of your workspace, which may be different for different licenses.

In response to your question about the problem after the update, I think the following link will help you resolve the issue.

Known issue - Tables not available to add in Power BI semantic model - Microsoft Fabric | Microsoft ...

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[gswartwood]

Greetings @Anonymous,

1. I am following Microsoft Learning pages on how to perform these actions and there are no other UIs as far as I can find.

2. I don't know if you didn't read in my initial message that I had a semantic model that included these KQL tables, the model stopped working, and now I can't create a new semantic model with these tables. Creating a new KQL table and adding it to the lakehouse makes that table available to new semantic models. This can't be a license issue because there is no license differences between KQL tables in the same KQL database. This issue seems to be related to the KQL tables and interaction w/ the lakehouse. 

[Anonymous]

Hi @gswartwood ,

I can offer you a couple of suggestions that will hopefully help with the problem you are experiencing.

1.Ensure Lakehouse Sync is Enabled:

Verify that the option to sync the default Power BI semantic model is enabled.

Sometimes changes may not appear immediately. Wait for a few minutes and refresh the page to see if the tables appear.

2.Manually Update the Model:

If automatic updates don’t work, you might need to manually trigger an update. Go to the settings of your lakehouse and look for an option to manually sync or refresh the semantic model.

3.Verify Permissions:

Ensure you have the necessary permissions to view and update the semantic model.

4.Clear Cache:

Clear your browser cache or try accessing the lakehouse from a different browser or incognito mode to rule out any caching issues.

If you have any other questions, you can check out the link I sent you to possibly help you with what you need.

https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models#sync-the-default-power-bi-se...

Data modeling in the default Power BI semantic model - Microsoft Fabric | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[gswartwood]

Greeting @Anonymous,

1. I believe this setting has already been turned on which I have shown in image #3 of my previous message. If this is not the setting you are talking about, please give explicit instructions of how to find it.

2. I cannot manually trigger the refresh of the semantic model. As I mentioned in the previous message, the UI to trigger a refresh of the UI is not showing up for me. All documentation that I find points to a Reporting tab that should be showing up but isn't.

3. I am a workspace admin and was the person who created the lakehouse, eventhouse, and KQL database. When looking at the lakehouse's default semantic model, it says that I have all permissions. What more would I need?

4. Clearing cache or opening a session in incognito mode did not work.

Here is an update to the issue: When I created a new KQL table and added it to the lakehouse via a shortcut, it showed up in the lakehouse's default semantic model and was available as a table that could be used in a new semantic model. At this point, I deleted the lakehouse and created a new one. I added shortcuts to these existing KQL tables. At this point, only the latest created table showed up in the default semantic model.

At one point, all table shortcuts to my KQL tables showed up in the default semantic model. Now only one of them is. All of the KQL tables have OneLake availability turned on. Any ideas?