cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 43 members 888 guests
Please welcome our newest community members: