Goal:
Not displaying the dimension table and its data in excel
Problem:
I was enable to deny access for the user roles in SSAS about denying access the data from the column but the next thing is that I do not know how dimension table and column not to be available in the excel.
Information:
*The datasource is SSAS
*I have made three user to have access to two tables only.