cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TomasNiemczyk Frequent Visitor
Frequent Visitor

SSAS roles - Dimension Data filtering doesn't work

Hi everyone,

 

I'm trying to figure out, how to filter specific members for every single worker in our company. "Dimension Data" filtering in SSAS works in SSRS and Excel, but not in Power BI.

 

Do you have any ideas?

 

Thank You.

4 REPLIES 4
Moderator v-caliao-msft
Moderator

Re: SSAS roles - Dimension Data filtering doesn't work

@TomasNiemczyk,

 

What do you mean by not works in Power BI? I have tested it on my local environment, we can filter the data by using a slicer, and drag the customer dimension to this slicer visual.

 

In your scenario, please provide us more details information about it, if possible provide us some screenshots, so that we can make further analysis.

 

Regards,

Charlie Liao

Phil_Seamark Super Contributor
Super Contributor

Re: SSAS roles - Dimension Data filtering doesn't work

Are you using MD or Tabular SSAS?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

TomasNiemczyk Frequent Visitor
Frequent Visitor

Re: SSAS roles - Dimension Data filtering doesn't work

@Phil_Seamark

 

We're using MD SSAS.

TomasNiemczyk Frequent Visitor
Frequent Visitor

Re: SSAS roles - Dimension Data filtering doesn't work

@v-caliao-msft

 

We created roles for a few of our workers which have permissions only for some specific destinations. This filtering works in SSRS and in Excel, but not in Power BI.

 

Airport.PNG