Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hidden fields unhidded after changing ODBC data source parameters

Hi, 

 

I have created a report with a parameter name "ODBC_Source ".

This parameter is filled with the name of ODBC source definied in the ODBC data source application.

In the PowerQuery editor, I used the M formula 

 

 

= Odbc.DataSource("dsn="&ODBC_Source, [HierarchicalNavigation=true])

 

 

 in order to connect to my data source. 

Everything works fine with my dev odbc source, but when I decide to change the "ODBC_Source" for my Production source, all hidden fields become visible... 

 

How can I avoid this ? 

 

Thanks for your help.

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Hidden field are only there for cosmetic reasons. As soon as you give your users access to the data model (as you should)  then they can see all fields regardless.

     

    If you don't want users to see certain data points - don't include these data points in your dataset.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      My hidden fields are keys used to join table. So they have to be included in the dataset. 

      But for a better user exeperience, I want to keep them hidded ( it's useless to see id fields).

      I think it's the purpose of the hide button.