Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everyone,
we created a data set and published to PBI service and given the access to users to connect in excel to do pivoting,
they asked us to create date Hierarchy and it should work like any other hierarchy like below
i created a date hierarchy in power bi when i tried to use i am getting below error
could you please suggest me what i need to do to make the hierarchy work in excel
Thanks
Vemu H
@PowerBIDesktop @Excelpivot
Solved! Go to Solution.
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...
And similar refer:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
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...
And similar refer:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |