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...
Need Help
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