Forum Discussion

triseid's avatar
triseid
Frequent Visitor
5 years ago

Viewing hidden fields in PowerBI Report Builder

Hi,   I'm building a report in PowerBI Report Builder and my data source is an Analysis Services Tabular model. There are hidden fields in the data model that I need to use for the report, however ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  triseid ,

 

Are you using a live connection or import as the connnection type?

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

triseid's avatar
triseid
Frequent Visitor
5 years ago

Hi Kelly,

 

The issue is occuring in PowerBI Report Builder (not PowerBI Desktop). I am unfamiliar with distinguishing between connection type in the Report Builder application. 

 

Thank you!

Tristan 

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi triseid ,

     

    Would you pls check you could see fields in AS model?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

    • triseid's avatar
      triseid
      Frequent Visitor
      5 years ago

      Hi v-kelly-msft 

       

      Thanks for the continued troubleshooting. I can see the field in AS model, but they are greyed out because they are hidden. 

       

      I tried recreating the issue with a new report but I wasn't able to. I created a one field report,  then I hid the field in AS, and the report continued to work okay. However, I'm still experiencing the issue with more complicated reports, where if a field gets hidden, the entire report breaks until the field is removed or unhidden. I haven't been able to isolate what is the exact difference causing the issue.