Cannot query internal supporting structures for column

[RohithGn]

Hi All,

I have built a report using an excel file hosted in SharePoint in the Desktop the report works fine also when published to service, the report was working fine. But once the report is refreshed in Service some of my visuals are displaying errors.I suspect the issue maybe due to using calculated columns which are created referencing other calculated columns. Attaching screenshots for reference Please assist - 

Thanks in advance!

Regards,

Rohith

[PadamChopra]

If we use VALUES in calculated column it will convert into Numeric if it is in any type.

In my case, the corresponding output was giving but when we pull the cube in the PowerBI it shows it must be refreshed or recalculated. Rather than i have used distinct, then it was working fine.

[RohithGn · Accepted solution]

Figured it out!! The issue was with one of my calculated column wherein I've used Value function which coverts Text to decimal where as the source is already a whole number which resulted in the error