Query : Authentication

[ohugh]

Hi All,

I'm a medical statistician, and i have a project involving the reporting function of a maternity system. I'm planning on embedding this within the applicaiton itself, and I believe PowerBI will be great for doing this.

My concern is that every trust will need to see personalised reports, and should not be able to see other trusts information (due to data protection). Is there a way in PowerBI i can control the filters of reports via who logs into the application? Is there a feature i could read up on? 

Thanks,

Oliver

[Anonymous · Accepted solution]

HI @ohugh,

I think RLS feature with username should suitable for your requirements, it required a user mapping table. (user info with account)

You can refer to the following link to know more about this:

RLS with UserName() 

Regards,

Xiaoxin Sheng

[ohugh]

Thanks Xiaoxin. A very useful link, will have a go at implementing .

Best wishes,

Oliver