CODEWITHSUNDEEP
dynamicplsqlpowerbi
Dhivya Sivaraman
Dhivya Sivaraman

Reputation: 71

Queries in Power BI

Is it possible to filter data based on the user who login to the dashboard? How to get the user details on login?

Also is dynamic data filtering possible in power BI? If so please give some useful links.

Is it possible to filter data by SQL queries?

Upvotes: 7

Views: 607

Answers (3)

Alexis Olson
Alexis Olson

Reputation: 40204

This is now possible using Row Level Security.

You can define different roles that filter the data in different ways based on the user.

You can read the user by using USERNAME() or USERPRINCIPLENAME().

Upvotes: 2

A_Arnold
A_Arnold

Reputation: 4019

Power Bi uses the term Direct Query to pull live data from the database. This option is available when connecting to the database (after you click the Get Data button).

In the same screen while you are connecting to the database there are Advanced Options which allows you to pull data using a query.

As a side note Direct Query does not work with casting and has other limitations. Creating a view can allow more flexibility and pulling the data from the view can work better.

For More Info

Upvotes: 1

Lukasz P.
Lukasz P.

Reputation: 2229

There's a yes and a not yet on this one right now, but it is something we're looking into. First the yes part: We support live data connectivity to Tabular models on premises hosted in SSAS. When you use that option, any row level security you implement in SSAS on premises is automatically applied.

Second the not yet part: we're looking to make this kind of security enforcement work more broadly across other data sources. We still in the requirements gathering phase for this. Suggest you provide a detailed writeup of your requirements at support.powerbi.com so we can track this and get back to you when it's available.

Upvotes: 4

Related Questions