topic Re: Semantic Model refresh activity in Pipelines

Semantic Model refresh activity

Thyagarajulu99 — Fri, 06 Dec 2024 18:57:44 GMT

Hi Team,

I have created a data pipeline to refresh the semantic model using the semantic model activity.

I would like to know the limitation if any tables or columns that are hidden in the semantic model are being ignored during the pipeline execution.

Please help here.

Re: Semantic Model refresh activity

lbendlin — Sat, 07 Dec 2024 02:20:30 GMT

You either refresh a semantic model (or a table or a partition) or you don't. This is entirely unrelated to hidden artifacts.

Re: Semantic Model refresh activity

Anonymous — Mon, 09 Dec 2024 01:30:27 GMT

Hi Thyagarajulu99 ,

When you refresh a semantic model using a data pipeline, hidden tables or columns in the semantic model are generally not ignored during the pipeline execution.

1. Hidden tables or columns are not visible in reports or dashboards, but they are still part of the model and can be used in calculations and relationships.

2. Including hidden tables or columns in your model can impact performance, especially if they contain a large amount of data. It's important to optimize your model to ensure efficient query performance.

3. If you are using DirectQuery mode, hidden columns can still affect query performance and data retrieval, as they are part of the underlying data structure.

Best Regards

Yilong Zhou

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

Re: Semantic Model refresh activity

weinkopfm — Wed, 11 Dec 2024 08:42:04 GMT

Hi,

i've recognized that invisible tables in the semantic models are not updated with the task. Is that a bug? How can i also include them to be refreshed?

Re: Semantic Model refresh activity

weinkopfm — Wed, 11 Dec 2024 09:16:19 GMT

Hi,

i've recognized that invisible tables in the semantic models are not updated with the task. Is that a bug? How can i also include them to be refreshed?

Re: Semantic Model refresh activity

user518520 — Tue, 04 Mar 2025 08:14:56 GMT

So how do you refresh hidden tables? We need these tables refreshed as the tables are bridging tables and we don't want to expose them to self service users. many thanks