Forum Discussion

AbhishekParsai's avatar
AbhishekParsai
New Member
7 years ago

Table Hide in Power BI

Hello Team ,

 

I created Cube Tabular SSAS data Model and deployed on Azure analysis sever. Total I had 7 table- 3 master table , 3 Mapping table where user has access and 1 master table where I am storing all Column for report. I have hide all six  table while creating solution file .

3 master table are directly connected to my Master table those I am not seeing while creating report , But table where I used rowfiltering using UserName() funtion , I still see in desktop application .These 3 mapping table are not directly connected to my main table . I also dont see option for hiding this 3 mapping table . can you please help me how to hide  this table.

 

 

Need Help

2 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi AbhishekParsai 

    It seems you may try to use RLS. For further,please have a look at below articles.

    https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular

    https://radacad.com/row-level-security-with-ssas-tabular-live-connection-in-power-bi

     

    For 3rd party Links:

    Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

    Regards,

    • AbhishekParsai's avatar
      AbhishekParsai
      New Member
      7 years ago

      Hello Team ,

       

      Thanks for you reply !!

       

      Still my problem is not resolved . My problem is not with row level security. RLS is working for me .

      My problem is with hiding underline tables which are there in Power BI Desktop. As mentioned in my initial post , it is hiding 3 master table but not hiding 3 Mapping table where I have defined RLS.

      Also I don't see Hide option when I try to hide it by right click on table . please refer screenshot . 

       

      The thing which I am not able to understand is Why it is hiding tables partially .Like I  have hide all 6 tables from SSAS Tabular but on 3 tables got hide. what is special about remaining 3 table .

       

      I suspect , reason could be RLS. Since I am defining RLS on this 3 table , Power BI is not hiding it from UI even though I am hiding it from my SSAS solution . Please let me know if this make sense.

       

      Can you please reply on this , I have client deliverable and I am awaiting on this.

       

      Thank you

      Abhishek