Issue with adding new tables in Semantic Model

[Sreejisha]

When I add any new table to my semantic model. My report crashes. Even relationship was not created within the tables. This never happened before. Does anyone know the reason and what to do?

I have Mixed storage mode. Data is saved in Warehouse

[v-prasare]

Hi @Sreejisha ,If your issue got resolved, please mark helpful post as answer by clicking accept as solution. by doing so, it will be easy for community members to identify when they run into similar issues.

@suparnababu8 & @maruthisp ,  Thanks for your prompt response. 

Thanks,

Prashanth Are

MS FAbric community support

[Sreejisha · Accepted solution]

Thanks @suparnababu8   @maruthisp , I figured it out. I checked a Preview feature few days ago, ' Live edit of Power BI Semantic Model in Direct Lake mode'. I unchecked it and refreshed my semantic model and it looks working now. 

[maruthisp]

Hi Sreejisha,

Could you please do the following bebug steps to find the actual poblem:
1. Check if it a known issues in Fabric support page - Problèmes connus avec Microsoft Fabric
2. Validate table schema - no circular dependencies or invalid ata types, any calcualted columns or measures

3.Create a new sematic model and try to add the same table.

4.Check storage mode - mixed mode can cause incompatability - tables are not partitioned properly

5. If you are using Power BI desktop by connecting semantic model - check carsh logs

If the issue still appears, then raise a ticket. - How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Please let me know if you have further questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[Sreejisha]

Nothing works. Even for Live connection same issue. Could you please let me know how to raise ticket. If you could send the link it will be helpful. Thanks

[suparnababu8]

Hi @Sreejisha 

You can rasie Support ticket here - Microsoft Fabric Support and Status | Microsoft Fabric

How to raise support ticket, read this - How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[suparnababu8]

Hi @Sreejisha 

I replicated your scenario, it's working for me. Initially I created a sematic model with three tables and later I added one table it's working fine.

Similar kind of issues already reported in community by otherusers earlier. reason behind this issue is as follows.

• If you are using new table addition with direct lakemode, sometimes, Direct lake mode connection refresh  failed due to another table causing the issue. So, try to refresh the sematic model until refresh succeded.
• There is sync issue also cause for this error, as reported by you your tables are stored in warehouse, so, make sure that default model sync is turned on . Read more here Solved: Re: Lakehouse and semantic model issues - Microsoft Fabric Community
  
• If it is creashing your report, you can use previous version for your sematicmodel up to date.

If you want know about sematicmodel pls read this Default Power BI Semantic Models - Microsoft Fabric | Microsoft Learn

Still if your are facing the issue, I recommedn you raise support ticket.

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!