Error while using POWER BI Data Set Hierarchy in Excel pivot

Hi Vemu2022 ，

cannot query internal supporting structures for column <calculate column> because they depend on a column, relationship, measure  that is not processed. please refresh or recalculate the model.
According to above error message, it might be caused by the calculated column formula. Please refer to below similar thread:
Calculated Column Error
Error about using a concatenated calculated column in a SSAS Tabular model

It might also be caused by the processing method, please refer to below blog:
https://biamir.wordpress.com/2015/12/15/fix-cannot-query-internal-structures-for-column-because-they-are-not-processed/

And similar refer:

https://stackoverflow.com/questions/65073314/analysisservices-cannot-query-internal-supporting-structures-for-column-because 

https://biamir.wordpress.com/2015/12/15/fix-cannot-query-internal-structures-for-column-because-they-are-not-processed/ 

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

Best Regards,
Lucien