Profiling user access to report with rule on Tabular SSAS data source

[MattiaMaetini]

Hi all,

I have a PBI report linked via live connection with a Tabular SSAS data model.

Scenario: 3 pages, every one use specific table from data model in exclusive way.

Goal: enable a group to see only one page.

I can't use RLS via Tabular for achieve the result.

My idea (workaround): hide access to specific tables used into the pages users don't have to access --> it doesn't run (user from this group see all data in all pages).

Any suggest about this idea?

BR,
M

[amitchandak]

@MattiaMaetini , check if this approach can help

https://www.youtube.com/watch?v=FrEDZZXiit8

[MattiaMaetini]

Tks for your answer.

Unfortunatelly I have to user defined group into our Active Directory, I'm searching some tips starting from Rule into Tabular SSAS.

M