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
triseid's avatar
triseid
Frequent Visitor
5 years ago

Hi v-kelly-msft ,

 

Thank you for the response. I created a Data Source based on my data model using Azure Analysis Services connection type. Then I created Datasets from that Data Source. The Datasets aren't able to pull hidden fields. 

 

Is this what you mean by 'load the model?' 

 

Thank you,

Tristan 

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.