Forum Discussion
Semantic Model refresh activity
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.
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.