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 ,

 

I'm afraid that the issue is that you are not granted the access for the hidden fields in AS model,that's why once the field is hidden,you are not able to view it.Pls check about it.

Below is a reference you may need:

https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/grant-cube-or-model-permissions-analysis-services?view=asallproducts-allversions

 

 

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 

 

I greatly appreciate the troubleshooting. I don't think that is the reason though as I have owner role and I can also use the hidden fields in a PowerBI Desktop report. 

 

Thank you!

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

    Hi triseid ，

     

    Sorry for not being able to help.Since I cant reproduce your senario,would you pls create a support ticket via below link and our relevant engineer will help to handle it:

    Support | Microsoft Power BI

     

    Best Regards,
    Kelly

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