Forum Discussion

RohithGn's avatar
RohithGn
Helper I
8 years ago
Solved

Cannot query internal supporting structures for column

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

 

 

 

 

Need Help
  • RohithGn's avatar
    RohithGn
    8 years ago

    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

2 Replies

  • RohithGn's avatar
    RohithGn
    Helper I
    8 years ago

    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

  • PadamChopra's avatar
    PadamChopra
    New Member
    6 years ago

    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.