THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jorg Klein

Microsoft Data Platform MVP from the Netherlands

Power BI Analysis Services Connector Security

You can read this blog post at this link:

This blog has moved to There will be no further posts on Please update your feeds accordingly.

You can follow me on twitter:

Published Thursday, March 19, 2015 6:51 PM by jorg

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Barak said:

Hi Jorg

i didn't success with this

in power bi site  the  role not working

only  in power bi desktop

when i publish it the filter gone

when i create live connection from power bi site to tabular

it's  the same

even that i saw the effectiveUserName i need in the profiler

but no filter in the report

August 6, 2015 6:26 AM

Espen said:


I have set up an on-premises Tabular model using Roles to filter data by rows. When logging on locally and using Excel this works great and filters as intended. Then I use the Power BI Analysis Services Connector as a service bus to access my model in the Power BI App. When I log on with the same user account as the Excel scenario my filter does not work and all rows are returned. The user has access to the entire model, not just the specified rows.

I am using Active Directory for user authentication and dirsynch between Azure AD and on-premises AD.

The user I am testing with is not admin.

I have tried to look at the connector settings, but it’s fairly simple and I can’t see what I have done wrong. The connector uses a service account with read and processing user rights.

Why doesn’t Power BI App use the filtering from my tabular model?

August 18, 2015 7:28 AM

Miguel said:

Hi Espen do you have resolves your issue? I have the same, regards

May 23, 2016 11:18 AM

Leave a Comment


About jorg

Jorg Klein, Microsoft Data Platform MVP from the Netherlands.
Privacy Statement