topic Re: Semantic Model Usage in DAX Commands and Tips

Semantic Model Usage

gloulakis — Fri, 02 May 2025 17:53:42 GMT

If I use only one semantic model, will unused tables impact the performance

Re: Semantic Model Usage

lbendlin — Fri, 02 May 2025 19:47:36 GMT

How do you define "unused" ? If they are included in the refresh they will incur CU cost.

How do you define "performance" ? You would have to check the xmSQL queries deep in the bowels of Vertipaq to see if these tables may be part of the query plan despite seemingly being "unused". Remember the concept of expanded tables.

Re: Semantic Model Usage

v-menakakota — Mon, 05 May 2025 06:11:19 GMT

Hi gloulakis ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

By unused tables, I meant tables that are present in the semantic model but aren’t used in any visuals, measures, or DAX calculations.

I understand that if these tables are included in the refresh, they will contribute to Capacity Unit (CU) consumption and may affect refresh time. Also, as you mentioned, due to the concept of expanded tables, some of these may still be involved in the query plan even if they’re not directly used.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Re: Semantic Model Usage

v-menakakota — Thu, 08 May 2025 04:49:25 GMT

Hi gloulakis ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.