Forum Discussion
Issue with adding new tables in Semantic Model
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
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.
6 Replies
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!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
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!
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 measures3.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 LearnPlease 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
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.
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
