Cannot refresh or create semantic models

[aldsmith]

Hi,

I'm fairly new to Fabric and wonder if I'm approaching this correctly. I have created a lakehouse containing a table and would like to connect to this table in power bi. It seems like a semantic model was automatically created when I created the lakehouse, but has not refreshed since I created the tables.

When attempting to create a dashboard linking to the semantic model, I get 'Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.'

I think this is because of the refresh issue. However, when I go to the refresh button, there is no option to refresh, only to view refresh history:

Further, when I go back into the data lakehouse to create a new semantic model instead, this seems also to be greyed out:

Is it possible that this is some issue with permissions? I am on a free trial.

Many thanks,

Alex

[v-tsaipranay · Accepted solution]

Hi @aldsmith;,

Thanks for reaching out to the Microsoft fabric community forum.

The difficulty in refreshing or creating semantic models after setting up a Lakehouse is likely due to the limitations of your free trial account, which impacts the connection to your Power BI reports. Please follow these steps to resolve the issue:

• Go to the semantic model (Lakehouse > SQL Analytics Endpoint > Default semantic model settings > turn on Sync the default model. The model will update when you add more rows of data to your tables.
  
• Navigate to the SQL Analytics Endpoint associated with your Lakehouse. From there, check if you can manage the default semantic model, as you mention that you want to give connection from lake house to power bi initially, we need to sync it.

To synchronize the default semantic model, please refer to the link below:

https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models#understand-whats-in-the-defa...

• If creating a new semantic model is also greyed out, verify that your workspace is properly set up and that you are logged in with the correct credentials that match your Fabric account.
• Ensure that you have sufficient permissions on both the Lakehouse and the associated workspace. As a trial user, your access might be limited. You may need at least a Contributor role to consume items or an Admin role for full access.
• Also make sure that you have these roles, or else you should request access or an upgrade from an administrator.

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

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

Thank you.

[v-tsaipranay]

Hi @aldsmith, 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.