Queries in Power BI

Question

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?

Answer 1

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.